I have a table containing info on contacts. My goal is a list of e-mail adresses from that table.
The wanted e-mail adresses will typically be a subset from the main table. Here are among other things two fields saying something about every contact and these fields are the type "Multiple select".
I would like to make a formular by which one can decide the wanted subset of e-mail adresses and then get them as a kind of list to be easily inserted in the to-field in a mailproram. The choise should be made with the mutiple select-fields.
Does anybody have ideas on how to do that? Any hint will be deeply appreciated!
If I were you I'd attempt to do this via a conditional automation
I'd have a checkbox field that I'd use to trigger the automation, and when that checkbox field is marked the automation would, based on the value in the multiple select fields, look for the appropriate emails in the other table via a Find Record action
It would then update a field in the triggering record with the results