Hello:
New to Airtable and new to the forum here...
Looking for a solution to combine records in my field {Component], for every change in records in my fields {Location ID} and {Room}. For example, in the attached image I would want to combine WF218, W361824, RF9624 3/4, W3330, and so on to B18, in a new field. This is to correspond with {Location ID} 1-3-302 and with {Room} A Acc Kitchen. For the next combined field, the result would be ADA SB30, for location 1-3-302 and room A Acc Bathroom. I would like to accomplish with a formula, but I understand I may need to create a new linked table.
I am attaching 2 views; one is grouped and one is a straight view, for clarity. Thanks so much!!