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)
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
User | Count |
---|---|
43 | |
29 | |
23 | |
21 | |
13 |