I have been assigned to set up a table through AirTable for a mobile app team I am a part of. I do not have that many technical skills but have used Excel frequently. Unfortunately we are all still learning with AirTable and I have run into an issue that I cannot seem to figure out the answer to.
We have a base that contains a table called “Users.” We have configured our API to automatically update this table every time a new user joins and add them to it. I am working on another table in the same base that only lists users and characteristics from specific ZIP codes. The goal is to have this table update in real time so that we can see users from these ZIP codes only instead of digging through the master Users table. I’ll refer to the other table as “ZIPs” for clarity purposes.
Here is my issue: I have used a Linked column to bring certain users over to the ZIPs table and added several Lookup columns to pull certain pieces of information from each of those users. Things like their email address, street address, phone, etc. However, I am trying to split up the results of the lookup field so that they are placed into individual columns. I want one row to be designated for one user, instead of having them all in one. Here is a screenshot of my issue: https://prnt.sc/txfhex
I have already tried using the solution on this community forum post but the formulas did not work for my application of it. I also need something that will easily scale.
Any and all help would be much appreciated. Please let me know if you have any questions for clarifications or if you see a better way to import these users from certain ZIP codes. Thank you!