I have a table with a remotely linked record, and when a record is added it fires a Zap. The Zap then needs to find the linked record in the other table. I cannot figure out how to look for the ID that I receive with the record. For example:
Table 1 (Employee): Name
Table 2 (Holiday): Date, Employee
When a row is added to Holiday I get a zap with the date, and an ID that links to Employee table. There appears to be no way to retrieve the Employee record to get the name. How can I do that?