I'm having a problem with the database filter. I created a form with Forminator and linked it to the table, and so far everything works correctly and you enter the data in the table through the form. The problem is that if I go to activate the data filtering, and in the form I used a drop-down menu with multiple selection instead of a single one, inside the selection filter instead of appearing to me for example each category all separate, they appear to me of each combination possible because the categories are multiple selection.
I give an example.
In the form there are 3 categories of freelencers: - Cyber Security - Telecomunication - Web Development
The point is that a freelencer in addition to knowing how to do Cyber Security, also knows how to do Web Development and therefore after filling out the form with multiple categories then select "Cyber Security and Web Development" and send the data to the table, when I go to filter in the table through the drop-down menu I appear:
- Cyber Security - Web Development -Cyber Security, Web Development
When, on the other hand, I want the filter to have only the between categories I have chosen, not also the combinations because some freelencers have selected more than one
You can add individual entries as defined values from the column's settings - Data - Possible values for column. Please make sure exact filtering is turned off.
I hope this helps, do let us know if you need any further assistance.
I'm having a problem with the database filter. I created a form with Forminator and linked it to the table, and so far everything works correctly and you enter the data in the table through the form. The problem is that if I go to activate the data filtering, and in the form I used a drop-down menu with multiple selection instead of a single one, inside the selection filter instead of appearing to me for example each category all separate, they appear to me of each combination possible because the categories are multiple selection.
I give an example.
In the form there are 3 categories of freelencers:
- Cyber Security
- Telecomunication
- Web Development
The point is that a freelencer in addition to knowing how to do Cyber Security, also knows how to do Web Development and therefore after filling out the form with multiple categories then select "Cyber Security and Web Development" and send the data to the table, when I go to filter in the table through the drop-down menu I appear:
- Cyber Security
- Web Development
-Cyber Security, Web Development
When, on the other hand, I want the filter to have only the between categories I have chosen, not also the combinations because some freelencers have selected more than one
Hi Emanuele
Thank you for reaching out to us.
You can add individual entries as defined values from the column's settings - Data - Possible values for column. Please make sure exact filtering is turned off.
I hope this helps, do let us know if you need any further assistance.