Reference child column value from parent

AppSheet AppSheet Q&A
1

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

2

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](https://community.appsheet.com/t/using-input-to-update-another-table-using-a-value-from-this-row/51195) 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…

1 Like
3

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:

1 Like
4

Thanks for citing my post, @_redline

1 Like