Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation on 10/05/2021 in all areas

  1. Okay, I just checked. You can also have a virtual field on search forms, but the virtual fields on the search form cannot use a calculated value as a form element.
    1 point
  2. As mentioned above by @LittleMsGinger, the idea is to have a calculated value to convert the selected values from their actual value to their display value. However, take note that this will only work if you are coming from a form type of datapage (Submission, Single Record, Report Details) since these are the only page that has a virtual fields.
    1 point
  3. 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/
    1 point
×
×
  • Create New...