I am having trouble getting a filter on an input field to work.
There is an input field called ‘Team’ on a form that allows the user to choose a record from the Teams table. The Teams table has a yes/no field called “Active” that is used to designate a team as either active or inactive.
On the form input field I created a filter for “Active is Yes”. Since the help on the filter section says “Filter which records are available to choose.” this sounded like the right way to restrict the user to selecting only active teams.
The problem is that the app ignores the filter. Inactive teams are still available in the drop down list to choose. I tried changing the “Active” field to a multiple choice field but it didn’t help.
Does anyone have an idea why this might be happening and how to fix it?
Update: I changed the yes/no field from ‘checkbox’ to ‘Drop-down’ and it started working. I changed it back to a checkbox and it continued to work. Must have just been a glitch. Sorry to waste your time!
Check if the filter is targeting a connection field or a formula. Sometimes Knack has trouble with input filters on complex connections unless the data is specifically ‘loaded’ in that view.
I’ve had cases where just re-adding the filter from scratch fixed a weird glitch like this. Are you seeing this on a standard table or is it part of a more custom search page?
Hey @Sophie , It’s working now but to answer your question the filter is targeting a connection field (Team) and is filtering out Team records where the yes/no field “Active” on the Team record is set to “no”. There is nothing especially complicated about this setup as far as I can tell.
I’m just going to keep an eye on it and make sure that it keeps working as expected.