I am trying to create a system for project managers at our firm to request a new project.
I’m thrilled about the new conditional fields in form view as it allows me to only show fields if the requester has selected certain parameters.
It works like this: Project Manager fills out the airtable form. One question is multi-select and asks what services we are including to the client. PM selects all services we are providing for that project and because I’ve got conditional fields set up, it only asks additional questions about the services selected.
That part works great - however, when our accounting team goes to look at the records submitted through the form, there’s A LOT of blank cells because the project managers are only filling out questions for the services they selected, not every possible service.
I’m looking for a way to hide blank cells when a record is expanded from grid view, OR from one of the other views if necessary.
Any ideas?