Select in Field - Multiple Values Question

[#1]

When using a 'Select in field' trigger, if 1 or more values are selected in Field1 the desire is for Field2 to have the exact same selections everytime, how can this be done?  (I just need field2 to always = field1)

If just use =Field1 as the Search String it works fine with 1 value, but isn't working when 2 or more values in Field1 are selected.  

Thanks very much!

Richard

[shree909]

Hi when u want to use multiple field values u have to concatenate and add them

for example if u have field values as fieldvalue1, fieldvalue 2....

then in select in field use  'fieldvalue1' |'fieldvalue2' if have spaces between the fieldvalues use ? like fieldvalue 2  , can be written as field?2?...

[#3]

Not sure I follow, maybe a simple example will help me.  If I have the following to fields with data:

Name1          Name2

Bob               Bob

John              John

Fred               Fred

Etc....             Etc...

Currently I have Field Event Triggers on Name1, for all actions, the field Name2 set to Search String =Name1.

So if someone picks Bob in Name1, Bob will successfully also be selected in Name2.

However if someone picks Bob and Fred in Name1, then ALL the names stay selected in Name2.   My need is to have only Bob and Fred also be select in Name2 to match what was select in Name1.

Hope this makes sense and THANK YOU VERY MUCH!

[shree909]

i think u can use getfield selection(Name1) on first trigger andgetfield selection(nName 2) on second trigger

may be this can help you.. try this

[#5]

I created a sample app (couldn't figure out how to upload it here or i would have) using getfieldselections on the trigger but still only works when 1 name is selected in name1value.   If more then 1 is selected, then nothing is selected in name2value.  Seems like this should be simple, what am i doing wrong? 

[Gysbert_Wassenaar]

You can upload files in the advanced editor. Click on Use advanced editor when you create or edit a post.

[#7]

Thanks.  I saw that post.   I am trying to avoid making it any more complex but maybe concat is the only answer.  Although in that post the problem was really never completely solved so not even sure that concat is the answer.

[#8]

Oh brother, i tried this and was looking above where the insert pictures etc. were, didn't look below!   Well attached is the file, maybe this will make it easier!

Thanks much!!

[Gysbert_Wassenaar · Accepted solution]

It's quite simple. See attached file. Just a simple concat expression instead of the getfieldselection

[#10]

Perfect, thanks!