AnsweredAssumed Answered

Filtered Value List or Omit Duplicates

Question asked by shona1 on Dec 3, 2014
Latest reply on Dec 4, 2014 by philmodjunk

Title

Filtered Value List or Omit Duplicates

Post

I am working on a Staff roster Database and am wanting to show a list with the "shift date" from the Table:Shifts that is sorted in Descending order and only shows the last 2 months. I have it as a drop down value list using values from field: Shifts::Date, but this is naturally sorted in Ascending order and will end up showing a lot of old shift dates. Is there anyway to evoke the Specify Calculation Box here?

My other thought was to have it as Popover button with a Portal in and a TO relationship Shifts and Shifts2, with this I have the portal sorting and can filter the last 60 days, but I don't know how to filter the duplicates, as many shifts in a week have the "same date".

Can you help me with either one of these options? Thanks in advance.

 

 

Outcomes