HELP ME: How to insert a specific value from another table into the body of an email ?

[oemjot]

Hello. 

I have a problem. I want to include a specific name in the body of an email that comes from another table in the database. The bot turns on when there is a change in the "Validation" table, in the "Assinged to" column. it must be a name assigned to one row.  The name I want to include in the email is in another table called "Documentos PSP" in the "Titulo de PSP" column. I tried to use this formula: <<SELECT(Documentos PSP[Titulo de PSP], (Documentos PSP[ID]=Validation[ID_FORM[),TRUE)>> but it doesn't return me the value from the cell I want to retrieve. Also the "ID" column in the "Documentos PSP" table has a unique value, which is the same as "ID_FORM" in the "Validation" table. 

I think the problem in formula is here but I don't know how to fix it : 

<<SELECT(Documentos PSP[Titulo de PSP], (Documentos PSP[ID]=Validation[ID_FORM]),TRUE)>>

Please help me ! 😞

The cell which I want to insert in the email:

This name i want to put in email body

Table in which ID and ID_Form values are the same:

[Marc_Dillon · Accepted solution]

https://community.appsheet.com/t/referencing-a-column-value-in-a-table-versus-referencing-all-column...