Docs & Support

Learn about all the Formidable features and get support from our amazing customer success team.

frm_set_comparison_type_for_lookup

Heads up!
This article contains PHP code and is intended for developers. We offer this code as a courtesy, but don't provide support for code customizations or 3rd party development.

This hook can be used to change the comparison operator for Lookup fields. By default, Lookup fields only retrieve values that are exactly equal to the selected/entered value.

Usage

add_filter('frm_set_comparison_type_for_lookup', 'my_custom_comparison_for_lookups', 10, 3);

Formidable Forms makes advanced site building simple. Launch forms, directories, dashboards, and custom WordPress apps faster than ever before.

Parameters

  • $comparison (string)
  • $parent_field (object)
  • $child_field (object)

Examples

Change to like

Use the code below to change from the default equals comparison to the SQL LIKE operator for Lookup field data retrieval. The SQL LIKE operator checks if a value contains another value. Just change 123 to the ID of the Lookup field that you would like to use a like comparison for.

add_filter( 'frm_set_comparison_type_for_lookup', 'customize_lookup_value_retrieval', 10, 3);
function customize_lookup_value_retrieval( $type, $parent_field, $child_field ) {
        if ( $parent_field->id == 123 ) {
            $type = 'like';
        }
	return $type;
}
Was this article helpful? *

This article may contain affiliate links. Once in a while, we earn commissions from those links. But we only recommend products we like, with or without commissions.

In this article

    We have a small, but amazing team of dedicated people who are committed to helping you achieve your goals and project requirements.


    Copyright © 2025 Strategy11, LLC. Formidable Forms® is a registered trademark Strategy11, LLC.

    Complete your purchase
    Special offer unlocked.
    Get 55% OFF!
    Complete Purchase
    Join 400,000+ using Formidable Forms to create form-focused solutions fast. Get Formidable Forms