Hi,
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:
https://help.appsheet.com/en/articles/2357309-lookup
Where am I wrong?
I thank in advance who can help me
Luigi
Solved! Go to Solution.
Could you please try
LOOKUP([_THISROW].[ID_CICLISTA], “T_ROSA”, “ID_CICLISTA”, “IDSQUADRA”)
I don’t think you read the doc very thoroughly.
Hi @Steve ,
Sorry that I did not see you had already replied, while I was typing in the reply.
Could you please try
LOOKUP([_THISROW].[ID_CICLISTA], “T_ROSA”, “ID_CICLISTA”, “IDSQUADRA”)
Thank you I have solved.
I had done a similar test like this:
LOOKUP(THISROW.ID_CICLISTA, T_ROSA, ID_CICLISTA, IDSQUADRA)
But I was wrong in parentheses.
Excuse me but very little experience in programming.
@Suvrutt_Gurjar One comma too much
Thank you @Aleksi for your keen eye as usual.
I corrected the error for any future reference of the post.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |