Formidable Forms Community Site

The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group

Slack Signup
Newsletter Optin
Help Desk
Subscribe

Cascading Forms

Labels

This Discussion is public

Notifications

I am building a form using cascading lookup fields.

It is designed to be able to find which car dealers sell certain brands in each state. Some dealers sell multiple brands.

Example:

Take 2 dealers entered into the data form.

DATA FORM ENTRIES

Dealer 1 (Single Brand Dealer)

  • Business Name: Fairmont KIA
  • State: SUTTON
  • Brands Sold: KIA (Checkbox Field - Over 40 choices)

Dealer 2 (Multi Brand Dealer)

  • Business Name: Fairview Dealer Group
  • State: SUTTON
  • Brands Sold: MAZDA, HYUNDAI, KIA (Checkbox Field - Over 40 choices)

Lookup fields are as follows:

STATE

  • (Get Data from DATA FORM)

BRANDS SOLD

  • (Get Data from DATA FORM)
  • (Watch STATE)

BUSINESS NAME

  • (Get Data from DATA FORM)
  • (Watch STATE)
  • (Watch BRANDS SOLD)

Dealer 2 - Fairview Dealer Group, has the KIA box checked, however does not show up in the BUSINESS NAME lookup field.

Dealer 2, is not shown due to multiple boxes checked.

How can I get the lookup to recognize ANY dealer that has KIA checked, even if other brands are checked?

 

I would start reading here and go through all of the subsequent subsections.

https://formidableforms.com/knowledgebase/lookup/#kb-set-up-cascading-fields

Thanks Bobby,

I have read that documentation, however it does not explain how to make results show where multiple checkboxes have been ticked.

Would you be able to send me the export of the form to test? Either attach it here or send to my email.

Discussion closed.