Script Request: Copy the value of a field to a Linked field in a table to perform a lookup in another table

[Doug_Kaufman]

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 -

• Copy the table field from to a variable
• Do a lookup in the LINKED Table
• Insert the valid lookup into the LINKED TO Field
• If there is an invalid look - then don’t display anything

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

[Product_Novus]

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!

[Glen_Saberton]

I would also love to be able to do this automatically.

[Sam_Cederwall]

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:

gist.github.com

https://gist.github.com/SamCed/ebf59a1a063fa43e94a25a9c41c14d56

linkfields.txt

//Copy Values to a linked field

//Declare tables
var activeTbl = base.getTable("The table where you need to copy values to");
var linkTbl = base.getTable("Table that contains your linked records");

//Declare queries
var activeQry = await activeTbl.selectRecordsAsync();
var linkQry = await linkTbl.selectRecordsAsync();

This file has been truncated. show original

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!

[Catherine_Garni]

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 !

[Eduardo_Starost]

I’m trying to do the same. Got any new ideas?

[Catherine_Garni]

I find a solution and will post it very soon.

[Yvan_Belier]

Same problem… Catherine, any updates on the solution?

[Alivia_Smith]

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

[Christian_Heins]

Solution:

gist.github.com

https://gist.github.com/SamCed/ebf59a1a063fa43e94a25a9c41c14d56

linkfields.txt

//Copy Values to a linked field

//Declare tables
var activeTbl = base.getTable("The table where you need to copy values to");
var linkTbl = base.getTable("Table that contains your linked records");

//Declare queries
var activeQry = await activeTbl.selectRecordsAsync();
var linkQry = await linkTbl.selectRecordsAsync();

This file has been truncated. show original