Conditional and ID

[#1]

Hi everyone:)

I have an question.

for example:

ID  name

1 Fabian

2 andre

3 saskia

4 max

I have a variable:

vID = ID

vID2 = ID-1

vID3 = ID-2

so now, I need to select a id = for example 3 for saskia but I like also a textbox with the variable vID2...

my solution but it's not working:

if(ID = $(vID2), name)

it's not working ... what now?

[alex_millan]

Guess you want to select an ID and have the name for the ID-1 shown in a textbox?

If so, try to put the expression in the textbox:

=Only({<ID = {$(vID2)}>}name)

So you can reference the name to the ID corresponding to the variable vID2

Hope that helps

Regards

[sunny_talwar · Accepted solution]

Minor correction in the expression:

=Only({<ID = {$(vID2)}>}name)

[alex_millan]

Thanks Sunny!!! I really missed it. Edit in my previous post.

[sunny_talwar]

Awesome

[#6]

THANK YOU