[Status] (Enum) is not parsing in my email templat...

weareborg · 02-17-2023 08:14 AM

Hi folks,

I have a simple email template which I am trying to get to work. I want to pull data from my table and insert it into the email. I thought this would be very simple.

The subject line is fine, as in the substitutes work. eg:

CONCATENATE("Plain Text etc ",[Dynamic Text Field], " on ",[Natural Date], " for ",[Duration]," nights") results in; Plain Text Dynamic Result on June 16th, 2023 for 2 nights

However, in the body of the email, I'm trying the same thing and it's not working at all.

For example:

Hi.
Requesting [Dynamic Information 1] re [Duration].

When I test these, they don't pull in the dynamic information. They show the text as is.

If I add the << >> the expression doesn't work at all. Big red X saying

"unable to be parsed: The given key was not present in the dictionary.."

I'm almost sure all of my fields are correct.

For example, [Duration] is an Enum and I have made another virtual column where it displays this Enum as text. Called it [Duration as Text]. That didn't work either?

Also, it doesn't allow for comma's in the body as it messes up the formula or something..

I'm sure its something really simple...

Driving me nuts..

Any advice appreciated.

Fernando_Lopez1

Please, show the body or template to better understand

weareborg

Hi Fernando:

Here is template example:
_______________

Hi there.
We are requesting [Duration] nights in [Month].

________________

[Duration] is an Enum.

[Month] is an Enum.

However, when I test this the result does not include the relevant dynamic information.

If I use this:

Hi there.
We are requesting <<[Duration]>> nights in <<[Month]>>.

I get an X saying:

Expression 'Hi there. We are requesting <<[Duration]>> nights in <<[Month]>>.' was unable to be parsed: The given key was not present in the dictionary..

so neither work. However, in a weird twist, see below. I CAN get dynamic information to appear (kind of) but I can't explain it..

thanks.

frankarv

See the variables for this @weareborg :

https://support.google.com/appsheet/answer/11539253?hl=en

The "<<>>" is like a concatenate function but only simplified

you can try this:

Plain Text etc <<[Dynamic Text Field]>> on <<[Natural Date]>> for <<[Duration]>> nights

weareborg

Hi Frankarv,

Thanks for your input.

I must be missing something obvious because thats what I've tried to do, as you say.

But, I get the following error:

Expression 'Hi there. We are requesting <<[Duration]>> nights in <<[Month]>>.' was unable to be parsed: The given key was not present in the dictionary..

weareborg

Some Progress!

Based on your link, I've made some progress..

I changed << >> to HTML << >> and this is the result.

The information is in there, finally, but surrounded by gobbledegoook!

frankarv

wuu!

don't know why the encoded characters appears though, sorry for that

weareborg

Example photo..

weareborg

Pulling this information from my data explorer...Data Explorer Selection

frankarv

That should work fine, maybe @Steve knows what is happening?

if not contact https://support.google.com/appsheet/gethelp

Steve

Please post a screenshot of the template, from the top at least down to the part that doesn't work.

Please also post a screenshot of the bot configuration that includes the template.

[Status] (Enum) is not parsing in my email template.