Workflows for Contact fields with Multiple Entries

Guaca Mohle

I have created a web form that dumps info into a sheet on which I have a workflow established to send a notification to whomever is listed in certain columns (e.g. Account Owner).

The web form asks a submitter to enter the email address for Account Owner. This is a Contact column but there are so many in the company, I have not pre-defined values that could appear in a drop-down list.

Some users are submitting several email addresses for this field via the form delimited by a comma.

Is the workflow rule intelligent enough to parse this delimited series and send a notification to each address submitted?

MCorbin

It would depend on how your column is set up.

Do you have it set to "Allow multiple contacts per cell"?

If so, email addresses saved with a comma separating them will be saved as separate contacts, and can be used in workflow automation.

MCorbin

It would depend on how your column is set up.

Do you have it set to "Allow multiple contacts per cell"?

If so, email addresses saved with a comma separating them will be saved as separate contacts, and can be used in workflow automation.

Mark Cronk

Hi @Guaca Mohle ,

Try setting the properties of your Account Owner column to allow multiple contacts per cell. Then format the column to wrap text. Work?

On your form, you might prompt people to enter multiple emails with a comma between them.

Mark

Guaca Mohle

Thanks @Mark Cronk This helped. I've made the column multi-contact possible.

Bassam Khalil

Awesome @Mark Cronk