Update data of the other table when updating other table

[Dahabu_Saidi]

Hi Team,

I have a scenario here. I have two table orders and tickets. What I want is when I update the ticket and orders table should be updated automatically. I want to update the order details of specific orders and new order details are data from the tickets table.

I use two actions, one created in tickets so that it can be called when updating ticket of which it calls other actions orders to update record data

[Entrenador_Hisp]

Hi guys I finally got it!

There are 3 Major WAYS TO ARCHIVE THIS.

#1 ACTIONS
By far the best and most elegant one.
Appsheet have this amazing feature, when you create a FORM VIEW you can program an instant ACTION TO EXECUTE when it is saved. (behavior option at the end of the view/form menu)

So you create an action for TABLE 2 with the “EXECUTE AN ACTION TO A SET OF ROWS”
and you select TABLE 1 as a TARGET TABLE then you select which rows you wanna change.

You will need to create other action for TABLE 1 to actualy change the TABLE 1 Data.

So you create an action for TABLE 1 “Set values of some columns in this row”
And you program some formula like this:

Select(Table2[id], condition, etc etc )
or may be MAXROW or anything to acces the new TABLE 2 DATA

THEN YOU LINK BOTH ACTIONS.
YOU CAN MODIFY THE VALUE ON TABLE 1 WITH A FORM OF TABLE 2

Other not so cool solutions:

#2 SPREEDSHEET FORMULA
Its kind of hard to figure it out at the beginning but it is really powerful and I believe it save you some processing for heavy formulas

Table 1 may have a constant FORMULA to refer TABLE 2
SORT() - FILTER()- and INDEX() are the essential functions

#3 USE VIRTUAL COLUMN
Use a virtual column on table 1 that is linked to table 2 via some formula
the problem is you are not able to “save” the result in table 1 easily

#4 USE WEBHOOKS
I dont know anything about it yet, but I have seen it is possible