This may be a quick fix that I’m missing but figured I’d ask the community for guidance here:
I have a base with 8 tables.
On 1 master table, I have a primary field (auto-numbered) and 7 additional fields pulling in information from linked records across the other tables.
Each record on this master table is only linked to 2-3 other tables, so the majority of the Linked column fields are blank - making it a pain to see all of the linked information quickly when expanding the record (I have to scroll passed a bunch of empty fields).
I’m wondering if there is an easy way (using either a formula or rollup field) to create an additional column on this master table that searches the other 7 fields and if there is a linked record, pulls it in to this field.
In a perfect world, the information being pulled in wouldn’t just be the text of the linked record but rather the actual link itself - essentially just combining all linked items across the different fields on the record into this one field.
Is this possible?
Appreciate the help!