Mar 01, 2020 08:12 AM
Purpose:
In a table where the field is a “LINKED to record” field.
Many times the value for the LINKED field is a value in another text or formula field.
A script that can take the value of a string field, and insert that value to the LINKED To field so that the lookup is somewhat automatic. Currently the only way to do this is to manually do a copy/paste from one field to the LINKED Field.
I believe what would need to be done is -
ie.
Master Table
Phone # Link to Contacts via Phone Name Lookup
111-111-1111 111-111-1111 Abe Lincoln (This is the desired result)
Lookup Table
Phone # Name
111-111-1111 Abe Lincoln
Apr 13, 2020 12:17 PM
I’m looking to do the same thing! Copy and paste from a text/single-select/multi-select field to a linked field. I currently have to copy and paste manually, which works perfectly as expected but is inefficient.
Would really appreciate help here as well!
Apr 18, 2020 06:24 AM
I would also love to be able to do this automatically.
Apr 20, 2020 10:35 AM
Hello,
I saw this post last week but didn’t feel qualified to answer as I am just now beginning to learn JavaScript myself.
I wanted the same thing from a Script about a month ago and had some success so I thought I would share now and hopefully help some people out even though I myself, am no expert.
If I understand the specs correctly, this is the script will allow you to populated a linked field based on a match between two tables:
Hopefully this is clear enough to apply to your base! Please understand that there might be a more efficient way to do this, but I hope it helps.
Good luck!
Apr 27, 2020 03:45 PM
Hello,
I tried but It doesn’t work. I’m not a developer and I discover the Javascript with this new Airtable Block…
I would like to do this :
It would help me for many cases. I would greatly appreciate your help !
May 27, 2020 12:50 PM
I’m trying to do the same. Got any new ideas?
May 28, 2020 03:53 AM
I find a solution and will post it very soon.
Aug 27, 2020 07:57 AM
Same problem… Catherine, any updates on the solution?
May 17, 2021 06:35 AM
Hello,
I’m stuck on this topic as well. Tried running the script and I think it fails when there isn’t a match, which sometimes happens at least in my use case.
Can somebody help? It’s really quite a big blocker not being able to use a formula as a link?
Cheers,
Alivia
Apr 21, 2022 02:46 AM
Solution: