Apologies in advance if this was posted elsewhere - my use-case is slightly different from what I was seeing and I can’t seem to figure out how to get the results that I’m looking for - was hoping the community had some advice!
I imported 3 tables into Airtable:
Most of the spaces have several brokers listed on them, so on the Broker Assignments table, the same space is often listed 2-3 times with the corresponding broker. Similarly, there are brokers who are assigned to multiple apartment listings and if you sort by Broker ID, there could be 5-10 spaces that line up with them.
What I can’t seem to figure out is how to bring all of this information on to the first table (Apartment Listings), so that I have a linked field that lists all of the assigned brokers for each space and can be clicked on to bring up the individual brokers card and all of the spaces that he/she are associated with.
Does this make sense?
AnY and all help is so appreciated.
Thanks in advance!
I would do this:
For Broker Assignments do this:
On steps 2 and 4 as Airtable knows that the unique ID is the primary key (for apartments and brokers), it will link the records automatically.
Thank you so much for chiming in here! I followed these steps and was able to get 90% of the way there - something I couldn’t have done otherwise so thank you so much!
The step not discussed was needed to convert the broker assignment ID’s (which were being mirrored to the apartment listings table) from the actual number of the assignment to the broker names. So once I had the listings and brokers tables linked to the assignments, I did the following:
As a result, the Listings page which had been pulling just ID numbers was now pulling the actual names.
Thank you so much for your guidance and help here!