Hi, I have a few tables and i want to trigger an automation when a record is added in table 4 but go up the tables to get a value from table 1.
Houses > Rooms > Items > Reciepts (best example I can think of!)
When a new reciept is added I want to send an email to say here is a reciept which was added to item X in room Y at house Z.
The new reciept has an Item ID in it but that field is an array of item IDs, so at the moment I have my input variable set as:
let itemID = input.config().ItemID
Is that the right way to do this?
Next I want to go into rooms and find the room linked to that item, but again the linked field is an array which is confusing me!
Would love some help,