I went ahead and tested your demo. In table #5 "Formula Columns" I turned on filtering. You have 4 fields that can be filtered on. The first two columns, Region and Type works as intended. But as soon as I enter a single digit or a comparison operator (> ,<, <=, >=) in Net Cost or Catalog Cost, all results disappear. Regardless if I'm in the Back End or Front End. I check each column's setting, and I could find no setting that would cause or modify this behavior. Can you please explain.
Unfortunately filters are not working that way. You can filter numbers by comparison operator. There are two type of filters for numbers: 1. Number filter and 2. Number range filter. You can change filter type for this column to Number range and see does it fit your needs. There you can filter column by some number range which is similar with filtering numbers by comparison operator.
Can you restrict the front end editing to data belonging only to each user?
Hi RJ,
Thank you for the inquiry.
Yes something like that is possible with Creating Editable Tables in WordPress where users can see and edit only their own data feature.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.
Thank you Milos for the quick response.
I went ahead and tested your demo. In table #5 "Formula Columns" I turned on filtering. You have 4 fields that can be filtered on. The first two columns, Region and Type works as intended. But as soon as I enter a single digit or a comparison operator (> ,<, <=, >=) in Net Cost or Catalog Cost, all results disappear. Regardless if I'm in the Back End or Front End. I check each column's setting, and I could find no setting that would cause or modify this behavior. Can you please explain.
Hi RJ,
Unfortunately filters are not working that way. You can filter numbers by comparison operator. There are two type of filters for numbers: 1. Number filter and 2. Number range filter. You can change filter type for this column to Number range and see does it fit your needs. There you can filter column by some number range which is similar with filtering numbers by comparison operator.