Aug 08, 2022 08:22 PM
I have two large tables with different data for members of my union. Individual members in both tables share the same ID # in a field in both tables.
I’d like to link the tables in such a way that data from field from Table A will automatically copy to a linked field from Table B, based on the common ID# field that the two entries/rows share.
How would I go about doing this?
Most beginner field-linking demos show me how to link fields, but then I have to select which record to link to manually by expanding the cell and selecting the record. But Table A and B both have hundreds of records and I would like to automate this process so that anytime there is a value in the linked field from Table A, it gets automatically added to the linked field in Table B, organized around their shared ID # field.
I can do some scripting but am not an expert.
Aug 08, 2022 09:45 PM
Hey Jacob, I think if I were you I’d reorganize the tables so both their primary fields were the common ID# field
Once that’s done, we can then just paste the commond ID# value into the linked field, and the links would happen automatically
(We can also automate this step so that any new rows that get created have this done automatically too)
Aug 09, 2022 01:44 PM
I’ve been trying this out and have a few questions
When I set this up, it makes automatically makes 2 fields in my Table B.
One called “Table A” that just copies the Primary Field (ID #) of the values being copied from Table A. And another field that has the info I want to copy.
Is it possible to get rid the Table A Primary Field copy over to Table B?
What is the way you suggest to automate this process when adding new rows?
Aug 09, 2022 05:26 PM
Hmm, sounds like the data you’re copying over has a comma in it! You’re going to have to replace the comma with something else I’m afraid. When we paste comma separated values into a linked field, each value gets treated as one record
This would depend on how your rows are getting added to
Table A. If these are made via a form or an API call, using the trigger “On record created” would do fine.
If you’re creating these manually, we need to make sure the automation only triggers after the common ID# has been fully keyed in, and the simplest way to handle it would be to just use a checkbox field to trigger the automation. (Honestly, the field’s created manually it might be simpler to just paste it in)
Aug 16, 2022 11:43 AM
I think I got a working system going based on your first example.
For the 2 fields question above I think I can state the issue better.
Can I link two tables just with a look up field, and not needing to first assign a field “link to another record” first? It makes an extra placeholder field that I don’t use.
Aug 16, 2022 12:05 PM
Look Up fields only work with Linked Records. If you do not want to see the created Linked Record, you can Hide the field from View.
Aug 16, 2022 07:29 PM
You can also consider gathering all data into one table and use different views for different sets of data.