Reference Table

[Cyrine_Mae_Mend]

Hi,

I need your help regarding with referenced table. I have here a table1 that is linked to table 2. The expectation is every time I make an update to a specific column in table1; it will automatically update on the equivalent column on table2. Any recommendation on what will I do to achieve this expectation?

[_redline]

When you say that Table 1 is “linked” to Table 2, do you mean that Table 2 is the parent table and Table 1 is the parent table? Currently the M.O. to modify tables with values from other tables is to use the INPUT() function coupled with some actions. See the following elegant description of the process:

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…

[Steve]

Reference child column value from parent Questions

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: