Start An Email Formatting

AppSheet AppSheet Q&A
1

QQ: Is there a way to format text in an email that is generated by the ‘Start an Email’ action? For example with bold or italic text?

If not, is there a better way to generate the email that will allow me to format it in more than plain text?

This is an extract of the expression that generates the email at the moment.

“,"You had " &[CE]& " customer escalation(s).","

“,"Your customer feedback rating is "& DECIMAL([DEX]*100)"% positive.","

“,"Your main focus area to improve is " &[Focus Area]& ".","

As you can see, it’s pulling data from multiple columns and it would be nice to make it more visually impactful.

2

In the task to Send an email from an automation, you can use HTML to style the content or create a separate template with formatting.

3

Can this be done in the ‘Start an Email’ action, or does it have to be with automation?

Currently, the action is a nice system because the emails are sent after someone reviews the content, rather than automatically.

4

Sorry! I didn’t read your post closely enough. I see now you’re referencing the Start an email action, not the Send an email task.

AFAIK, there’s no way to control the formatting of body content. Have you tried including HTML markup in the body of the action–or instead using a Go to a website action with mailto instead of http? It might be worth experimenting.

5

I thought that might be the case.

Whilst I am now confident using most expressions in AppSheet, I am a complete novice in HTML, so it may be more time than I can really spare on the task for now.

Thank you!

6

In case it’s helpful, here are a couple sites where you can create your content in a WYSIWYG editor and then copy the underlying markup.

7

I have a Google Appsheet application that allows me to track my cash expenses related to the various withdrawals I make. The database behind the app has the following tables and their respective columns for each of them:

Spese [Somma Spesa, Data, Descrizione, Catogoria di Spesa, Prelievo del, Mese]
Prelievi [Data Prelievo, Data Contabile, Somma Prelevata, Note, Spese del Prelievo, Restante]
Categoria di Spesa [Tipo di Spesa, Spese per la Categoria]
Calendario [Mese, Spese del Mese, Prelevato, Speso, Restante].

I would like to Get a report in body mail like this:

Total Withdrawn: 1500
Total Spent: 1200

Withdrawals of the month:
01/01/2025: 200
Expenses of the Withdrawal:
150 Expense
50 Home
08/01/2025: 100
Expenses of the Withdrawal:
50 Sport
50 Health

Some tips? I’m struggling with the expression to use

8

Please start a new topic for help with this.