Update a parent table field based on a child table field on create / edit

AppSheet AppSheet Q&A
1

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

Child table:

Move Out

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.

2

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

1 Like