Discussions

Expand all | Collapse all

Filtering Out Old Dates - Exact Form

  • 1.  Filtering Out Old Dates - Exact Form

    Posted 02-04-2019 20:32
    Some of our projects have become "long in the tooth", so my exact form which lists out the associates working on a project is becoming rather long. I would like to add a filter that would filter out all the associates who worked on a project last month or earlier and only show those who are currently working the project.
    How might I possibly set this up?


  • 2.  RE: Filtering Out Old Dates - Exact Form

    Posted 02-05-2019 16:11
    Quickbase doesn't have a native option that I am aware of for seeing which users interacted with a table over a period of time. The easiest way to implement something like this would be to have an intermediate table between an "Assocaites" table and the "Projects" table and call it something like "Active Members". You could then have the project lead add or remove records to keep track of active members of the project.

    Another option would be to create a multi-line text field with logging enabled. Then create a formula rich text field equal to "user()". Then create a form rule that says "whenever x happens, change the value in the text log field to the user field. Then problem would then be that you have a running list of users and time stamps that would take a decent script to slice apart and perform logic to remove duplicates and check date ranges. That formula would be beyond my abilities in QB unfortunately.

    Maybe Dan Diebolt or someone can pitch in here.