Reference child column value from parent

[Surendra_Dhanra]

I’m adding rows to a child table.

I’d like after i add a new row in the child, that a value from this child record updated a value in the parent record.

Regards
Suren

[_redline]

Your best bet currently is going to use the INPUT() function to update your parent table. See the following post.

Using INPUT() to update another table using a value from this row Tips & Tricks 💡

This “Tip” is a little report, with a sample app, on my own attempt to familiarize myself with the new INPUT() function. As @praveen has indicated, the advent of this function gives us the power of an “UPDATE EXISTING ROW(s) using values from this row” action: Here’s a sample app I made to test this out: https://www.appsheet.com/samples?appGuidString=502cc394-2717-4a69-8246-5fc26a1aa9cf This extremely simple app has two tables: one with multiple records and one with only one record. The i…

[Kirk_Masden]

Thanks for citing my post, @_redline

[Steve]

If the new row is added by saving a form, you can configure a Form Saved event action to perform an action that updates the parent.

Alternatively, you can create a bot that reacts to new child rows by updating the parent row.

See also:

help.appsheet.com

Actions: The Essentials

Learn how to use actions to modify data and navigation in your app.

help.appsheet.com

AppSheet Automation: The Essentials