How to show only brand new records

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I made system which import data from CSV every a few hours.

I only want to show new data on the report, for example, Date Created 12-23-15 05:00pm, I would like to show only these records which have that "Date Created". How can I set like this?

Photo of kazuaki


  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,780 Points 50k badge 2x thumb
I suggest that you make a new table with just 1 record in it. Add one record even though there are no fields yet. It will be [Record ID#] of 1.

On your details table create a formula numeric field with a formula of 1. Call it Link to Summary.

Then create a relationship where 1 summary record has many details based in that formula field you created.

Do a summary maximum field in that relationship for the [Maximum Date Created].

If you want to be totall safe,  in the summary table create another fold called [Filter Date / Time for Last Import] with a formula of

Maximum Date Created] - minutes(1)

Then lookup that field down to the detail table and filter your report such that the Date Created] is on or after that lookup field.