Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Can you share a sample??
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 .
How about creating 4 select in field actions?? each one like field 1, Search String:if(vMonth=6, 1)
yes , definitely an option , but i thought there is another way like the one i wrote about.
Am not sure if that can be done. Let's see if some expert helps us.
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)
Hi,
thanks for your reply.
but it didn't work..any other idea?
May be like attached?
Thanks Sunny!
Good enough for me
but how did you do it?