Forum Discussion

AdamHollman's avatar
AdamHollman
Qrew Trainee
6 years ago

Intro & Queries - Warner Bros. International TV Production

Hello everyone. We have recently signed up with Quickbase to offer the platform as a online production tool for our 15+ production companies around the world. All our producers enter in all product...
App builders
Formulas and functions
reports and charts
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Adam,
Can you post these two questions below as separate questions on this forum and for each try to better explain them with an example?    I'd like to help but not able to understand either one.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
AdamHollman's avatar
AdamHollman
Qrew Trainee
6 years ago
HI Mark
Thankyou for spending the time to read and try and work out my quandry...


TASK 1

Creating a New/Update field which will show the status NEW with green background when a new record is created in the past 30 days from report creation.

OR show the status UPDATE with orange background when a new record is updated in the past 30 days from date of access. These will show in a new field which will then be able to print on the reports. The flags do not.

So I need a formula so that a column returns a status of NEW or UPDATED if the Record Created field is 30 days old or if the Record Modified field is 30 days old (to show UPDATED)

Thanks to @Everett Patterson above I know how to create a colour field but I don't know the formula to create the NEW or UPDATED marker.

Thanks Adam​

------------------------------
Adam Hollman
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    if you are referring to those tags at the left side of the record on a report for new and updated, they cannot be manually set by any formula or API.  They are also a bit mysterious as to what causes a record to be considered new or updated for any user - note that these flags are user dependent as if a user comes into an app after being away from it for a month there will be many records flagged as new - for them.

    So, either forget about trying to control them or just disable that feature for the app or else make your own fields if you field you know what definition you want for new and updated.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    • AdamHollman's avatar
      AdamHollman
      Qrew Trainee
      6 years ago
      I think I've still go the idea in my head of a formula which runs from the standard Date Created and Date Modified fields. So:

      If Date Created is less than 30 days old show 'NEW' or If Date Modified is less than 30 days old show 'UPDATED' and if neither, keep blank.

      And then work on another field to create a formula based on that field with colours etc.

      ------------------------------
      Adam Hollman
      ------------------------------