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:
Table in which ID and ID_Form values are the same:
Solved! Go to Solution.
User | Count |
---|---|
33 | |
31 | |
30 | |
19 | |
18 |