Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Look Up

Topic Labels: Automations Base design Sync
177 3
cancel
Showing results for 
Search instead for 
Did you mean: 
jzeller
5 - Automation Enthusiast
5 - Automation Enthusiast

I want to create look up field for only apartment details in a row that I have in a table called lease tracker in a base The row has 50 columns and lets say I just want 20 columns data to atomically go to the other tables in my base when updated to the specific unit number of a rental building. My current tables in my base are called, listings, building, apartment rented, calendly interaction,  and lease tracker.

I want the tables to look up the data in my lease tracker table and put only the apartment details in the other bases.  I have multiple buildings and multiple apartment number listed in two different columns of the table with the other columns so not sure how to look only the specific unit number of a specific building. I already have look up on these other tables to look up the building table and put it on the other tables automatically 

What is the best option to do this so I can share the individual apartment details with a building with the other tables.  

 

3 Replies 3
ibayub
6 - Interface Innovator
6 - Interface Innovator

you could try something like the following? 

Create a formula in Lease Tracker that combines the building and unit number into a unique identifier (e.g. {Building Name} & " - " & {Unit Number}) 
Add same formula to any other tables needed and link to Lease Tracker (can set this up as an automation too e.g. when Unit Number changes) 
Create lookup fields based on the linked record for the 20 detail fields

jzeller
5 - Automation Enthusiast
5 - Automation Enthusiast

This was very helpful thank you. Would you recommend to make this new unique identifier make this the primary field ? 

ibayub
6 - Interface Innovator
6 - Interface Innovator

Great! And yes - not sure about all of your use cases but having a more specific identifier as your primary field (e.g. the specific building / unit num) would be good idea!