Reply to comment
You can use formulas to create fields that are calculated based on other fields or the time of day. There are a variety of built-in functions that can be used in formulas.
For information on how to use formulas in QuickBase, see "Using Formulas in Quickbase" at https://www.quickbase.com/help/using_formulas_in_QuickBase.html.
For detailed information about the built-in functions, refer to the Formula Functions database at https://www.quickbase.com/db/6ewwzuuj?act=q&qid=6.