Sync linked cells

Ask for Help
1

Hi!

I want to link 2 Glide tabels to each other, and make sure they sync if I change the value in the original cell.

Is this possible?

2

You could use a Relation to link two tables together and then use a Lookup to bring a specific column value across.

1 Like
3

Hi Jeff,

Happy new yar and thanks for reply!

Iā€™m looking to link a value, which is giving the record all the information, depending on the linked value.
At the moment the link ā€˜diesā€™, if I change the linked value, in the ā€œinfo-databaseā€ā€¦

Do you have any idea how to set this up successfully?

4

explain betterā€¦ is confusingā€¦ are you syncing depending on value? or it is a fixed link? for the fixed linkā€¦ use row ID, for dynamic use valuesā€¦ butā€¦ if you have the same values in multiple rowsā€¦ connection will breakā€¦ unless you check multipleā€¦ but the result will be an array

1 Like
5

You should probably be using RowIDā€™s to create your relations. Row ID doesnā€™t change unlike a text value that can be changed.

3 Likes
7

As long as you write a RowID instead of the QR code value, then you can use a Relation/Lookup to retrieve the appropriate QR code value from the appropriate table, based on the RowID. Itā€™s safer to build build relations that way, because you avoid the chance of a user breaking the relation by changing a value thatā€™s used to establish the relation. Users shouldnā€™t need to see or be able to change Row IDs, so they canā€™t break the relation.

1 Like
8

yepā€¦ use row ID, if users can modify SKU

1 Like
9

Sounds like a safe solution!

Thanks a lot guys, for fast reply and great solutions!

2 Likes
10

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.