- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 12:23 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 12:48 PM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 02:15 PM
This was very helpful thank you. Would you recommend to make this new unique identifier make this the primary field ?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 10, 2025 03:02 PM
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!
