Dynamic per user filter from and to column or virtual column

[jonbowles84]

Hi Guys,

I have a timesheet app and want to be able have a slice that filters by a [FilterFrom] and  [FilterTo] column that are unique to the user, (As in "user A" filter is not affected by the filter applied by "user B"). 
Does that make sense?
I can make the slice easy enough with actual columns that only display the users data, but how can I have the filter columns unique to the user?
Thanks...

[Suvrutt_Gurjar]

You could explore one of the following

1) You  could create a Users table, with one row per user to store the filter data of each user. 

2)You could user user settings option if the user is not going to filter the data very often. User settings require a full sync before their effect takes place. 

3)If the slice requirement is just for viewing the data in the app in a view, you could possibly explore the filter within search options

[jonbowles84]

Ahhh, thanks... I already have option 1 with a "Staff" table, Ill just add it to there, of course! thanks!