-
Content Count
464 -
Joined
-
Last visited
-
Days Won
49
Everything posted by Mathilda
-
Automated sequence number is child form
Mathilda replied to vanderLeest's question in Calculations and aggregations
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- 3 replies
-
- sequence number
- child form
-
(and 1 more)
Tagged with:
-
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
- 1 reply
-
- zapier
- mutiple tables
-
(and 2 more)
Tagged with:
-
Insert Records from Views to a Table
Mathilda replied to Esraaa's question in Tables, Views and Relationships
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 -
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
-
How to timestamp a field based on conditions in other fields
Mathilda replied to NikkiC's question in General Questions
You're welcome! -
Submit form go back in history on submission
Mathilda replied to DesiLogi's question in General Questions
Try calling a function onload: <SCRIPT LANGUAGE="JavaScript"> window.onload=function goBack() { window.history.go(-1); } </script> Hope that helps -
How to timestamp a field based on conditions in other fields
Mathilda replied to NikkiC's question in General Questions
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 -
Automated emails when specific data field is updated
Mathilda replied to logistics's question in General Questions
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 -
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!
-
Apply script functions to multiple fields?
Mathilda replied to roattw's topic in User JavaScript and CSS Discussions
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; -
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>
-
Reference to record index in calculated field
Mathilda replied to Mylene's topic in User JavaScript and CSS Discussions
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! -
Hi, grid edit is a specific mode. You may contact them, perhaps they will be able to implement that
-
Image from an autentication field shown on a HTML datapage
Mathilda replied to LuluSW's question in General Questions
You're welcome -
Image from an autentication field shown on a HTML datapage
Mathilda replied to LuluSW's question in General Questions
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;" /> -
Check Yes/No based on other fields in report
Mathilda replied to mdav20's topic in User JavaScript and CSS Discussions
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. -
I posted script to the similar inquiry, you may find it here. Also you need to pass field parameters in query sting
-
Check Yes/No based on other fields in report
Mathilda replied to mdav20's topic in User JavaScript and CSS Discussions
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! -
Hide report on chart and report datapage
Mathilda replied to Mylene's topic in User JavaScript and CSS Discussions
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. -
You need to double-up the single quote character: CASE WHEN [@field:Gender] = 'MEN''S' THEN 1 END
-
How to use/configure Google Authentication?
Mathilda replied to piepercfo's question in Security, Authentications, Roles, SAML
Hi, I suppose that this tutorial video should be helpful.- 7 replies
-
- authentication
- (and 4 more)
-
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
-
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
-
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