Jump to content


Caspio Rockstar
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Mathilda

  1. As far as I know, it's not possible. Caspio mailers send email on behalf of your email address, therefore you cannot use encryption in this case.
  2. Hi, Thank you for sharing
  3. I suppose that you use update form. You should use a little bit different syntax, have a look at this post
  4. What is the purpose of using series of autosubmit datapages? I assume that you need to submit values to different table, in this case you need to pass ID to those records. This will let you then join tables in views and give you more flexibility in retrieving data Hope it helps
  5. I would use SQL query in calculated field on details page. E.g.: sum(hours) from table_name where user_id=targer.[@field:userid] Calculated field generates a value on the fly on every page load (therefore it's always up-to-date), but if you need to save it in table you may use solution from this post
  6. I just wanted to share this solution if you wish to add some text like "Select items" to your list string field, you may use this solution Insert HTML block above the field, disable html editor and insert code: <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"> </script> <script> function placeholders() { document.querySelector("input[type=text][name=ComboBoxInsertRecordField_name]") .setAttribute("placeholder", "Select items"); } $(document).ready(placeholders); </script> Replace Field_name with name of your field.
  7. You may try passing parameters from the search to results page header or html block. Pass parameter on exit for a field on search page, then use parameter names in the header of the results page [@field1] OR [@field2] OR [@field3]
  8. As far as I understand, borders appear when you embed a datapage to your webpage. If you don't pass parameters to/from the datapage, you may use iframe deployment method, this will let you keep the same look as you have on preview in Caspio. Another option - edit CSS of your website and edit attributes which overwrite caspio style. One more possible option - ovewrite attributes in the header of the datapage, like: <style> #caspioform tr { border: none !important; } #caspioform td { border: none !important; } </style> You can user similar code for other form elements to override border:none. Use firebug or other F12 tools to inspect the form elements and find their respective style and customize them similar to the below code.
  9. You may try appypie, I tried deploying datapages there, works fine. I deployed datapage to "code page" type of page
  10. As far as I know, this kind of triggers can be done on the server side only. You may reach out to this team, they implement this kind of requests
  11. This kind of validation can be done using Java Script. Have a look at this post
  12. Calculated field can return only one value. Perhaps, you may create a view, join tables and then use that view as a data source for report with grouping. Hope that helps.
  13. You may have a look at this post. The question is very similar, It has a script which you may try using
  14. Do you mean MS Office plugin? It's compatible with office 2013
  15. As far as I know, mass insert is not allowed in caspio, therefore I would submit each record separately
  16. How do you wish to store this information? I suppose it should be different records. If yes, you may specify "same form" in the destination page. This will let you open a clean form again after previous information is entered. If you wish to keep all the information in one records, you may have a look at this solution
  17. Hi, Wix deploys datapages in iframe and it's impossible to pass parameters from/to datapages or use scripts with redirection I would suggest selecting another CMS like weebly, wordpress.org, godaggy, etc.
  18. Hi SongLian, I changed code for the footer, it should work now: <script> $('[name=cbParamVirtual2').change(function() { $('[name=cbParamVirtual3').val($('[name=cbParamVirtual2').val()) }); </script> <script> function replace(){ var res= document.getElementsByName('cbParamVirtual3')[0].value; var newchar = '; ' res = res.split(',').join(newchar); document.getElementsByName('cbParamVirtual3')[0].value=res; } document.getElementById("caspioform").onsubmit=replace; </script>
  19. Try using document.write, e.g.: document.write('<button onclick=document.location.href="https://www.google.com">take me away</button>');
  20. You may have a look at this post. Another possible option is to enable inline insert option on tabular report which will let you insert a record from report Hope that helps
  21. Hi, you may enable grouping in collapsible groups. You can find more info here
  22. Are there any errors in browser's console? You may send me an URL and I will check
  23. You could insert all those fields in table design in order to have all fields in one record.
  24. Hi, InsertRecord is missing before field names in the following lines: document.getElementById("Regular_Hours").onchange=calculate; document.getElementById("OT_Hours").onchange=calculate; You may use onblur event in order to run function onchange, also I would recommend adding one more conditions in order to check that all the values which are being used in calculation are fulfilled with data <SCRIPT LANGUAGE="JavaScript"> function calculate() { var v_hours = parseFloat(document.getElementById("InsertRecordRegular_Hours").value); var v_hoursot = parseFloat(document.getElementById("InsertRecordOT_Hours").value); var v_rates = parseFloat(document.getElementById("InsertRecordRates").value); var v_ratesot = parseFloat(document.getElementById("InsertRecordRate_OT").value); if (isNaN(v_hours) || v_hours.length<1) { v_hours = 0; }else if (isNaN(v_hoursot) || v_hoursot.length<1) { v_hoursot = 0; }else if (isNaN(v_rates) || v_rates.length<1) { v_rates = 0; }else if (isNaN(v_ratesot ) || v_ratesot.length<1) { v_ratesot = 0; } var v_amount = ((v_hours * v_rates)+(v_hoursot * v_ratesot)); if ( isNaN(v_amount)){ v_amount = ""; } document.getElementById("InsertRecordAmount").value = v_amount; } document.getElementById("InsertRecordRegular_Hours").onblur=calculate; document.getElementById("InsertRecordOT_Hours").onblur=calculate; </SCRIPT> Cheers!
  • Create New...