Filtering Out Old Dates - Exact Form

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
  • (Edited)
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?
Photo of Hans Hamm

Hans Hamm

  • 710 Points 500 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of David Brogdon

David Brogdon

  • 1,222 Points 1k badge 2x thumb
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.