Daily Census from Admit Date / Discharge Date

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
I have a table with individual customers that are housed in one of our facilities.  Updates to these records occur every hour.  I can create a Summary Table where Admit Date is less than or equal to today and Discharge Date is greater than or equal to today.  This gives me a count of total customers on any given day that I run the Summary Table for.  I can then select .more. and copy the summary report to another table.  Is there a better way to accomplish this?  Is there an automated way to do this?  Is there a way to keep prior days up to date as discharge date may be back dated and cause issues moving forward.
Photo of Casey Whiteley

Casey Whiteley

  • 70 Points

Posted 3 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,346 Points 50k badge 2x thumb
I suggest exploring the use of a scheduled Automation.