Updating values in a table different from the one that triggered an automation event

Hello There!

I have a table Users (fields: userid, firstname, choresOrder)

I have another table Chores (fields: userid, chore)

I have written an Apps Script that takes the list of chores for a given user and comes up with an order for a user to do those chores in (in the most efficient way possible).  

The Apps Script works fine and returns the chores order fine, but I'm having trouble taking the chores order (LongText) and updating my Users.chores_order field with it.

I have tried referencing an action in a data update action right after the script task by passing the values received in the return value; I choose the 'run actions on row' approach to call the Users action I've created but I can't seem to figure out how to pass in the return value from my automation to it.

I can confirm that all works fine when I simply update a value in the Chores table right after the script runs ... just when i 'run actions on row' in the external Users table does it all fail.

Any advice/help would be greatly appreciated! thank you!

Solved Solved
0 6 176
1 ACCEPTED SOLUTION

6 REPLIES 6
Top Labels in this Space