Single select in field trigger for multiple fields

[Anonymous]

Hi All

I have a requirement as below.

Fields:

[Customer ID]

[Customer Num]

[Phone Number]

...., ... etc

I have an input box with variable which takes the search value from the user. Can I create a single variable event trigger to select in all the above fields instead of creating N number of 'Select in Field' trigger to search for the string entered by the user

Any suggestions will be much appeciated

Thanks in advance

Regards,

PM

[Anil_Babu_Samineni]

May be create "Composite Key" and use single field as Trigger

[kamal_sanguri]

Nothing much you would need to do. Just add more actions and change the column name (Keep the variable same).

How will it work - so, If user enter something which is there in Col1 it would be selected and if user inputs any value which is not Col1. First trigger action will fail and Second action will happen.

See the snippet

Refer the attached for reference

[marcus_malinow]

Hi Praveena,

had you considered using a Search Object?

Marcus

[Anonymous]

Hi Kamal

Thank you for your response

I have 34 fields and do you think we need to add 34 'Select in Field' actions in the trigger.

Do you think we have a better solution for this

Regards,

PM

[Anonymous]

Hi Marcus

Yes.. The requirement is to search multiple values of each field.. So 'Search Object' has a limitation here

Regards,

Praveena

[kamal_sanguri]

Yeah, I assumed that Praveena would have considered that.. before doing this  OR may be some specific requirement

[marcus_malinow]

Hi Praveena,

ok fair point. A search object will allow you to search across your 34 fields, but the selection will be made in a single field.

Kamal's solution seems to be the way to go given the requirements you've stated - and yes you'd need to add 34 actions!

I would suggest that some simplification of your data model might pay off here. If you upload a copy of it I'm sure people can help.

Marcus