Retrieve values from table

The Retrieve Values from Table action will pull values from one record in a specified table.

Note, if a screen contains fields from its base table, and the Screen Active Record ID is set, then those fields will be populated with values from the table record which has a record ID equal to the Screen Active Record ID. In this case, you do not need to use the Retrieve Values from Table action. 

There are many cases, however, where you will need to pull values from a table other than the screen's base table. 

  • Select a Table: table to retrieve values from
  • Where: Select which record to retrieve using the Criteria Builder
  • If multiple results: Normally, you would retrieve field values of only one record. However, there are cases where more than one record matches your criteria
    • First: If more than one record is found, only pull in values of the first record
    • Last: If more than one record is found, only pull in values from the last record
    • Minimum: If more than one record found, return the minimum value of the field specified in Field(s) to Retrieve. This field should contain a numerical value.
    • Maximum: If more than one record found, return the maximum value of the field specified in Field(s) to Retrieve. This field should contain a numerical value.
    • Sum: If more than one record found, return the sum of all the values of the field specified in Field(s) to Retrieve. This field should contain a numerical value.
    • Avg: If more than one record found, return the average of all the values of the field specified in Field(s) to Retrieve. This field should contain a numerical value.
    • Count: If more than one record found, this will count all the records and place the value in Place the Value Here instead of the Field(s) to Retrieve.
  • Field(s) to Retrieve: add any number of fields from a record and select where you wish to place the values (whether it be in an action result or a screen control)

Was this article helpful?

Can’t find what you’re looking for?

Contact Us