I have a question regarding the fields visibility in gmail.
So I have a table in Airtable with multiple fields that i have already mapped. My scenario starts when one of these fields changes and the next action is to send an email (gmail) to X person asking for an approval. Now, when I create the text message for the email to be sent (the body) and I add there different airtable fields, I see the reference/ code instead of the value of the field.
Do you know how can I get the value and not the id of the record?
So this is how I am receiving the emails from Make, it has no format whatsoever, no spaces, etc. I have tried using the html tags and are not working either.
Regarding the layout: if you use the Gmail module, you have to enter the body as HTML.
e.g. a linebreak is <br>.
=> Hola Roy,<br><br> ....etc <br>Alma
Regarding the mapping: You are mapping to array values, without specifying which value.
Don’t know how the structure is, but you could try with adding a ‘1’ between the [ ].
If this doesn’t work, can you share the output bundle you get from the Airtable module (without any sensitive data) so we can understand the field structure?
From your email results i am beliveing that you don’t have value in those columns mapped but it’s a linked record column. I guess airtable is showing clickable option of other record in those fields.
I will suggest that try to get data in those field and then try. In those mapped field you are getting record id which is clear that you don’t have data in it but record information.