MyNameIsSean

I have a Caspio submission form that contains fields marked as unique values, so it will give users an error if there is a duplication. The issue is that users put in the information, and hit submit, but then the page returns an error, but on the tables the information is submitted. I am thinking that for some reason, the information is updated in the tables, but the datapage submits the data again, but returns the error. I would like to find out what causes this issue, and what are the possible solutions. Thanks in advance.

Hi Vitalikssssss, Thanks for the update! You have been most helpful Cheers

Hi Vitalikssssss Thanks for your workaround solution to this issue. I hope this bug will be fixed soon. Cheers

I am loving the new triggered actions feature, but I have the following issue: I have a parent table containing 2 timestamp fields, one for the creation and one for the update. I am trying to create a triggered action that inserts a new record in the child table, for each update in the parent table. In the child table, the field that is created to keep the creation and update dates are set as date/time. I followed the video tutorial, and encountered error "2088: Mismatched data types." on the above mentioned fields. I tried changing the field type in the child table to "Text" but it didn't work. Changing the triggered action data field to timestamp only timestamped the date and time the action was triggered. Here is a screenshot of the trigger, if it helps: Does anyone know a fix for this?

Hi Mathilda, Thank you for the suggestion but unfortunately that is not what I was looking for. I have found a possible solution: 1) In the Header, I have the following: <table><td><div> //this is the start of the left section 2) I have added a html block in the middle with the following: </div></td></table><td><div><table> //this is the start of the right section 3) And in the footer: </table></div></td> The idea is to house the fields in 2 table columns, then each in a DIV, to create 2 columns independent on each other's formatting. It worked, however there is another problem: The conditional collapsible sections do not work on the right section, and I am also unable to call the elements in it by their IDs: document.getElementById("EditRecordFIELDNAME") does not work, and creating DIVs to house multiple fields and hiding the DIVs do not work either. I hope you understand what I am trying to do here. Thanks in advance.

I have come up with the following solution: <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var identifier1 = document.getElementById("InsertRecordProduct_ID").value;var identifier2 = document.getElementById("InsertRecordCustomer _ID").value; var concat_identifier = identifier1 + "P" + identifier2 + "C"; var text = ""; var possible = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789"; for( var i=0; i < 5; i++ ) text += possible.charAt(Math.floor(Math.random() * possible.length)); if (identifier1 !== "16") { document.getElementById("EditRecordChecker ").value = concat_identifier ; } else { document.getElementById("EditRecordChecker ").value = text; } } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT>

I have came up with the following solution: <a href="skype:[@field:Contact_Mobile]?call" id="mobile_icon[@field:Contact_ID]">Click here to call</a> <script> var count_mobile = ("[@field:Contact_Mobile]").length; if (count_mobile < 5) { document.getElementById("mobile_icon[@field:Open_Interest_Open_Interest_ID]").style.display = "none"; } </script>

Hi, I have a datapage that has another datapage embedded, within a single column layout. However I want to instead, embed it on the side, such that I can see both datapages side by side. Is this possible to do without adding another datapage? Also, i have multiple sections within the parent datapage so I cannot use a 2 column section to resolve this, unless I can add a section into another section (as a subsection). Thanks in advance.

Hi, I have a relational database set up in a way that I have a Customers table, Products table, and I create entries in the Proposal table, that links the 2 tables together. I would not like to create a proposal that connects the same customer to the same product twice, however there is one product that is open (id = 16), and is the exception (i can have multiple proposals created for the same customer, to that open product). I was thinking that I can create a checking field in the Proposal table that is a unique text field, and it will take a concatenate value of the customer Id and the product id to create a unique identifier. However it will not work for the open product, so I was thinking to insert a random number into the checking field such that it will bypass the unique value criteria present in that field. I currently have this, which the concatenate function works perfectly in generating and inserting the checking value, but the random value inserts "undefined" into the field. <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var identifier1 = document.getElementById("InsertRecordProduct_ID").value; var identifier2 = document.getElementById("InsertRecordCustomer_ID").value; var concat_identifier = identifier1 + "P" + identifier2 + "C"; if (identifier1 !== "16") { document.getElementById("InsertRecordChecker").value = concat_identifier; } else { document.getElementById("InsertRecordChecker").value = Math.random().ToString().value; } } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT> Is there a problem with my code, or is there a better solution to this problem? Thanks in advance.

Hi, I have a tabular results field that displays contact information, and i have a html field that contains a link that activates a skype call to the number in the field, but i would only like to display that link only if the number is not empty. currently i have something like this, but it is not working: <SCRIPT LANGUAGE="JavaScript"> if (document.getElementById("EditRecordContact_Mobile").value = "") { $("#hide_link").hide(); } </SCRIPT> <a href="skype:[@field:Contact_Mobile]?call" id="hide_link">Click here to call</a> Thanks in advance

Hi Vitalikssssss, That is unfortunate. Imagine the possibilities! And, I was experiencing issues with Zapier, but I will continue to look into it. Thanks for your help so far!

Hi Vitalikssssss, Thank you for your help, but that is not what I meant. I would not like to send the verification via email, but rather verify it through the previously mentioned website such that it gets verified automatically as an active email address. The reason is that the email addresses will not be user-submitted, rather they will be added by staff members, so we do not want to send unsolicited verification emails upon entry, but would still like to verify that those email addresses are valid and active, for our marketing purposes. P.S. sorry i did not mean to downvote your reply, I was just trying to figure out how to post a reply to your reply lol

Hello, I have a table with the columns email_address and email_verification. Ideally I would like the email to get verified through a site like quickemailverification.com when the email is entered or submitted, and if it passes the verification, it will get updated as a "verified" value under email_verification. I am wondering if the datapage allows me to carry out a getJSON request (or getAJAX request) to the API using the email_address input, then pass the result on to the email_verification field automatically. If it helps, the API is as such: "http://api.quickemailverification.com/v1/verify?email=richard@quickemailverification.com&apikey=###" and the response is as such: { "result":"invalid", "reason":"rejected_email", "disposable":"false", "accept_all":"false", "role":"false", "email":"richard@quickemailverification.com", "user":"richard", "domain":"quickemailverification.com", "safe_to_send":"false", "success":"true", "message":null } Thanks in advance. P.S. I am not very well versed in both Caspio and Javascript; I am still learning so I'd appreciate if you could please be as explicit as possible, thank you.