Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Mathilda

  1. As far as I understand you need to create a queue of people who wants to see the house. I suppose that you have a submission form where person can submit an inquiry. That form should receive house ID, then add a virtual field, make it to be cascading drop-down and sort values in descending order. This will let you see how many people are already in the line, then increment a value (+ 1) using java script and write into the table The script will be like that: <SCRIPT LANGUAGE="JavaScript"> function calculate() { var v_increment = parseFloat(document.getElementsByName("cbParamV
  2. As far I understand Product ID in the orders table if a foreign key of the Product table, therefore you may create a relationship and display Product URL instead of ID. This article should be helpful. Then you need to insert this lookup value into the email body. It works if you use Caspio emails, I'm not sure regarding Zapier emails
  3. Hi, As far as I know this kind of triggers are not available yet, it requires coding on the server level. This team should be able to implement that. You may trigger inserting a row in the table only via Zapier and insert record into another table, if it works for you
  4. I would recommend using a function with "return false", it won't let submit a form is date is wrong. I created a script for the similar request, you may check it here Hope that helps
  5. Try calling a function onload: <SCRIPT LANGUAGE="JavaScript"> window.onload=function goBack() { window.history.go(-1); } </script> Hope that helps
  6. Hi Nikki, I edited your script a little bit, try inserting script in the footer: <SCRIPT LANGUAGE="JavaScript"> window.onload=function myfunc(){ Stamp = new Date(); var v_TimeStamp; Hours = Stamp.getHours() Mins = Stamp.getMinutes(); /* Construct the value of the v_TimeStamp variable in the format m/d/yyyy hh:mm */ v_TimeStamp=('' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate()+ "/"+Stamp.getFullYear() + ' ' + Hours + ":" + Mins); if ('[@field:Actual_result]'.length>1 && '[@field:Test_Completed]' === "") { document.getElementById("EditRecordTest_Completed
  7. Hi Julien, Yes, it's possible. You may trigger changing a field and when field is changed, insert email address into virtual field. Then using virtual field in Email field for your acknowledgement email. Since I don't know type of your datapage, I created code for details datapage. Insert script in the footer of your datapage: <SCRIPT LANGUAGE="JavaScript"> function insert() { var x= document.getElementById("EditRecordEmail").value; document.getElementById("cbParamVirtual1").value = x; } document.getElementById("EditRecordField1").onchange=insert; </SCRIPT> I
  8. Hi Aurora, I added the following code to responsive code in the header of my details datapage: #datapage-form img { width: 100%; display:block; height: auto; } Hope that helps!
  9. Just write two additional lines which will call function for each field: document.getElementById('InsertRecordFIELD1').onkeypress =isNumberKey; document.getElementById('InsertRecordFIELD2').onkeypress =isNumberKey; document.getElementById('InsertRecordFIELD3').onkeypress =isNumberKey;
  10. You need to create a separate table for orders and pass parameters in query string to this table from report datapage. Create a submission form and receive needed parameters onload: customerID and car_ID, insert autosubmit script, save the datapage and get the direct deploy URL of the datapage. Autosubmit script will let you submit data automatically. Then place a link to the submission form in html block on report datapage. E.g: <a href="URL_of_the_datapage&Customer_ID=[authfield:Customer_ID]&Car_ID=[@field:Car_ID]">Link name</a>
  11. You may insert the following java script in the html block: <script> var x=[@cbRecordIndex]; var y=[@field:Your_field]; document.write(x*y); </script> Don't forget to change name of the field in the y variable Cheers!
  12. Hi, grid edit is a specific mode. You may contact them, perhaps they will be able to implement that
  13. Hi, You may take the field using parameter picker and add a back slash / to the parameter: <img alt="" src="[@authfield:Photo/]" style="width: 200px; height: 200px; margin: 1px;" />
  14. You need to insert your field names after EditRecord, for example if your field name is Status, the syntax will be: ("EditRecordStatus"). More information can be found here. Please note, Java Script is case sensitive. Hope that helps.
  15. I posted script to the similar inquiry, you may find it here. Also you need to pass field parameters in query sting
  16. Hi, I would recommend checking length of the value. You may insert the following script in the footer of details datapage: <script> window.onload= function() { if (document.getElementById("EditRecordYour_field").value.length>1) { document.getElementById("EditRecordcheck_box_field_name").checked=true; } } </script> Don't forger to change fields names in my script Cheers!
  17. I also have another solution. I use the following code in the header of results page: <style>#my table {display:none;} </style> <div id="my"> And in the footer: </div> HTML editor should be disabled in the header and footer.
  18. You need to double-up the single quote character: CASE WHEN [@field:Gender] = 'MEN''S' THEN 1 END
  19. Hello Bre, You need to use syntax [@InsertRecordProjectID] only when you receive a parameter onload in a field on the second datapage. The query string will be like this: http://www.TTTest.com/brokerlookuptest.html?ProjectID=[@ProjectID]
  20. Hi Craigs, I suppose that you may add a virtual field and gen name of the job using cascading elements. If you don't want to display that field using display: none attribute, like in this article Hope that helps
  21. Hi Geoff, It looks like the reason is mixed content. If you load unsafe code in your browser, the header will appear. The source of the iframe has http protocol, the datapage is on the https. I found a few posts here and here which may be helpful
  22. Hi everyone, I just want to share this solution. If you need to generate notification emails to email addresses selected in a list datatype, you need to: - add a virtual field; - select a virtual field in the field "to" when you set-up notification email; - insert the following script in the footer and replace list_of_emails with name of your list datatype field: <script> function ListToVirtual() { var ListValue = document.getElementsByName('ComboBoxInsertRecordlist_of_emails')[0].value; var VirtualValue = document.getElementById('cbParamVirtual1'); Virtua
  • Create New...