I searched a lot about my problem, I found half answer only ….
It’s a common problem I found several times on this forum but no real solution (I think)
I have 2 tables.
The table 1 create a line in the table 2 with automation. They have the same name project, no problem for that. I have several lines which are different projects.
then on the table 2 I update a cell to “ok” on a random project and I need that a cell in table 1 automaticaly switch to “ok”. on the same project line.
My problem is that the “ok” from the table 2 update the first line only of the table 1
How can I manage to update for exemple the project 3 cell to “ok” from table 2 to table 1 ?
thanks in advance.
Page 1 / 1
Screenshots would be helpful to understand what functionality your looking for, as it’s a bit hard to interpret.
Are you using a linked record field to connect table 1 and table 2? If so then you could use a lookup field to display the information from table 2 to table 1.
If you’re not using linked records, and you’re just using automation, another solution would be for your automation moving data from table 2 to table 1, use a “Find Records” action, and then a repeating group to update all the records found. Something like “Find Records where Project # = 3” and then update all records found to “ok”. That would push the information across multiple rows.
If you want data consistency between both tables, you need to link them.
In Table 2, create a linked record field that connects to the matching record in Table 1. When your automation creates a record in Table 2, make sure it sets this linked field to the corresponding project in Table 1. Then, add a lookup field in Table 1 to pull the "Status" field from Table 2 via the linked record.
If you can't use a linked record due to your setup, I’ll need more details about your tables to suggest an alternative. More context would be helpful.
when ENGINE is TO DO and AFFECTATION is YES=> line is created in TASK table
what I need to do : in TASKS table if ENGINE is DONE I need that MECANIC table update ENGINE to DONE related to the CAR
My automation is in French, maybe hard to read for you ?
I’m going to try to link tables but I found that it was not enough good for my manager.
I don’t understand that it is so hard to do this kind of automation between two tables while it’s so simple on one table
thanks !!
Understand that Airtable is different from a regular spreadsheet. In a spreadsheet, if you copy data, you end up with the same information repeated in multiple places.
But Airtable is a relational database, which means it helps avoid duplication by linking data between tables.
So instead of having the same data in two tables, you just create a link to the table where the data lives.
For your setup:
In your Tasks table, the Car field should be a linked record connected to the Mechanic table.
The Engine field in your Tasks table should be a lookup field that pulls data from the Mechanic table.
This way, when you update something in the Tasks table, it will automatically update in the Mechanic table too.
yes this kind of setup is quite simple, I manage to do that
I’m at this step below, now how to modify en engine status to DONE and how the MECANIC table could be updated ? because in TASKS table I can’t have the choice to put the ENGINE at DONE to update the MECANIC table, hope I’m clear
Take a look at my setup—you should be able to change the Engine field in the Tasks table.
Basically, include the Engine field in your Tasks table, and then use a lookup field in your Mechanic table to reference it.