Jump to content

Mathilda

Caspio Rockstar
 View Profile  See their activity

  • Content Count

    464

  • Joined

  • Last visited

  • Days Won

    49

 Content Type 

Everything posted by Mathilda

  1. Mathilda
    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. Mathilda
    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. Mathilda
    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. Mathilda
    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. Mathilda
    You're welcome!
  6. Mathilda
    Try calling a function onload: <SCRIPT LANGUAGE="JavaScript"> window.onload=function goBack() { window.history.go(-1); } </script> Hope that helps
  7. Mathilda
    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
  8. Mathilda
    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
  9. Mathilda
    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!
  10. Mathilda
    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;
  11. Mathilda
    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>
  12. Mathilda
    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!
  13. Mathilda
    Hi, grid edit is a specific mode. You may contact them, perhaps they will be able to implement that
  14. Mathilda
    You're welcome
  15. Mathilda
    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;" />
  16. Mathilda
    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.
  17. Mathilda

    New User

    Mathilda replied to swthrt13's question in General Questions

    I posted script to the similar inquiry, you may find it here. Also you need to pass field parameters in query sting
  18. Mathilda
    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!
  19. Mathilda
    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.
  20. Mathilda
    You need to double-up the single quote character: CASE WHEN [@field:Gender] = 'MEN''S' THEN 1 END
  21. Mathilda
    Hi, I suppose that this tutorial video should be helpful.
  22. Mathilda
    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]
  23. Mathilda
    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
  24. Mathilda
    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
  25. Mathilda
    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...