-
Content Count
464 -
Joined
-
Last visited
-
Days Won
49
Everything posted by Mathilda
-
You see two authentication forms decause you deployed two datapages on 1 webpage. You may use this solution in order to have only 1 login form
-
Use a Formula within a Formula
Mathilda replied to tconnery's question in Calculations and aggregations
Yes, there is a workaround. You can perform this calculation in a calculated field on a report datapage -
Can't get Java to read variables
Mathilda replied to Brasovan's topic in User JavaScript and CSS Discussions
You're welcome! -
It seems that you didn't hit the "Source" tab before inserting code. You can find more info here
-
Can't get Java to read variables
Mathilda replied to Brasovan's topic in User JavaScript and CSS Discussions
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:L -
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:
-
Validating User Input in Cascading Autocomplete Field
Mathilda replied to Student2017's question in General Questions
You're welcome -
Validating User Input in Cascading Autocomplete Field
Mathilda replied to Student2017's question in General Questions
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
-
Login screen html doesnt work
Mathilda replied to mr21xm's question in Security, Authentications, Roles, SAML
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 -
user changing field value calculated by formula?
Mathilda replied to humidor's question in Tables, Views and Relationships
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 -
Validating User Input in Cascading Autocomplete Field
Mathilda replied to Student2017's question in General Questions
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. -
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
-
varying formulae criteria based on user selected options
Mathilda replied to humidor's question in Tables, Views and Relationships
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! -
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 d
-
Taking first letter from field A and combining with field B to create Field C
Mathilda replied to rwoolf's question in General Questions
you're welcome don't forget to insert your field names instead of mine. I modified script from this post -
Taking first letter from field A and combining with field B to create Field C
Mathilda replied to rwoolf's question in General Questions
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"). -
Pass a date field as a parameter with a format of YYYY-MM-DD
Mathilda replied to CodeRedLLC's question in Parameters
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
-
Hello Bill, I would recommend checking settings for download data. Make sure that you selected all matching fields from results page. Hope that helps
-
Datapage columns customisation
Mathilda replied to MyNameIsSean's topic in User JavaScript and CSS Discussions
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>