Hey to all!
There is filter.
When user selects “today”, filter selection goes to specific column in user table.
Then, I’m getting all products related to that day.
I’m using if/then/else with TRUE/FALSE for getting proper datas related to choice.
Now filter works to one user at a time.
But I want it to work with multiple users, I could do more columns with if/then/else, but every-time new employee signs, I have to add more columns.
I don’t understand from your explanation if you are using the built-in in-app filter, or if you built the filter feature yourself.
It seems you might have built your own.
If you write data to a user-specific column (the icon in the header of the column will be blue), then your filter will be user-specific.
If you write data to a non-user-specific column (the icon in the header of the column will not be blue), then your filter will be global (the same for all users).
It’s most likely this case.
However, to not use up too many updates, you can consider using an in-app filter with an array of matching options for each row.
Say a row is “today”, then it will also be “last 7 days”, “last 14 days”, “last month” etc.
Say a row is from 22 Nov then it will be “last month” but not the other things.
You might be able to create that in an If-Then-Else column, separate them by commas, and then split them into an array using the Split Text column, feed it as a filter in the collection.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.