Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Looking up records with IDs

Topic Labels: Scripting extentions
792 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jac_Evans
6 - Interface Innovator
6 - Interface Innovator

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[0]

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,

Thanks!

0 Replies 0