Select in Field based on possible values of another Field

[Anonymous]

Dear Community,

i need that possible values of one Field will be selected in another Field

I used therefore two Document Even Triggers "OnAnySelect" :

1) Select all possible values of Field A (MONTH_N)

2) Select in Field B (MONTH_F) all selected values of Field A (MONTH_N)  = '(' & getfieldselections(A,'|') & ')'

Its working only on select MONTH_N but it should work on any select. Example on select YEAR_N.

See example attached

I will be thankful for any help!

[maxgro]

try with

- remove select possible

- and use = '(' & concat(MONTH_N,'|') & ')'

[sunny_talwar · Accepted solution]

Although not required, wouldn't it make it somewhat efficient to use Distinct with Concat?

='(' & Concat(Distinct MONTH_N, '|') & ')'

[maxgro]

of course Sunny

and congrat, now you're Legend (25000)

[sunny_talwar]

Hahahaha thank you for making me one .

Without your and other expert's guidance, I won't have been able to achieve this.

[laacib]

Hi,

I have similar requirement.  I want get the value of field based on selection of another field value.

Could you please explain the above solution? Thanks!