This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Variables not showing into email

Posted on 07-12-2023 03:03 AM
Rudja
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hello,

I am working on an application on Appsheet.
The aim of this application is to visit a location, answer some questions through the app and send an automatic summary email to someone. 

I have the tables Visit, Realisation_Visit and Observation (a list of observations related to the table Realisation_Visit). 
Visit is the parent table. Realisation_Visit is linked to his parent via VisitId column (type Ref) and the list of observations is linked to his parent Realisation_Visit via Realisation_VisitId column (type Ref). 

When a visit is validated by a user, I am updating a column on Visit table. I use this column as the trigger for the bot. (thanks to [_THISROW_BEFORE] and [_THISROW_AFTER] expressions). It is ok. 

The issue is in the template email where I am using variables. 
I am working on the Realisation_Visit table to build the template email. 
If I want to get some data from the Parent table (like <<[VisitId.ClientName]>>), it is working in the preview and not in the real email. 
If I want to get data from child table Observation (like that <<[Related T_Observations][Title]>>), the same thing, works in the preview and not the email. 

I specify that all the data are well registered in the different tables before the bot execution. 
I rode some issues about the addition of child but I'm not in this case. 

Do you have an idea of the cause of this issue, please? 

Thank you in advance. 
I can give more details if needed.

0 2 165
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Joseph_Seddik
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM

Please post your complete template. Thanks.

Posted on --/--/---- --:-- AM
Rudja
Bronze 2
Bronze 2
In response to Joseph_Seddik
Reply posted on --/--/---- --:-- AM

Sure, here is the template.
Email subject : Visite chantier - <<[VisiteId].[ClientId].[NAME]>>

Email body : 

Client project - <<[TitleProject]>> / Date and hour of visit - <<[VisiteId].[DateVisite]>>

Here is a summary of the visit :
<<Start:ORDERBY(SELECT([Related T_Observations][ObservationId], [RealisationVisiteId] = [_THISROW].[RealisationVisiteId]), [DateCreation])>>
OBSERVATION : <<[Title]>>
COMMENTAIRE : <<[Comment]>>
PHOTOS : <<[Related T_Photos][UrlImage]>>
<<End>>


The images are showing up as attachments correctly in the email.

 

0 Likes