Using the "Like" Operator in the Salesforce Connector 


In this Article
Related Articles

Using the Like Operator

If you would like to use the "Like" operator in your Salesforce Connector to find similar or closely matched records to what a user has submitted in a form, you can do so. However, if the LIKE operator is not functioning as needed for your particular use case (i.e. it's not finding the records you want it to) you might need to make a slight configuration change

In general, the "Like" operator will work best when used in conjunction with a "Formula or Text" field and when that formula is equal to a field alias from your form. Additionally, you will need to add 1 or 2 extra percent signs around your field alias in order for the LIKE operator to function more like a wildcard lookup.

For example, if a user enters "12345" into tfa_1 in your form, then you could use the LIKE operator with extra percent signs to find the following returns (abc = any surrounding alphanumeric text)

  • %%%tfa_1%% = abc12345
  • %%tfa_1%%% = 12345abc
  • %%%tfa_1%%% = abc12345abc

​You can also use %{!tfa_1}% in order to find any fields that contain the value you're looking for, regardless of it being an exact match or not.

Terms of Service · Privacy Policy