in the app that I have created and am trying to implement I have a problem.
Inside the T_RISULTATI table I created a virtual column to have the value “team name” (TEAMID) returned in the “deck” view.
I used the LOOKUP function in the “formula” field:
LOOKUP(ID_CICLISTA, T_ROSA, ID_CICLISTA, IDSQUADRA)
where is it:
ID_CICLISTA is the reference value present in the T_RISULTATI table
T_ROSA is the table where to find the TEAMID value
ID_CICLISTA is the column of the T_ROSA table where to look for the reference value
IDSQUADRA is the value to return.
The expression assistant tells me that the formula is correct (image 1)
but I am not displaying any data (image 2).
I also followed this guide:
Where am I wrong?
I thank in advance who can help me