Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by Mathilda

  1. Hi, InsertRecord is missing before field names in the following lines: document.getElementById("Regular_Hours").onchange=calculate; document.getElementById("OT_Hours").onchange=calculate; You may use onblur event in order to run function onchange, also I would recommend adding one more conditions in order to check that all the values which are being used in calculation are fulfilled with data <SCRIPT LANGUAGE="JavaScript"> function calculate() { var v_hours = parseFloat(document.getElementById("InsertRecordRegular_Hours").value); var v_hoursot =
  2. You may ask them, as fa as I know, they implement small projects as well
  3. What type of the datapage you use? You may have a look at this post in case of using results page
  4. You may check your formula fields in table, I suppose that you submit a value in a field which causes error in formula
  5. Try using .net deployment method. You may also add your subdomain to the list of trusted sites.
  6. Hey, I would recommend creating a report datapage using table with students (where each record is unique). Then insert calculated field on results page and run SQL query like that: select Top(1) CONVERT(VARCHAR(32), Datefield, 1) from table_name where studentID = target.[@field:studentID] Order by Datefield Desc
  7. Hi Russ, I can check your datapage if you don't have sensitive info there. Please paste my script without any changes into the footer and send me the URL of the datapage.
  8. Hi Russ, welcome to forum! Try inserting the following code in the footer of your search form: <SCRIPT LANGUAGE="JavaScript"> function check() { var first= document.getElementById("Value1_1").value; var second = document.getElementById("Value2_1").value; if (( first.length === 0) & ( second.length === 0)) { window.alert("Please enter a value in a field"); return false; } } document.getElementById("searchID").onclick=check; </SCRIPT>
  9. Have you tried creating a view? You can join two tables and allow editing data from the 2nd table. Hope that helps
  10. Formula field cannot be edited because value is calculated using other fields. However you may use the following workaround. Add a separate field where customer will be able to enter preferable date and update your formula with additional condition, like CASE WHEN Len([@field:customer_date])>0 THEN [@field:customer_date] ELSE write your formula END Insert your current formula instead of "write your formula" Cheers
  11. you're welcome don't forget to insert your field names instead of mine. I modified script from this post
  12. Hi, it can be done using sql substing query in the formula field: SUBSTRING ([@field:First_name] ,1 , 1) + SUBSTRING ([@field:Last_name] ,1, 1) However, in case of further using username field in authentication, this is not the best option since you can using only unique field as a username. Therefore, you may insert the following script in the footer of your submission form. <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var position1 = document.getElementById("InsertRecordFirst_name").value; var position2 = document.getElementById("InsertRecordLast_name").
  13. Mathilda

    Reports Dashboard

    You may consider creating tabbed navigation interface. Please have a look at this article
  14. You need to define all the criteria when you hide a specific field. It's allowed using fields several times in criteria. E.g: rule 1: when a = "no" hide B rule 2: when a="no" OR B is not equal 'other' - hide C This way you will get more flexibility in rules.
  15. Hi Julien, It seems that you just need to use cascading fields. You can use different data sources for parent and child fields
  16. I wonder who sets warning point? Is it a specific employee or you need to do that automatically after a specific action? Where do you store warning points? In users table or you have a separate table? Conditions which you described can be done in a view, however exact criteria depends on the current workflow. You may also have a look at this solution which should be close to what you need
  17. I use the following code in the header <style> #loader { border: 16px solid #f3f3f3; /* Light grey */ border-top: 16px solid #3498db; /* Blue */ border-radius: 50%; width: 30px; height: 30px; animation: spin 2s linear infinite; } @keyframes spin { 0% { transform: rotate(0deg); } 100% { transform: rotate(360deg); } } </style> <div id="loader"></div> And the following code in the footer: <script> window.onload=function(){ var x = document.getElementById("loader").style.display = "none"; } </script> Works fine o
  18. As far as I know, it's not possible to convert any datatype to string. It's a new datatype and hope conversion capability will be added soon.
  19. 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
  20. 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
  21. 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>
  22. Hi, you may use the following script in the footer of the datapage: <SCRIPT LANGUAGE="JavaScript"> function calculate() { var check = document.getElementById("InsertRecordField_name").value; if(check =="Approved"){ var v_increment = parseFloat(document.getElementsByName("cbParamVirtual1")[0].value); document.getElementById("InsertRecordField2").value = v_increment+1; } } document.getElementById("caspioform").onsubmit=calculate; </SCRIPT> You need to use a virtual field to sort values in descending order and get the last submitted value, then increment value and
  23. Yes, one more option is available. You may create a separate details datapage, make all fields to pass parameters and add an autosubmit script. Also create a submission form, add auto submit script and receive parameters in all the fields. In the destination after record update (in detail datapage) redirect to the submission form. Deploy the details datapage in html block on results page, you may find the similar solution here. So the workflow will be like this: You hit the link, the details datpages opens, autosubmits itself, passes parameters and redirects to the submission form. The su
  24. Hi Clint, Yes, it's possible. You need to create a submission form, deploy this form in an html block in your report and pass parameters to that form in query string. This way you may create a link or a button which will call a submission form. If you don't want to change data before submission, you may also add an auto submit script to submit datapage automatically.
  • Create New...