I’m trying to use a Airtable to track status on a project that has different potential vendors and customers. I need a way to bring status updates [notes from rich text]* into a field that is aligned with specific milestone [rows]. There can be multiple status updates in the same field e.g. Vendor A has status “xyz”, & Vendor B has status “abc”
My approach has been to create a link between my project table and Vendor table, and then create a rollup field for Status. The issue I’m having is if I add more than one vendor, there’s no way to tell which status update is assigned to which vendor. I think the right approach is to have a formula that would enable concatenation of Vendor Name and the related text from lookup and can display the information in a more readable format
- "Vendor A Name + “Status Update”
- “Vendor B Name” + “Status Update”
Would greatly appreciate help on solving this issue.
*note ideally I could parse the rich text and take the entry from latest entry, or entries dated within a certain time frame, but I don’t think this feature is supported.