Hello community, how are you? Today I come to ask for your help because I am trying to generate an automatic report and I cannot find where my error is.
As I told you, I am trying to generate an automatic report (PDF and email body) every time a new row is added to this table.
My problem arises when I try to embed a REF field from another table in this report. First I tried to directly insert the Ref field (using <<[REF]>>), which logically returns the correct value, but this field is the ID and I need the label. For this reason try to use the LOOKUP() expression, so that in relation to said ID it returns its corresponding label (using <<LOOKUP([REF],”REF TABLE”,”ID”,”LABEL”)>> and <<LOOKUP(“REF”,”REF TABLE”,”ID”,”LABEL”)>>).
Unfortunately the result of this when the report is generated is blank.
Does anyone know what I’m doing wrong?
Thanks!