Jump to content


Caspio Rockstar
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Mathilda

  1. 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
  2. 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
  3. 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
  4. Try calling a function onload: <SCRIPT LANGUAGE="JavaScript"> window.onload=function goBack() { window.history.go(-1); } </script> Hope that helps
  5. 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").value=v_TimeStamp; } } </SCRIPT> Both fields should be editable text fields on a datapage, if you need to hide a field, you may use display:none attribute, like explained here
  6. 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> Insert your fieldname which you would like to trigger instead of Field1 Also I assume that you have email field on your datapage, so you need to insert your field name instead on Email in my code. This way an email will be sent only if you changed value in specified field Hope that helps
  7. 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!
  8. 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;
  9. 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>
  10. 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!
  11. Hi, grid edit is a specific mode. You may contact them, perhaps they will be able to implement that
  12. 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;" />
  13. 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.
  14. I posted script to the similar inquiry, you may find it here. Also you need to pass field parameters in query sting
  15. 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!
  16. 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.
  17. You need to double-up the single quote character: CASE WHEN [@field:Gender] = 'MEN''S' THEN 1 END
  18. 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]
  19. 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
  20. 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
  21. 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'); VirtualValue.value = ListValue; var str = document.getElementById("cbParamVirtual1").value; var res = str.replace(/,/gi, ";"); document.getElementById("cbParamVirtual1").value = res; } document.getElementById("caspioform").onsubmit=ListToVirtual; </script>
  22. Yes, you may reference external js file. If you're looking for a way of getting time from the system parameter - you may use this parameter: [@cbTimestamp@] Also there is a solution how to get user's date and time. Hope that helps
  • Create New...