Skip to main content
Question

Time Based Access Restrictions

  • October 31, 2022
  • 0 replies
  • 55 views

Looking at trying to restrict access to a QuickBase (whether whole database or specific table) between a specific time frame.  Is this possible?  We're using the API DoQuery via another application and running into issues which may be related to the traffic/work being done within the QB at the same time even though users have been asked to stop processing.

I don't see anything at the QB level settings.  Would I need to build some sort of time validation field within a table, or a Pipeline?

------------------------------
Robin Mcintosh
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
np
 you can create a checkbox field called 
[Regular Staff OK to Edit at this Time of Day?]

with a formula of
ToTimeofDay Now() <  ToTimeOfDay("2:00 am")
or
ToTimeofDay Now() >  ToTimeOfDay("3:00 am")

In the usual Role Permissions you would add the condition [Regular Staff OK to Edit at this Time of Day?] is checked to the edit permission for regular users.

Then do your system updates between 2 and 3 am.


------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------