Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be create "Composite Key" and use single field as Trigger
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
Hi Praveena,
had you considered using a Search Object?
Marcus
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
Hi Marcus
Yes.. The requirement is to search multiple values of each field.. So 'Search Object' has a limitation here
Regards,
Praveena
Yeah, I assumed that Praveena would have considered that.. before doing this OR may be some specific requirement
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