Is there a way to update table1, as a result ...

Is there a way to update table1, as a result of a change in table2?

The only way I found is using Behavior->webhook

Can I do a simple column change to table1 although the trigger is on table2?

(The webhook seems to have unexplained behavior. The same POST works in Test mode, but fails with KEY not found in actual run. I canโ€™t figure it out)

0 4 322
4 REPLIES 4

I just realize that it probably can be done with a virtual columnโ€ฆ I just need to write the proper SELECT for the col

If the change in table 2 is produced by a form you can do this:
https://community.appsheet.com/t/update-data-of-the-other-table-when-updating-other-table/45564/2?u=...

If not, you may wanna do some formulas in the spreed sheet

FILTER() SORT() INDEX() are really helpfull

Yes thatโ€™s the easiest solution. If you need to do it with normal column, you can do that with action as well (if itโ€™s simple job to do). Check the sample app โ€œEventActionโ€ from hereโ€ฆ

appsheet.com - EventAction - Created by Aleksi EventAction - Created by Aleksi appsheet.com

@Yossi_Oulu you mention - โ€œThe only way I found is using Behavior->webhookโ€ - do you mean: Behavior-> Workflow OR Report->โ€ฆDO THIS = Webhook

Top Labels in this Space