Mathilda

Yes, there is a workaround. You can perform this calculation in a calculated field on a report datapage

You're welcome!

It seems that you didn't hit the "Source" tab before inserting code. You can find more info here

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

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

You're welcome

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

Have you tried creating a view? You can join two tables and allow editing data from the 2nd table. Hope that helps

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

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

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.

If you don't pass parameters to/from the datapage, try deploying in iframe. Perhaps script or css from CMS affects the datapage

Hi Chris, Do you pass parameters to/from the datapage? If no, I would deploy the datapage in iframe

Hi, I found this post with the similar question. Hope that helps

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!

You're welcome

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!

you're welcome don't forget to insert your field names instead of mine. I modified script from this post

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>

I would recommend checking that you have correct format for data/time input on the Localization of the receiving datapage

You may have a look at this solution. Just add one more date condition

You may consider creating tabbed navigation interface. Please have a look at this article

Hello Bill, I would recommend checking settings for download data. Make sure that you selected all matching fields from results page. Hope that helps

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>

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