LittleMsGinger

You can add a virtual field and set it as Calculated Value. You can have a formula to get the Name or the Display Value depending on the ID selected in the dropdown. Sample Formula: SELECT (NAME) FROM TABLE WHERE ID=target.[@Field:ID] Then, pass this virtual field as parameter. You can also hide this Virtual Field so it will not be visible in the form. https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/

You can actually receive parameter in Inline Add function. The form element must be Hidden.

Hi all, Instead of using script to pass parameters with '&', you can just use simple formula to convert or replace it in its corresponding URL encoded character. For more details, you may refer to this post:

Hello! Instead of using script to pass parameter with ampersand, you can just use a simple formula. You need to change the ampersand to URL encoded character. Add Calculated Value/ Calculated field and use: replace('[@field:FIELDNAME]','&','%26') Then, pass this field as parameter instead of the actual field. Lastly, hide this field so it will not be visible in the form. https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/ Hope this helps.

Hello Hayley, You can add a field either Calculated Field or Calculated value to replace '#' in the value to URL encoded character '%23' replace([@field:FIELDNAME],'#','%23') Then, pass this value as parameter. You can also hide this calculation, so it will not be visible in the form. https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/ Hope this helps.

For more details on how to add logout link, please refer to these links: https://howto.caspio.com/authentications-and-connections/authentication/logout-link/

Make sure that Enable cross app login is enabled in the Authentication. Also, deployment codes must be the same for all the deployed DataPages. Since Caspio Release 8.5, they highly recommends enabling Account Subdomains. It is best to redeploy all existing Caspio DataPages to avoid a mix of old and new deployment codes in your applications. Mixed deployment codes can cause usability issues such as preventing cross-app logins. For more details, please check this link: https://howto.caspio.com/deployment/caspio-site-vs-account-subdomain-deployment/

To filter the report and only see all the members under who logs in to the DataPage, you need to apply Record Level Security. For more details, here's the article that you may check: https://howto.caspio.com/authentications-and-connections/authentication/record-level-security/record-level-security/

Hi @Joemac, just to verify, you would like to use two views as the Data Source of one DataPage? If that is correct, unfortunately, it s not possible. You can only select one Table or View as a Data Source. You can just combine the Tables to create one View and use it in the DataPage. Hope this helps!

Here's the sample Tasks that you can create This will update every record in the Table and it will run every day. As best practice, you can try this first in a Test Table or have a back up of your Tables.

Hello, You can create an Application Tasks to automatically update the Table and run it everyday. Tasks are operations that you can create in your application and run them manually or automatically based on a predefined schedule. They can be very useful for automating repetitive actions, like data modifications or sending email and SMS notifications. Check this link for more details: https://howto.caspio.com/tasks/

Hello, Just to add in the previous comment, you can use a Select Statement in a Calculated value to get information from the other table. https://howto.caspio.com/datapages/datapage-components/calculated-values/ As per MayMusic's suggestion, you should receive the field as [@L1_time_in]. It means that it is a parameter. Make sure that you also pass the value from the other DataPage. https://howto.caspio.com/parameters/parameters/

You may find more details about calculated value in this link: https://howto.caspio.com/datapages/datapage-components/calculated-values/ You can also find the list of formula here: https://howto.caspio.com/function-reference/

Just wanted to add, here are the other references regarding API from the Caspio's howto link https://howto.caspio.com/web-services-api/creating-a-web-services-api-profile/ https://howto.caspio.com/web-services-api/rest-api/authenticating-rest/ https://howto.caspio.com/web-services-api/web-services-api/ https://howto.caspio.com/web-services-api/rest-api/important-header-parameters/

Hello! Just to provide more details on this, adding criteria to the Results Search Form can allow field to accept multiple values.