Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Vitalikssssss

  1. Hi Imooring, You can try to use the following code on your Submission Form in order to insert "+1 day" value into your Expire Date field upon user select the date in End Date field: <script> function DateAdd() { var a = new Date(document.getElementById('InsertRecordYOUR_FIELD_End_Date').value); a.setDate(a.getDate() + 1); var dd = a.getDate(); var mm = a.getMonth()+1; var yy= a.getFullYear(); var b = mm + '/' + dd + '/'+yy; // you should change an order if you use non-US localization in your Submission Form document.getElementById('InsertRecordYOUR_FIELD_Expiration_Date').value=b; } document.getElementById('InsertRecord_YOUR_FIELD_End_Date').onchange= DateAdd; </script> You should place this code into the Footer of your Submission Form. Please make sure that you have disabled HTML editor. Hope this helps.
  2. Hi roattw, You should make sure that you have used correct names of table/column (case sensitive). You may try to use the following expression: select count(user_id) from table_name where CME_Category='Value' Hope this helps.
  3. Hi Accountability, Have you put this part in a Header of the Datapage? <div id="datefix"> Can you send me a screenshot from your browser console? Perhaps we`ll be able to trace an error from there. Regards, vitalikssssss
  4. Hi MyNameIsSean, It looks like the issue has been fixed. I have been able to create a Trigger which inserts the Timestamp value from parent table into Date&Time field. Regards, vitalikssssss
  5. Hi 888Washington, You can lookup for reference record in another table by creating a Join with #inserted. It is difficult to offer you a precise solution without table structure or a screenshot of your existing Trigger. By the way, I have recently signed up for the Webinar: Introduction to Triggered Actions. Perhaps you will be able to find an answer or some insights there. You can sign-up via following links: Wed, Oct 25, 2017 3:00 PM - 4:00 PM EEST Wed, Oct 25, 2017 9:00 PM - 10:00 PM EEST Thu, Oct 26, 2017 3:00 AM - 4:00 AM EEST Hope this helps.
  6. Hi Melwyn, I have a doubt that desired functionality can be achieved with Triggered Actions feature. I have a Trigger in my App which concatenates first and last reference number into a single Text(255) field. You may try to achieve desired functionality on a Datapage level by using the Javascript solution from this Forum topic. It will allow you to store selected values in one field which will be separated by a comma. Hope this helps.
  7. Hi Accountability, Try the following code: <div id="datefix"> <script> function DateCheck() { var dateout = document.getElementById('InsertRecordDefined_Time_Out').value; var datein = document.getElementById('InsertRecordDefined_Time_In').value; if (dateout <= datein) alert("Please enter a date and time OUT after date and time IN "); document.getElementById("InsertRecordDefined_Time_Out").value = null; return false; } document.getElementById('InsertRecordDefined_Time_Out').onchange = DateCheck; </script> </div> I have corrected some minor syntax errors. Hope this helps.
  8. Hi Accountability, I have noticed a syntax error in your code where you trying to reference Cascading Elements. Here is an example of the correct syntax for referencing Cascading Elements: Hope this helps.
  9. Hi MyNameIsSean, That is very odd behavior which I believe will be resolved in an upcoming Caspio Bridge release. In the interim, you can try to build the Triggered action as per below as a temporary workaround. Hope this helps.
  10. Hi jrodriguez88, I would suggest combining your functions within a single function. Here is a code: <script> function check() { var x = document.getElementById("EditRecordPHONE_NUMBER").value; var y = document.getElementById("EditRecordMOBILE_NUMBER").value; document.getElementById("EditRecordPHONE_NUMBER").value=x.replace(/[^0-9 ]/g, ""); document.getElementById("EditRecordMOBILE_NUMBER").value=z.replace(/[^0-9 ]/g, ""); } document.getElementById("caspioform").onsubmit = check; </script> Hope this helps.
  11. Hello Accountability, I would suggest using following code if you prefer to restrict form submission if the condition "dateout <= datein" is met: <div id="datefix"> <script> function DateCheck() { var dateout = document.getElementById('InsertRecordDefined_Time_Out').value; var datein = document.getElementById('InsertRecordDefined_Time_In').value; if (dateout <= datein) alert("Please enter a date and time OUT after date and time IN "); document.getElementById("InsertRecordDefined_Time_Out").value = null; return false; } document.getElementById('InsertRecordDefined_Time_Out').onChange = DateCheck; </script> </div> Hope this helps.
  12. Hi jrodriguez88, You can use the following snippet of code to remove special characters from a user input: <script> function check() { var x = document.getElementById("EditRecordYOUR_FIELD").value; document.getElementById("EditRecordYOUR_FIELD ").value=x.replace(/[^a-zA-Z ]/g, ""); } document.getElementById("caspioform").onsubmit = check; </script> Please place this code into the Footer of your Details Datapage.
  13. Hello wdandrews, You can use conditional rules in order to hide search fields based on user authentication information. You may also use record-level security feature to restrict an access to the search result records based on user role. Hope this helps.
  14. Hello roattw, You should disable Caspio HTML editor in order to avoid this issue. Hope this helps.
  15. Hi everyone, I would like to share an alternative solution for the described issue. My solution will validate a required field via custom JS i.o. Caspio standard "required" field check. Please put following snippet of code into the Footer of your Submission Form. Make sure that you have disabled the HTML editor before inserted the JS code. <SCRIPT LANGUAGE="JavaScript"> function check_required() { var field1 = document.getElementById("InsertRecord_YOUR_REQUIRED_FIELD#1").value; var field2 = document.getElementById("InsertRecord_YOUR_REQUIRED_FIELD#2").value; var emptyFields = false; if (field1.length < 1) emptyFields = true; if (field2.length < 1) emptyFields = true; if (emptyFields) { alert("Required fields are empty."); return false; } } document.getElementById("caspioform").onsubmit=check_required; </SCRIPT> Hope this helps.
  16. Hi Sudesh, It looks to me that you have used Data/Time data type. You should use Text(255) datatype for the field in question. Hope this helps.
  17. Hi ChrisGoode, I would suggest using Criteria to resolve your case. Set the Comparison Type of the new criteria #1 to Today and criteria #2 to Next X days (specify the value 1). The field data type must be Date/Time. You may find more in this article: http://howto.caspio.com/faq/reports-datapages/how-to-add-today-to-after-now-or-next-x-days-criteria/ Regards, vitalikssssss
  18. Hello Esraaa, This localization setup is normally provided by the browser. You can try to customize the look with JS/CSS. This topic should be useful: labeling-file-upload-button . Hope this helps.
  19. Hello ChrisGoode, Have you tried to use Formula field with DataAdd() function? You may find more in this following articles: http://howto.caspio.com/tables-and-views/data-types/formula-fields/ http://howto.caspio.com/function-reference/ Hope this helps.
  20. Hello dangkhoa, I would suggest using Text(255) data type for the field in question. You can use Formula field to separate text from the number in order to perform the calculation. Please find some useful links below: http://howto.caspio.com/tables-and-views/data-types/formula-fields/ https://howto.caspio.com/function-reference/ http://howto.caspio.com/faq/reports-datapages/how-to-do-conditional-or-if-then-else-in-calculated-fields/ Hope this helps.
  21. Hello NeoInJS, Perhaps you can try to replicate the desired layout with Pivot table. http://howto.caspio.com/datapages/reports/pivot-table/ Hope this helps.
  22. Hello Nick, You can use Caspio special data type called List-String which support multiselection with predefined choices. Here is the link to Howto article: Data-types/list You may use REST/SOAP API Caspio functionality to update/import the data in Caspio from an external source. Here is the link: Web-services-api You may also consider using Zapier to simplify the integration development. Here is the link: Integration/zapier Hope this helps.
  23. Hello dongtac, Have you considered to use Timestamp data type within your table? http://howto.caspio.com/tech-tips-and-articles/common-customizations/stamp-the-time-url-or-ip-address-to-new-and-updated-records/ You can define date formatting in field advanced section in Datapage wizard: http://howto.caspio.com/localizations/formatting-options/ Hope this helps.
  24. Hi Newgoblin49, You can create a relational database in Caspio. You may find more details here: http://howto.caspio.com/tables-and-views/relationships/ Hope this helps.
  25. Hello mdav20, I would suggest creating the separate function, so you could call this function with a different event "onload". Hope this helps.
  • Create New...