I’m building my database into a website and in order for me to create filters, I need a lot of data in form of multi-select fields.
I have two cases where I struggle to automate this:
- A linked record column:
I want to have whatever is in this column to always be added to a multi-select field
- A roll-up field:
I want the values that the roll-up gives me to be added to a multi-select field
Currently, I need to always copy the entire column and paste it into a multi-select field. That works for now but isn’t really scalable and it’s too easy to forget / make mistakes.
Has anyone come across a way to automate this?
Thanks so much in advance!