Re: Parsing Linked Records Across Multiple Columns with Existing Tags

Tim_Miano · ‎May 01, 2020

In my first table, I have Projects: A, B, C. They are single select tagged as Locations 1, 2, 3. They are tagged with Persons (a Linked Table).

In my second (Linked) table, Persons. All the Projects are automatically combined into one column.

Users will input data in the first table. In the second table, I need each Location to be a column header, so that each Project is parsed across those location columns.

In short, I need the tags in the first table to be the column headers in the second table.

Help would be appreciated!

Elias_Gomez_Sai · ‎May 01, 2020

So you have these tables:

Projects, with fields Locations (Single Select), Persons (Linked Record)
Persons, with fields Projects (Linked Record)

What you mean?

I think you need a third table for Locations, why you didn’t make it?

Your terms does not make sense to me (tags, columns headers, etc). You have to explain your use case, which “thing” belongs to another. A Person lives in a Location? A project is made in a Location? Then you make the logic relations with Linked Records, and then you can show data from other tables via Lookups and Rollups.

Mohamed_Swella1 · ‎May 02, 2020

Hi @Tim_Miano,

As @Elias_Gomez_Sainz said, If you explain to us why you need it we can help you better.

The short answer is this cannot be done.

BR,
Mo

Tim_Miano · ‎May 03, 2020

I appreciate the help. Here is my input table: https://airtable.com/shrLR0QkelTCEgIHJ

Staff can add locations.

In my mind, the visual I want to see is here: https://airtable.com/shr5O4BQEB51gUkLW

People will looking though 100+ projects, and tagging locations. But then, they’ll need to see how the services parsed by the level tags.

kuovonne · ‎May 03, 2020

You might need a different base design and input format to accomplish what you want. Take a look at the support documentation on many-to-many relationships and junction tables.