Any Idea how to implement a "Filter as" setting for a multi-select dropdown or multi-select checkbox?
So the save form has options eg:
option1
option2
option3
option4
They select multiple for this option, eg option1+option3 and save to database.
Then on the list page there is a "Filter As" with 1,2,3,4 which will display any options they have ticked. So they could tick option1 and it will filter or option3 and this will filter.
Thanks for any ideas.
add another field and assign as say ex.... fieldgroup ( If needed add a default $_SESSION["fieldgroup"] for permissions or for values / on before process add/edit ) and use this field as a main option to your other 4 options . Then filter your options field as a subcategory of fieldgroup field and check filter as database value options field . So if they select one of your main fieldgroup options it will be a multiple sbucategory of say option1 and option3 .
If you can't use fieldgroups as another field then you can send the page to advanced search first before list page with hide search on misc tab and select hide data until searched and give the user options before list page is displayed. ( option1, Option3 , ( both , all , group , options , empty , and so on ) before processing list page.
