Help

Lookup Field not retrieving values from

Topic Labels: Data Sync
731 1
cancel
Showing results for 
Search instead for 
Did you mean: 
John_Q
5 - Automation Enthusiast
5 - Automation Enthusiast

I have two Tables in the same Base.

One field in the table (APPAREL) should look-up the value in another (SC APPAREL SYNC)

Here is the Field (TEST2) in the APPAREL table which should look up the SAMPLE COORDINATOR in the SC APPAREL SYNC

John_Q_0-1685548671038.png

As you can see, every record in my SC Table has a value (no empties)

John_Q_1-1685548802104.png

As you can see... all records are empty in the APPAREL

John_Q_2-1685548865135.png

The field I am looking up is a synced field from another table. How can I fix this?

1 Reply 1

It's a little difficult to know for sure without seeing your base but it looks like you might be thinking of lookups differently than intended.

A lookup field requires the linked record field it's configured for to be populated in the same table that it is in. When this linked record field is populated, the lookup then pulls the value of a selected field in the linked table that is associated with the linked record.

For example, a lookup field in APPAREL will only populate if the linked record fields between APPAREL and SC APPAREL SYNC tables are also populated AND there is a value in the field you are looking up.

Hope that helps!