ray

Hello Alison, This is not working for me. I have placed this in the footer of Configure Results Page Fields but there are two columns with no values in any of the results and they still display in my tabular report. I tried putting the link to jQuery in my HTML page as well with no luck. The empty fields I am trying to hide are 1) a text field and 2) a foreign key field. Are there any qualifiers to add or other issues that might be affecting my success? Thank you!

Hi Vanellope. Thank you for your insights. I ended up using a triggered action to meet my needs. I continue to find more uses for Triggered Actions and Tasks!

Thanks much Vitaliksssss. I received the external parameter in the HTML Block and added CSS to the Caspio style I am using via the Style Source editor.

Hello. I see how I can create separate Date Time fields on a Submission form. This is working but if I want to return to that record to edit the Time portion of the Date this method does not seem to work. Is there a way to adapt this for Updating, or is there some other way I can see my Date with Time to allow an edit? Currently the only way I am able to view the full Date and Time in a single field on a Details page is by making it Display Only and setting the formatting. I have played around with localization but it still seems that I cannot see the Date and Time together in an editable Text field on my Details page...

Hello. I am using an external parameter from a query string to populate a display only field on a submission DataPage. How can I apply basic HTML styling to the field? For example, field Virtual1 on the DataPage is accepting the external parameter [@Task]. I have tried referencing the field in an HTML block using [@field:Virtual1] and [@cbParamVirtual1] and [@field:cbParamVirtual1] but nothing is showing up. I am hoping it is something simple...

Answering my own question; when referring to the authfield in the javascript I was using the name of the field in the Users table. I should use the name of the field in the view that is based on the Users table.

Hello. I am trying to configure a login redirect based on user role per: https://howto.caspio.com/tech-tips-and-articles/common-customizations/create-user-specific-redirect-after-login/ My Admin user role is indicated by a YesNo checkbox in the User table that the authentication is based on. Here is my javascript from the source code of the footer of a standalone Caspio HTML login page: <script> if("[@authfield:Admin]" == "Yes"){ window.location = "https://[myurl]/a_dashboard.html"; } else { window.location = "https://[myurl]/s_dashboard.html"; } </script> The Authentication I am using has the redirect "Advanced Option" set to "Same Page" for a successful login. If I enter a redirect here I can only enter one URL. When I try to log in with a User having the Admin role (YesNo checkbox checked), I do not get a redirect to the a_dashboard.html. The login.html web page just refreshes but no longer displays the embedded Caspio login form. Everything works if I remove my javascript redirect code and just let the Advanced Options of the authentication specify a particular page to go to, but this doesn't let me redirect by role...

Hello. I have a datapage (datapage A) that includes a few fields that I would like to autofill with default values. The catch is that I want a user to be able to occasionally change what those default values will be--not be typing over them--but rather by defining them from another datapage; kind of like a settings page for the application. If I store the defaults in their own table there would only be one row for the table and the user would just edit that row when they wanted to change the defaults. I think I can use a trigger to insert the default values in datapage A when I am creating new records. How would I go about maintaining a defaults table with a single record? I don't want to use a two part edit form to "find" the only record in the defaults table before editing it. Is there a better way to go about this? Thank you.

Thank you for the reply. I should have explained that the dropdown I am working with lists values from a related table. I would like to know how to pass the display value of the dropdown as opposed to the (foreign Key) value stored in the dropdown.

Hello. Apologies if this is addressed in another post. I want to pass the selected display value of a dropdown as a parameter for use in the header of another DataPage. How would I accomplish this?

Hello. Use javascript on the DataPage to concatenate the fields you want in your composite key and create a new field in the table to store the concatenated value. Set that table field to Unique and you should get an error when you try to save a record that duplicates the composite field.

Hi Ariel. The Conditional Forms help page does suggest that you can conditionally show a field if it is initially hidden by some condition. I have tried this but cannot get a "Show" option in the Rules Action dropdown for a section or field. Hide seems to be the only choice and once you specify an action for a particular field you can't make a new rule for that field...

Hello. I am trying to sort out the capabilities of the new formula data type in v9.4. I'd like to combine text fields and a date field in the formula but I get an invalid formula error when just combine the fields with a "+ Str(1)+". Do I need to convert the date to a string? Also, the formula seems to reference the stored value of a foreign key in the table. Is there a way to use the display value of a related field instead? Thank you.

Hello. I would like to concatenate two text fields (both foreign keys) and populate a third text field in the same table with the concatenated value when submitting a DataPage. I understand how to do this when I am concatenating the stored value of the fields, but I would like to concatenate the display values of the two lookup fields, not their stored values. Please advise.

Hello. I would like to pass multiple parameters from a Detail DataPage to another page upon saving the record. I understand how to pass the parameters and specify a destination after update. The trick for me is I would like to have multiple Save buttons on this Detail page, each with a different destination after update specification. The user would choose which Save button to use based on what DataPage they want to go to next. Is this possible? Thank you.