Hello, I have 2 tables with the same names and addresses. I would like to set up a kind of mirroring of the columns so that if I change the address in one table, for example, it is automatically changed in the other table. That should also apply to columns with, for example, telephone numbers.
Does anyone have a solution? I haven’t found anything similar here.
The standard way to do this is to have one table that is the source of truth, and then pull the needed values into any other tables as computed columns using relations and lookups.
1 Like
Thanks, Unfortunately, I’m not very familiar with the application yet. Can you describe the process to me? I’ve tried a few things, but I haven’t come to any conclusion. I have a table called “Students” which contains, among other things, the column “Address”. The second table “OGS” also has the column “Address”. The names are also in both tables. I’ve set up row IDs for both tables.
In the “OGS” table, you should store the student’s ID, or any pieces of info that is unique to the student.
Then, create a relation using that student ID back to the Students table, and retrieve the address using a lookup on top of the relation.
That way, you just need to edit the address for the Students table, and it will be updated in the OGS table.
1 Like
Yes, but how do you handle the situation when new entries are added in the OGS table?
Good question, I’m assuming once the flow is set for him, he will add data on the Students table first.
Hm, it sounded as if the initial question was related to “automatic mirroring” of tables. So I am assuming that it is an identical table - not some other attributes that could be indeed resolved via relationships.
This identical mirroring could be interesting when trying to bring data that is for instance in a GS table to Glide.
Yeah, without any further clarifications from the poster, if the tables have to stay that way, it would have to involves relations & set columns on both sides.
However, I feel like we might be able to adjust the data structure, hence the suggestion.
These are different tables. Only the personal data is identical, such as name, first name and address.I would like to maintain this data in the student table. The OGS table is not filled with new data. New students are always entered in the student table.
1 Like
Thanks to everyone for the quick and uncomplicated help. After a few attempts I managed to get it to work the way I wanted.
1 Like