LOOKUP on virutal column not work. Where am I wrong?

AppSheet AppSheet Q&A
1

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)

3X_b_8_b8ee19a7f71409399ecf8323d33ba440de8157ca.png
3X_b_8_b8ee19a7f71409399ecf8323d33ba440de8157ca.png963×369 19.3 KB

but I am not displaying any data (image 2).

3X_6_b_6b84b6f6490b3a16d054fcbbe725e37bb8cd959b.png
3X_6_b_6b84b6f6490b3a16d054fcbbe725e37bb8cd959b.png384×630 63.2 KB

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

2

I don’t think you read the doc very thoroughly.

2 Likes
3

Could you please try

LOOKUP([_THISROW].[ID_CICLISTA], “T_ROSA”, “ID_CICLISTA”, “IDSQUADRA”)

3 Likes
4

Hi @Steve ,
Sorry that I did not see you had already replied, while I was typing in the reply.

1 Like
5

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.

6

@Suvrutt_Gurjar One comma too much

2 Likes
7

Hi @neardj ,

No problem. You are welcome. I suggest you please refer help articles on AppSheet functions. @Steve has shared some excellent practical examples and pitfalls to avoid therein.

2 Likes
8

Thank you @Aleksi for your keen eye as usual.

I corrected the error for any future reference of the post.

2 Likes