[AppExchange – 123FormBuilder] Lookup fields

By using a lookup field, you can search specific information within a Salesforce object and return the content of a field, a record ID, or an account ID in another object. Let’s say these two objects are Account and Lead.

Part 1 – Creating the Lookup

1. First, go to the Lookup section on the left menu and click Create lookup.

Create lookup

2. Afterward, select the Salesforce object where the search should be made to find a record. In this case, the object will be Lead.

Select object

3. Give a name to your lookup. You might create more than one.

4. The lookup is based on an entry made on the form. So at this point, you have to add a filter and select the form field that will contain the word the search will be made by in Lead.

5. Select an operator.

Select operator

6. Find the form field entry in a specific Salesforce field.

7. You can add multiple filters by clicking on Add new filter. By default, between the two filters, the AND logic operator is chosen, but you can change it to OR.

Note: currently the AND/OR logic operators are exclusive -> if AND operator is chosen, all the logic operators between the filters are set to AND. If you change one logic operator to OR, all of them will be changed to OR automatically. We are currently working on bringing improvements to this area by allowing you to set up multiple filters with AND and OR logic operators combined.

Multiple filters

7. Select the field that you want to return in the other object (in this example, Account). You can return multiple fields at once.

8. Lastly, save the settings by selecting the Apply Changes button.

Part 2 – Object Mapping

1. Go to the Object Mapping section and select the object where the field from Leads will be returned, in this case, Account.

2. Select the Salesforce field where the data should be returned and match it with the lookup object you created.

Object mapping lookup result

2 comments

  1. When you add two different conditions, this stops working. For example, I want to prefill my form with a list of accounts that are either of the type “A” OR type “B”. As soon as you add in the second value, it stops working as a prefill and the field just shows as a blue color. How do you add two conditions and have the prefill still work?

Leave a Reply

Your email address will not be published. Required fields are marked *

Frequently Asked Questions

Here is a list of the most frequently asked questions. For more FAQs, please browse through the  FAQs page.

Is this service free?
Yes, we offer a free form builder service. Just sign up to the Basic plan and you are all set. This plan is forever free, but you are limited with a few features only, such as 5 forms per account, 100 submissions per month and you have to keep the backlink to 123FormBuilder on your forms. Check out our features matrix for more information.
How many forms can I create?
It depends on the service plan you are on. Higher service plans enable more features, including more web forms for your account. If you need more forms, go to the My Account section of your account and click the upgrade button. To create an unlimited number of forms, either upgrade to the Platinum service plan or higher. Consult our features matrix for more information.
How can I publish my forms?
You can publish your forms in many ways, by using their direct URL or HTML link, embedding them with a JavaScript code, Inline HTML or iFrame, using the Facebook app or the WordPress plugin, using popups, the Blogger code snippet and many more. Once you have created and customized your form, go to the Publish section to complete your work. Read more in our documentation.
How do I change my form design?
You can change the design of your form for more information. in the Themes section, which is located in your form settings. We offer a set of more than 30 predefined form themes for your forms, but you can also create your own from scratch. You can customize the submit button, the logo and more. To apply your own stylesheets, all forms come with a custom CSS editor.

Can't find what you're looking for?