Not working need help

[Sirfyaad]

Hi appsheet teams,

Expression all correct but trigger not working please help,

{
"chat_id": -1001696529190,
"text": "<<CONCATENATE(\"*We have received a new entry in the PhotoVideo team details are given below* \")>>\n
<<CONCATENATE(\" \")>>\n
<<CONCATENATE(\"DATE : \", [DATE])>>\n
<<CONCATENATE(\"TEAM NAME : \", [TEAM NAME])>>\n
<<CONCATENATE(\"PAIR QTY : \", [PAIR QTY])>>\n
<<CONCATENATE(\"HANDOVER QTY: \", [TOTAL QTY])>>\n
<<CONCATENATE(\"HANDOVER TO : \", [HANDOVER TO])>>\n
<<CONCATENATE(\"HANDOVER DATETIMES: \", [HANDOVER DATETIME])>>\n
<<CONCATENATE(\"UPDATE BY: \", USEREMAIL())>>\n",
"parse_mode": "MarkdownV2"
}

[jballester]

I think that useremail() is a usersettings variable and this table is the only one that cannot be used with triggers.

But you can reference it,

Example:

Update a column value in a task using a value from Userssettings

[Sirfyaad]

Hi @jballester Thank for your reply.

But I want that when someone enters, his email should also be shown in the message. 

[Sirfyaad]

Need help 

[Aurelien]

Hi @Sirfyaad 

1) If I may, here is a suggestion:

a) when creating a post, the topic name should be the topic you are writing for, not "Not working need help". You can imagine anyone writing here has something not working and need help too 🙂

b) please give more context. "Expression all correct but trigger not working please help," does not provide any relevant information that help us into providing help. We all are here on a voluntary basis: without context, we can't guess what's going on, and hence we can't help you.

2) Here is an excellent post I invite you to read:

Guide on How To Create a Community Post - Google Cloud Community

3) Now, about your question which, I think, is more "how to add line break in a post request", here is my suggestion: can you replace this:

"text": "<<CONCATENATE(\"*We have received a new entry in the PhotoVideo team details are given below* \")>>\n
<<CONCATENATE(\" \")>>\n
<<CONCATENATE(\"DATE : \", [DATE])>>\n
<<CONCATENATE(\"TEAM NAME : \", [TEAM NAME])>>\n
<<CONCATENATE(\"PAIR QTY : \", [PAIR QTY])>>\n
<<CONCATENATE(\"HANDOVER QTY: \", [TOTAL QTY])>>\n
<<CONCATENATE(\"HANDOVER TO : \", [HANDOVER TO])>>\n
<<CONCATENATE(\"HANDOVER DATETIMES: \", [HANDOVER DATETIME])>>\n
<<CONCATENATE(\"UPDATE BY: \", USEREMAIL())>>\n",

with  something close to this:

"text": "<<CONCATENATE(\"*We have received a new entry in the PhotoVideo team details are given below*,
"DATE :" , [DATE] , "
"TEAM NAME :" , [TEAM NAME] , " 
"PAIR QTY :" , [PAIR QTY] , " 
"HANDOVER QTY:" , [TOTAL QTY] , "
"HANDOVER TO :" , [HANDOVER TO] , " 
"HANDOVER DATETIMES:" , [HANDOVER DATETIME] , "
"UPDATE BY:" , USEREMAIL()
)>>

4) My suggestion may be inaccurate. About using line breaks with CONCATENATE(), please read this:

Solved: Anyone knows how to insert a line-break as an - Google Cloud Community

[oscar2575]

Puedes probar con esto:

{
"chat_id": -1001696529190,
"text": "*We have received a new entry in the PhotoVideo team. Details are given below:*\n\n" &
"*DATE:* " & [DATE] & "\n" &
"*TEAM NAME:* " & [TEAM NAME] & "\n" &
"*PAIR QTY:* " & [PAIR QTY] & "\n" &
"*HANDOVER QTY:* " & [TOTAL QTY] & "\n" &
"*HANDOVER TO:* " & [HANDOVER TO] & "\n" &
"*HANDOVER DATETIMES:* " & [HANDOVER DATETIME] & "\n" &
"*UPDATE BY:* " & USEREMAIL(),
"parse_mode": "MarkdownV2"
}

[Sirfyaad]

Hi @oscar2575 Showing error