With a lookup table, you can automatically translate information from one app into a format that another app will understand. This is useful if two apps that you are working with have different terminology when referring to the same thing. Lookup up tables can only be used in an action, not in a trigger.
If your trigger app only passes on a name but your action app needs an ID. You can create a list of records your trigger can search for and then pass on the correct value.
- Lookup key: the data you wish to search within your lookup table for.
- Lookup table: this is made up of two columns. The first one is what will be used to match the lookup key. The second column is what you want to output if your lookup key matches.
- Fallback value: if your lookup key doesn’t match your lookup table, you can choose to have a fallback value. That way there will always be an output available.