Error: Value does not exist or does not match filter criteria

When/Why does it show up?

The Salesforce default error message for an invalid filter lookup data is “Value does not exist or does not match filter criteria”. When you attempt to save a record but the lookup field does not meet the filter criteria, you will receive this error. This can happen whether you create/update the record manually, or by using the Salesforce API.

Here is an example: Your custom Lookup Filter field to an Account has a filter that requires the Account to be of a specific record type: Patient. Now attempt to create/edit a record while the account listed in your lookup field has a different record type, not Patient. This will cause the error to display.

Filter criteria

How to solve this error:

Because the error does not list the field, just the object, the first thing you need to do is to identify which field generates the error.

In Salesforce → Object Manager, view the fields of the Object that returned the error and identify all the fields with Lookup type. Check which one has a filter and review that filter.

Afterward, the next step is easy:

1. Delete the filter if it’s not needed anymore, OR:

2. Make sure that what you map in that specific field respects the filter criteria. If you are using a lookup result, the filter condition should be a part of the lookup condition too (e.g. Type = Patient).

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?