Lookup Tables
- Yashna Chhatwal (Unlicensed)
With a lookup table, you can automatically translate information from one app into a format that another app will understand. This is useful if your app and Eshopbox app have different terminology when referring to the same thing. Lookup up tables can only be used in an action, not in a trigger.
Steps to create Lookup Tables in automation:
After selecting Utilities as the Action Event in automation editor::
Lookup Table: Using the Lookup Table section you will want to add each of the possible items you want to search for in Key-Value pairs. Key is the value you will search by and Value is the output. The key is case sensitive, so take that into consideration when setting up your lookup table.
Fallback Value: The value to be used if we do not find a matching value in Lookup Table.
Map out the formatter step’s output field in Action
You will then need to map out the output field of the Formatter step onto the Action field that requires the converted value. You do this:
Select the dropdown and scroll all the way to the bottom
Select Use a Custom Value (advanced)
Now map out the output from your Formatter step
References for UI:
