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!
Solved! Go to Solution.
Have you tried the following:
<<[REF].[Label]>>
It woks !
Thanks!!!!!
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |