How to filter smart drodown on multiple columns

[Erin Smith]

Hi Team (or Alex the Great), 

Hoping you can help me again.

I have a form with 3 fields: Date, Location, and Pod

The Pod field is a smart dropdown field that I need to filter based on the selections from Date and Location. The smart dropdown reference table has the same field headings.

I can get the Pod to filter by Date or by Location, but not by both.

Date:[entry.Date.Date]

Location:[entry.Location.Location]

But when I try to put them together, it doesn't understand the filter. I've tried "AND", "OR", "&", and "," between the fields and nothing works.

example

Date:[entry.Date.Date] AND Location:[entry.Location.Location]

Date:[entry.Date.Date] & Location:[entry.Location.Location]

I'm sure it's something simple I haven't thought of, so feel free to smack me on the head with the obvious solution.

Thanks.

[Alex Medved _ConfiForms_ · Accepted solution]

:-)

Using 

Date:[entry.Date.Date] AND Location:[entry.Location.Location]

Should be the correct one 

Based on https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Filters

But I am a bit unsure about your form - do you have 3 dropdowns set to use the source of the same form?

Have you considered using a smart classifier field - it does all the filtering (reducing options) for you automatically (no need for field definition rules)?  

Alex

[Erin Smith]

Hi Alex,

The Date field is a date picker in the main form. The Location field is a regular dropdown field.

In the Reference table all fields are text fields.

I tried the smart classifier field type, but it didn't show any options (didn't even show the fields on the form anymore).

I'm starting to think Confiforms doesn't like me, lol.

[Alex Medved _ConfiForms_]

Based on what I understand now your filter needs to be

Date:[entry.Date] AND Location:[entry.Location]

Alex 

[Erin Smith]

Lol, yep, something simple and obvious. 

As always, thanks so much.