Jump to content


Caspio Rockstar
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Mathilda

  1. Yes, there is a workaround. You can perform this calculation in a calculated field on a report datapage
  2. It seems that you didn't hit the "Source" tab before inserting code. You can find more info here
  3. What datatype those fields have? I have a few ideas, which I hope will be helpful. - Your variables A, A and MD are not defined (the syntax var= is missing). - "Insert record" syntax will not work since there is no form on the "show message" page, you can refer to fields using parameter picker, like var a = '[@Mailing_Addr_Type]'; - try using style.visibility.hidden instead of display none. I have a simple example of the similar workflow. <p id="first">[@field:First_name]</p> <p id="second">[@field:Last_name]</p> <script> var x = '[@field:Last_name]'; var y= '[@field:First_name]'; if(x==y){ document.getElementById("first").style.visibility="hidden"; }else{ document.getElementById("second").style.visibility="hidden"; } </script> Hope that helps
  4. Mathilda

    2 questions

    Hi, you an may rules for your workflow. 1. Criteria will be like that: when auth parameter is not equal to field#2 Action: hide a section with text (you need to place html block with text in a separate secion) 2. For example you have 4 radio buttons. Since we can use field in action section only once you need to define all the cases when a specific field should be disabled. - rule 1: criteria - when field1 is blank OR field3 is blank OR field4 is blank. Action: make field2 disabled - rule 2: criteria - when field1 is blank OR field2 is blank OR field4 is blank. Action: make field3 disabled - rule 3: criteria - when field1 is blank, OR field2 is blank OR field3 is blank. Action: make field4 disabled
  5. You may create a relationship between tables and enable referential integrity. In this case, user will not be able to submit a value into the related table which doesn't exists in the parent table. You can find more info here
  6. Have you tried creating a view? You can join two tables and allow editing data from the 2nd table. Hope that helps
  7. I have a few ideas: - your credentials are already cached in your browser - try opening in another browser - you specified incorrect designated entry page. You can find this setting in the time out and redirection section under Advanced setting in your authentication. You can read more here
  8. 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
  9. I would recommend using lookup table as a datasource for form element, in this case, user will be able to select only existing value from the list of available options.
  10. If you don't pass parameters to/from the datapage, try deploying in iframe. Perhaps script or css from CMS affects the datapage
  11. Hi Chris, Do you pass parameters to/from the datapage? If no, I would deploy the datapage in iframe
  12. Hi, I found this post with the similar question. Hope that helps
  13. Hi, I would use CASE statement in formula field. Add 3 formula fields: 1st followup, 2nd followup, 3rd followup E.g. for the 1st followup date: CASE WHEN [@field:priority]='HIGH' THEN DATEADD (dd , 1 , [@field:date_submitted]) WHEN [@field:priority]='LOW' THEN DATEADD (dd , 30 , [@field:date_submitted]) END You just need to change number in the Dateadd formula for two other followup fields. You can read more here and here Cheers!
  14. Hi, Yes, it's possible. You need to use combined chart and report datapage. Sort fields by performance field and return only 5 records, add a calculated field and use the sql query like: select avg(point_performance) from table name where user_id=target.[@field:user_id] The calculated field should return the average value. After that select combination charts and add two values there: value1 - columns - chart type use performance field value2 - line - chart type - use calculated field If you need to hide report and display only chart, you may use solution described here Hope that helps!
  15. you're welcome don't forget to insert your field names instead of mine. I modified script from this post
  16. 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").value; document.getElementById("InsertRecordUsername").value = position1.substring(0, 1) + position2.substring(0, 1); } document.getElementById("caspioform").onsubmit=concatenate; </SCRIPT>
  17. I would recommend checking that you have correct format for data/time input on the Localization of the receiving datapage
  18. You may have a look at this solution. Just add one more date condition
  19. Mathilda

    Reports Dashboard

    You may consider creating tabbed navigation interface. Please have a look at this article
  20. Hello Bill, I would recommend checking settings for download data. Make sure that you selected all matching fields from results page. Hope that helps
  21. You may try deploying data pages in table layout on your hosting webpage. E.g.: <table> <tr> <td valign="top"> deploy code of the first datapage </td> <td valign="top"> deploy code of the second datapage </td> </tr> </table>
  22. Hello, As far as I understand, you need to reduce space between the submit button and header of the record try using padding: 0px 12px; instead of padding: 10px 12px; for the .cbResultSetPanelDataContainer class
  • Create New...