Anybody figured out how to update a specific cell when another cell changes?
The trigger cell and the destination cell are both in different tables but same base. (Actually the same method scenario can be applied when the trigger cell and the destination cell are in the same base).
The issue is the specific trigger cell can’t be defined in either the “When record is updated” trigger or in the “When record matches condition” trigger.
The reason for it is that the Trigger can’t be specifically tied to a specific cell. Without defining what specific cell Trigger should watch, the Action “Update Record” will only fill in the value from the 1st record of the field that the Trigger watches.
So while the Trigger field (in Table 1) changes, the target field (in Table 2) gets updated with the value from the 1st record of the Trigger field (from Table 1).
What I would rather want is the value updated comes from the specific cell in Table 1 (Specific record ID of the field the trigger watches).
This is what I need…
The fact the value from Table 1 cell is replicating to multiple Table 2 cells doesn’t matter (it could be just specific cell in Table 2 only).
This is the workflow I have done (plus created the view called “C” in Table 1 as described earlier)
The way I solved is I have created a view in Table 1. The view displays only the specific record I need for the Trigger to see. Because it now shows the record in the 1st row, I am then able to use the Automation to update the value in the target Table 2. So changes in the Trigger cell generates an update in the Target cell.
That’s the only way I was able to solve it with Airtable Automation. The values in Table 2 are filled in with a multiple Action steps (each individual step fills in one cell in Table 2)
Has anybody any other idea?
Of course another way to solve it is through Integromat for sure, but just wanted to stay within AirTable for this simple workflow. It’s quite rudimentary workflow so I am surprised something so simple can’t be done (yet) with Airtable Automations.
Update: Added images.