nested if

[srujanaponnuru]

hi,

i have a search box containing application name and technology.

when i expand application name in the search box, i should get that application name in that text box and when i click the technology , technology name should appear in the text box

i wrote the expression as

=if(Len(GetFieldSelections([Application name])) or len(GetFiledSelections(Technology)), Concat(distinct[application name], ','), 'Search for application or technology)

this isworking only for application name, but not technology..when i click on technology it is showing application name. please suggest.

i guess we have to use nested if's but unable to write the code.

[Anonymous · Accepted solution]

maybe like this

=if(Len(GetFieldSelections([Application name])), Concat(distinct[application name], ','),  if (len(GetFiledSelections(Technology)),Technology)

check the brackets, I did not Count them

if you have only two states you may skip the second if

=if(Len(GetFieldSelections([Application name])), Concat(distinct[application name], ','), Technology)

maybe you Need to concat Technology as well

[Digvijay_Singh]

something like this -

=if(

  Len(GetFieldSelections([Application name])),

  Concat(distinct [application name], ','),

  if(Len(GetFieldSelections([Technology])),

  Concat(Technology],','), 'Search for application or technology'))