If condition, front end, error system, getselect function

[Billy_u]

good morning to all of you,

I'm processing an if condition in front end, like this:

=if(getselectedcount(Data_calendar)=1 and (DATE_START <= getfieldselections (Data_calendar) and DATE_END> = getfieldselections (Data_calendar), ID_1, ID_1)

but it's giving me a problem that I don't understand, the connection drops, or can't find the sheet anymore, what happens what can it be?

thx for suggestions

Billy

[MayilVahanan]

Hi @Billy_u 

Both true & false statement contains same field (ID_1),

in that case, I think, its not required to use if Condition itself. 

Can you explain with sample