The Retrieve Values from Table action will pull values from one record in a specified table.
Parameters
Description | |
Select a table | Table to retrieve values from. |
Where | You will need a Record ID to identify which record you wish to get the values from. Select which record to retrieve using the Criteria Builder. |
If multiple results retrieve | Normally, you would retrieve field values of only one record. However, there are cases where more than one record matches your criteria.
Note that the following options will not return the value of the field itself, but return a specific numerical value depending on what is asked for.
|
Field(s) to Retrieve | Add any number of fields from the record. |
Where to store the value. |
Examples
In the below example, we are retrieving the name of the current user signed into the Method account. The name is placed into the action result "resultUserName".
In the below example, we are retrieving the number of customers who have a positive balance greater than 0 and placing the number in the action result "resultCustomerCount". In this situation, select RecordID for Field(s) to retrieve.
