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,...
Adam, sorry for the delay. I have been super busy! Thanks so much for the offer of help I really appreciate that. What I ended up doing was concatenating the location code and the room name together, and then created another table to link the new ...
https://airtable.com/app24R8HMNwTGZxg7/shrlgCRywtXaeQhQI Going to try to attach my Base this time. In the 'Data' table, I want to rollup all {Component}, for each change in the {Combine Location}, in the 'Loc2' table. The issue I have is that it is...
Sorry, I was looking to combine Components all in one cell, as changes occur in Location and in Room. I was advised to create a linked table, and then create a roll-up field based on a new field, which would combine both Location and Room. But, I d...
