Edit data in table when action is performed on another table

[jrsmith252]

Hi all.

I'm not sure whether this would be an action or an automation... I have created a form (table A) where the user can add values from table B, via an EnumList. When these values are added (and the form is saved/created), I would like to automatically edit the value in a corresponding column (in table B).

E.g. The form is a shopping basket and allows you to add grocery items (from a shopping list). When a shop is confirmed (by saving the form), the items in the shopping list become "checked" in the purchased column.

Thanks in advance, 

Jack

[WillowMobileSys]

You need two things:

1)  create an action of type "Data: execute an action on a set of rows".  This action type allows you to transition processing from one Table to another Table.  Refer to the article below and find this action type for more details.

Actions: The Essentials

2) Create an action to update the Table B row.  You will likely need to use the INPUT() function to allow for passing of values from Table A to Table B.

INPUT() 

Refer to these to get started and then come back here with any questions you have.

I hope this helps!

[jrsmith252]

Thanks so much @WillowMobileSys, I will give that a try!