Format of the automated email for approbation

LyndaRousseau

Hi there !! :)

I have created a sheet with 2 forms attached to it. I added some HEADINGS in my forms to regroup the information so that it makes it easier to read.

Now, I'm adding some automation for approbation. Is there a way that the email received for approbation be in the same format then the original form ? It's not easy to read, no headings… And also get JUST the fields that were filled ? I already selected just some fields, but I don't want them for approbation if they are empty.

Thanks a lot !!!

Lynda

(Sorry for my english ! My native language is french ! :P)

KPH

Rather than using the list of fields to include, you can manually write the email and reference them using placeholders. That way you can include the headings.

Your email message could be

Heading 1

Submitter Name: {{name}}

This placeholder will put the data from the column called “name”.

You can then not select to include any fields.

However, the headings and labels will still appear if the field is blank. You could use conditions in the automation to send different messages based on what fields were complete.

LyndaRousseau

@KPH Thanks ! But I don't quite understand what you mean… Have an example ? Print screens ?

Thanks a lot !!

KPH

If the sheet has fields like this:

You can use the field names to build your own email body like this (choose message only rather than all/specific fields):

The message received will look like this: