Select In Feild

[maahivee]

Hello Guys,

I have a situation where if anything selected from the location code should automatically be selected in Warehouse code

the data in both the fields is same and coming from two different tables but i renamed it different because i dont want any circular loops.

but in the front end i wrote a trigger which "=if(GetSelectedCount([Warehouse Code])>0,'('&Concat(Distinct [Warehouse Code],'|')&')')"

for the location code. please help its urgent!!!!

[sunny_talwar]

I am sorry, but I am not sure hat is your question? Is the trigger not working or are you asking if it will create a loop if the two fields are named the same?

[maahivee]

I am afraid that it will create a loop if i rename one of those columns and just wrote a trigger for that feild and its not working.

[maxgro]

=if(GetSelectedCount([Warehouse Code])>0

  ,'("' & concat(DISTINCT [Warehouse Code], '"|"') & '")'

  ,''

)

[maahivee]

Hi Massimo,

I tried using this expression and its working in my case.

And if i implement it and try to make a selection it is not working and if i clear everything it is still being showed in the selection box. please help.

Also i wrote this trigger under select in field and field name is location code and expression is the one you said.

Thank you

[sunny_talwar · Accepted solution]

So you are copying over the selection made in location code to Warehouse Code right?

You will need to put a select in field trigger on the field Location code and field name you will be triggering to will be Warehouse Code and your expression will be:

=If(GetSelectedCount([Location Code]) > 0, '(' & Concat(DISTINCT [Location Code], '|') & ')' )

HTH

Best,

Sunny

[maahivee]

Thank you so much sunny, this is really helpful

[maxgro]

maybe because I wrote warehouse code instead of location code