I’m trying to search a SugarCRM field to get it to return a record. The SugarCRM field in question is a text field that can contain up to three item numbers separated by a comma. My trigger data only ever has one item number. If the record only has one item number then the search works, but as soon as it is not an exact match it fails. If I manually do a search in sugar I can change the parameters to “contains” and it returns the expected results. The Zapier->SugarCRM search doesn’t give me options and appears to only perform an exact match search. I’ve tried a couple of different ways to amend the search by entering the sugar Boolean % and {{Contains(XXXDATAXXX)}} and neither work. Is there a way to enter code in the search to force it into a contains command?
Best answer by Troy Tessalone
View original
