Select In Field

[Anonymous]

Hello,

I'm Trying to use Select In Field action -

i have 4 different fields with the value "1"

and variable vMonth (input field - 6,12,18..) .

what I'm trying to do with the action is :

Field:

if(vMonth=6, Field1,

if(vMonth=12, Field2 and so on))

Search String:

1

but its not working..

[Anonymous]

Can you share a sample??

[Anonymous]

Sorry, i cant share a sample ..

but i will try to explain it :

i have 4 fields which represents flags for every customer.

in the UI , if the user select 6 in the vMonth variable so the action will work on filed 1

and if the user selects 12 in the vMonth variable so the action will work on filed 2 and so..

work means - search the value 1 and select the relevant customers .

[Anonymous]

How about creating 4 select in field actions?? each one like field 1, Search String:if(vMonth=6, 1)

[Anonymous]

yes , definitely an option , but i thought there is another way like the one i wrote about.

[Anonymous]

Am not sure if that can be done. Let's see if some expert helps us.

[vinieme12]

Create a variable for the field as below

vfield =

if(vMonth=6, 'Field1',

if(vMonth=12, 'Field2' and so on))

And use the variable for field name

$(vfield)

[Anonymous]

Hi,

thanks for your reply.

but it didn't work..any other idea?

[sunny_talwar]

May be like attached?

[Anonymous]

Thanks Sunny!

Good enough for me

but how did you do it?