Update Row Action

[simongh]

I can't figure this out. The documentation just seems to hint at it without saying how you do it.

I'm trying to update a value in related table using an automation. I'm using a row action trigger with followed by an update row step. How do I get existing values for the row in the update row step?

[mikesealey]

Hey @simongh - Just a little disambiguation: Actions are triggered from within the user-facing part of the app - ie On screen load, or On-click actions

There is no "Update Row" action

Automations run in the background, often away from the user-facing portion of the app (though they can be triggered by an app-action. In the screenshot below are the 6 ways automations can be triggered.

When using an automation triggerd with "Row Updated" set to the Employees table...

... We then have access to the row in the bindings drawer.

In this example, I also have access to "Jobs" - a related table. I can use the values from the trigger row in a Query Rows step that looks at the Jobs table and filters where the Job._id is in the Trigger Row (employee)'s assigned Jobs