Forum Discussion

Re: Reset Value every day?

OK. So what is in the reference field on the tickets table.  Is there data populated there?  Are you using a formula?  What is the formula?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------

4 Replies

  • PaulPeterson1's avatar
    PaulPeterson1
    Qrew Assistant Captain
    The reference is currently the default, Related Day and there is no data being populated in the Schedules table.

    ------------------------------
    Paul Peterson
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      OK, so you need to "get" relationships. 

      If you run a report of that reference field for [Related Date]  it will be blank if it's just a data entry field because no one has populated it.  So you need to populate it by using a formula or by defaulting it Today in the field settings and then updating all existing records to the date of the record using say grid edit.  

      I don't know how many existing records you have to know if grid edit is practical.

      Do you have a ticket date field, or do you just have the native [Date Created] date / time field.

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      [email protected]
      ------------------------------
      • PaulPeterson1's avatar
        PaulPeterson1
        Qrew Assistant Captain
        Did you receive the email I sent this morning?

        ------------------------------
        Paul Peterson
        ------------------------------