Update a parent table field based on a child table...

arun_kumar · 12-09-2020 07:42 AM

I have created a rent application. I need to track the product status whether product is out and in.

Parent table.
Product

Product ID
Description
Status - Out / In
Related out table - List

Product ID Ref to Parent
date out
customer
returned - Yes/ No
return date

When an entry is added to Move Out, I want to update the Status in Product to ‘Out’.

When an entry is edited and returned field updated as ‘Yes’, I want to update the Status in Product to ‘In’ .

I am not sure how to do this.

LeventK

You can gladly use Webhook Workflow for both tables set with UPDATES_ONLY mode and make a call to preset AppSheet API :: Edit Row