Update Parent table status when child table is updated

[felon88]

Hi,

I 2 sheet in a googlesheet table: PLANNEDWORKS( Parent) with columns: UID, Status
SOW_SETUP(Child) with columns: REF, Status

I want to make it so when in the app i press the update for any record for the SOW_SETUP table and updates the status  for that UID in the parent table to the same status that the Child got. The child update is fine it is simple and it is working.

I know it has been asked many times, but I could not manage to work my actions with the codes from people. I feel like I am doing the same but the code just does not work.

I have been strugling with this ever since I started at this worksplace, and really would like to understand what went wrong here.

It would help tremendously if some could pinpoint what the issue is here.

[Steve]

Create an action on the parent table that sets column values using values provided by inputs:

Then create an action on the child table that invokes the action from above and provides the values to set:

[PyramidRebuild]

I have a question open along the same lines. I have already added the actions you suggested as I was following a youtube video. I however get an error in the app stating that the column is invalid.

[Steve]

Please start a new topic for help with this. Please include screenshots of the configuration and the error.

[PyramidRebuild]

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Updating-a-separate-table-when-a-form-is-submit...

The question is already open.

[PyramidRebuild]

Okay I was able to rub a few brain cells together to finish this task.

First of all I would like to thank @Steve For giving me the foundation to lean on with this endeavor.

Following the screenshots below you can set this up in just a few minuets. It is important that the ref columns on both tables contain the same identifying information.

In the Actions tab add a new action for the table that you want to affect. Next to the table name you will see a + icon if you hover your mouse. Skip the AI junk and select Create new action for (table). Follow the structure in the first screenshot.

You may see some warnings that will go away after saving your app.

Now add an action to the table that will be providing the data to update the affected table. Follow the second screenshot.

Save your app.

Once a user completes a form to add a row to the source table it will cause the data to be updated automatically to the affected table.