Jump to content

Search the Community

Showing results for tags 'submission form'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Caspio Bridge
    • Caspio Apps for Ukraine
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start




Website URL






Found 24 results

  1. Has anyone experienced Caspio inserting duplicate records using a Submission form (with ~25 fields)? The duplicate records have all of the same exact values for every field except the timestamp on Insert is always 2-3 seconds apart. This has happened 3 times over the last week to 3 different users. I haven't been able to find anything similar between the users and none of them are reporting they are clicking Submit multiple times.
  2. I am building a one-page Caspio submission (deployed by embed) form for clients to fill out. Viewable here: Test Form • WIM Tracking I want the data to save locally (without the user having to submit the form) in case they are kicked off their browser or leave and return to it later. I have read that I can use localStorage.setItem and localStorage.getItem. I have found a couple other posts, but they don't quite translate to what I am doing. I have included the posts I have found below and have based the following code on those posts. Any suggestions? <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { console.log("DataPageReady"); console.log(document.getElementById("CaspioForm")) fields = document.getElementById("First_Name") for (field of fields) { //Load stored data into that field and add a listener to store the data on change handleStorage(field) } //Instead of having to list }); //Handle loading/storing data for a field function handleStorage(field) { // Get value out ofstorage and populate the field with it console.log("Loading value " + localStorage.getItem(field.id) + " for field " + field.id); if (field.type == "checkbox") { //The storage is saving the boolean as a string, so we need to //convert it back to a boolean for checkboxes field.checked = (localStorage.getItem(field.id) == 'true'); } else { field.value = localStorage.getItem(field.id); } //Add a listener to store the data every time a field changes //This will fire every time they type a letter. field.addEventListener('input', (event) => { console.log(event); //Checkboxes store their value in "checked" instead of "value", //so you have to handle it separately. value = (event.target.type == "checkbox") ? event.target.checked : event.target.value; console.log("Storing " + value + " for " + event.target.id); //Store the the value for the id (The id should be unique, // so you might as well use it as your storage key as well) localStorage.setItem(event.target.id, value); }); } </script>
  3. Hi, I have a date field in my submission form and I want to prevent the user from selecting a date that is not within a specified range of dates. Like for example, I only want the user to input dates that are within 12/01/2022 to 12/12/2022. Any dates that are not within that period will not be allowed.
  4. I have an submission form that allows you to scan barcodes into the system. It goes through several stations and we need it to reject an entry if one or more of the stations do not have records of that serial number making a stop there. Here's how it currently looks: Entry fields: Garment barcode Employee ID barcode Station barcode Virtual fields: When a Garment barcode is scanned, a virtual field displays where it was last scanned (which station) When an Employee ID barcode is scanned, a virtual field displays who the last Employee was that interacted with that item When a Station barcode is scanned, a virtual field displays which station last touched that garment What we would like, is if SN: 123456 reaches Station 2 without first going through Station 1, Station 3 without first Station 2, etc., it's rejected upon attempt to submit the form.
  5. Hello, I have a Submission form and want to change the background of the cell when the user changes or enters the values. For example, here is the initial view: Once the data is entered, the background is changed: How this is possible?
  6. I have built a Caspio submission form that contains 8 fields that collect data using a multi-select string field. Upon submission of the data, I need to send the data to FormStack. I am using Zapier to do so. The problem I am running into is that Zapier does not read the multi-select data field. Does anyone know of a work around of how I can collect the data via a multi-select field in a submission form and send the data to another database?
  7. Hello, I have a submission form that requests users to select a value in a drop-down. I would like to use the selected value to look up an email address, based on this value, in a different table, and populate a virtual field with that email address. I would then like to use the value in that virtual field to send a submission notification. How can I achieve this? I cannot see how to load a parameter from another table based on the value of a field. Any help would be much appreciated. Thanks, Julien
  8. Hi, I wonder if it possible to limit number of submission per day. I'd like to allow user to submit data only once per day
  9. Hi, I want to create a ticketing system like caspio support. I have two table T_Ticket: --> ID_TICKET --> Ticket Subject --> Ticket Commentary and T_Detail_Ticket --> ID_DETAIL_TICKET --> ID_TICKET (Foreign key) --> Commentary_DETAIL_TICKET What I need is, when a ticket is created, create with an SQL insert the first detail_ticket commentary with the commentary_ticket Is that possible?
  10. Hi, I need help with calculating total sum based on values, entered in fields. I have 3 fields on the submission form, where users enter 3 values. I would like to calculate total in the forth field. Also, I want to show the value to the user. E.g when user enters value "5" in the first field, he will see "5" in the field Total then user enters "10" in the second field, he will see "15" in the field Total and finally user enters "7" in the third field, he will see "22" in the field Total And I wand to store value 22 in the table. Thanks!
  11. I am trying to create an increment/decrement button so that the user doesn't have to type in the value manually but rather use the arrow buttons do increase/decrease the input on the fly. How would I do it on Caspio Submission Form?
  12. Hello, I have a submission form with 3 fields - Price, Qty and Total Amount. May you please help me in developing a script to get the Total Amount when Price or Qty is changed. (without submitting the dp) The formula for Total Amount. is Price * Qty. Thanks in advance.
  13. Is there a way to give repeat section option in submission form? So that the user can fill a particular section in the form multiple times with different input. I found this option in other form building apps but not in Caspio. Please refer to the screenshot for better understanding. Thank you.
  14. I am trying to allow for this JQuery tag affect to occur when the user types in to the text area in the virtual field of my submission form but have not been successful. Disclosure: Since I am new to Javascript, I was wondering if I am referencing the JQuery and Tag-It components properly? I attempted switching the id/class element with "cbParamVirtual1" and "caspioform" but no luck. I would appreciate anyone's feedback. (This is in the footer of the datapage.) <!-- jQuery (necessary for Bootstrap's JavaScript plugins) --><script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js" type="text/javascript" charset="utf-8"></script><script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.9.2/jquery-ui.min.js" type="text/javascript" charset="utf-8"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/tag-it/2.0/js/tag-it.js" type="text/javascript" charset="utf-8"></script> <script language="JavaScript"> $(function(){ //------------------------------- // Single field //------------------------------- $('cbParamVirtual1').tagit({ // This will make Tag-it submit a single form value, as a comma-delimited field. singleField: true, singleFieldDelimiter: ',', singleFieldNode: $('#mySingleField') }); }); </script>
  15. I also posted this in User JavaScript and CSS Discussions because I'm not sure whether custom script was required to achieve this result. I have a submission form DataPage with a multi-select listbox field. I would like the values the user selects in that field to be passed into the notification email. Currently, only numbers representing the values display. This is the parameter in the email: Profession : [@field:Profession] This is what it displays in the notification email: Profession : 4,5,6,53 I would like it to display this: Profession : Accountant, Actor, Agent/Manager, Artist Is this possible? Thank you.
  16. I have a submission form DataPage with a multi-select listbox field. I would like the values the user selects in that field to be passed into the notification email. Currently, only numbers representing the values display. This is the parameter in the email: Profession : [@field:Profession] This is what it displays in the notification email: Profession : 4,5,6,53 I would like it to display this: Profession : Accountant, Actor, Agent/Manager, Artist Is this possible? Thank you.
  17. I am trying to create an increment/decrement button so that the user doesn't have to type in the value manually but rather use the arrow buttons do increase/decrease the input on the fly. How would I do it on Caspio Submission Form?
  18. The thing I'm trying to achieve is that users of my app can only plan a date after today, with "rules" I am able to display a message when a user selects a date before today with the date picker. I achieve this by hiding a section when the given date is ok (Input_date > Timestamp). But while it is not possible to prevent users from submitting the form when a condition is not met, I'm trying to find a solution in javascript. The problem that occurs is that the format differs, the inputfield of the user is DD-MM-YYYY and the timestamp i compare it with is MM/DD/YYYY. Strangely this is not a problem with "rules". The code I use: <script> function myFunction(){ var StartDate = document.getElementById("InsertRecordStartDate").value; var Today = document.getElementById("cbParamVirtual1").value; // This virtual field receives the timestamp onload if (StartDate < Today){ alert('Not all conditions are met"); event.preventDefault(); } document.getElementById("caspioform").onsubmit=myFunction; </script> How can I fix this issue? Thanks in advance.
  19. How can I redirect my auto-submit form if it encounters the message Values in one or more fields are invalid.
  20. This could be a totally dumb question, but I'll risk it! My interest is to search my table and show a report. I don't wish to submit data to the table. I've been using submission forms for my search fields. The reason for this is because I wanted to keep my results page on the same web page as the search fields. Submission forms allow me to stay on 'same page', while report datapages force you to show results on a new datapage. Ideally I would have preferred to use a report datapage for the search fields, mainly because there are no silly problems in trying to get multi-select cascade listboxes to update in real time from a multi-select parent listbox (a problem faced by many on this forum and not yet properly solved). So is it possible to use a report datapage with a little bit of JS code, that effectively prevents its results page from being generated (as possible with a submission form)? Obviously I'd then pass my parameters to a separate results datapage, just as I do now. Thanks
  21. Our submission form is being used to add new records to our database. On the submission form there are several required fields. When previewing the form in Caspio, we receive a 'You did not enter valid information in one or more of the fields.' if we didn't. We have embedded the form in our website, and if we leave any required fields blank, the submission form goes to a homepage rather than alert to missing information. Currently in Caspio Preview - Enter good info on submission form, page accepts (I assume, nothing loads, page just clears out) Enter incomplete info on submission form, receive warning as above; when corrected, page accepts (I assume, but nothing loads and page clears out) Once upon a time the good information would trigger a new page in Caspio 'good job' Currently on website- enter good info into submission form, go to page that says 'congrats' enter incomplete information, go to website homepage with no alerts/indicators of error or submission success Once upon a time the website would display the congrats and the error message - however there has been a big website changeover since those days. We want an incomplete entry to the submission form on the website to display an 'error incomplete' message, then go to the 'congrats' page when submission is complete/correct. This isn't happening. . Any suggestions for a fix? We do not have virtual fields, we do not have dropdowns - only radio buttons, text fields, and a couple 'choose from listed'. Thanks in advance! April
  22. Is it possible to add a button that would open a new window allowing me to add a new vendor? The submission form has drop downs, but, when the vendor is not present, you must close and open the add vendor data page, then start all over adding the transaction
  23. Hello All Does anyone know how to change the submission form with a time limit (http://howto.caspio.com/tech-tips-and-articles/advanced-customizations/how-to-add-a-time-limit-to-submission-forms/) so as it diverts to another webpage (unsubmitted) if someone doesn't complete it in time? Currently, it submits itself automatically. Many thanks Duncan
  24. I would like to set up a database where my authenticated users can upload their records (can be anywhere from 2-10k) in one go (who would fill in my form 10 thousand times a quarter?). The import feature worked great for me here, and if they had the ability to do something similar on their end - including the mapping ability the import wizard has it would be a life saver. Is this possible? I can't seem to find that option. Thank you kindly for your support! This is my first day and I do enjoy the ease of use here.
  • Create New...