I have a few use cases where I have two fields, but I want to show all items from both fields in one (view or field) to make it easier from users. A few examples, but there are many other areas where it’s relevant:
- An application has a Case Officer and a Submitter. They both relate to the Project Contacts database and are therefore 2 fields on both databases. This is fine for the Application database, but in the Project Contact, I want to show all Applications relating to that contact in one View, rather than “Applications where this contact is the Case Officer” and “Applications where this contact is the Submitter”.
- Projects have Related Projects. Because it’s a relation to the same database, it creates 2 fields. When a related project is added, the current project shows in a 2nd field for the related project. Again, I’d like to consolidate these so users don’t have to check 2 fields/views, which is unintuitive and takes up too much space.
I cannot seem to create a formula that lets me consolidate these 2 fields, or a view that will show both dynamically.