Skip to main content
Question

Report Formulas

  • March 6, 2020
  • 0 replies
  • 57 views
Forum|alt.badge.img+9
I'm looking to create a report formula for a report. We use this report to follow up on support tickets. For example, a Priority 1 call should be repaired in under 3 hours, so I need the report to show only calls that have not been created or modified within the last 3 hours, that way we can call the location or technician.

I know how to do this on a daily basis using report filters, but I really need this 3 hour mark so that I can send the list out to my employees.

------------------------------
Katlyn Allen
------------------------------
This topic has been closed for replies.

  • AustinK
  • Quickbase Alumni
  • March 6, 2020
Create the report formula and once it is created it will be at the bottom of your field list in the regular report filters and you can then use it there. You just need to filter it based on your formula checkbox being equal to 1.

You want to go with a formula checkbox and filter your report based on this being checked to show those records. I am fairly sure this formula would work for you but let me know how it goes. It will show them once the duration of hours between the submission or the date modified is over 3. Hopefully I understood your request but let me know if I did not.

if(
toHours(Now() - [Date Created]) > 3 or toHours(Now() - [Date Modified]) > 3, True, False
)
Terms & ConditionsAccessibility statement