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 production details and we then compile in the database and provide slate reports whilst also offering a transmission calendar.
However, I'm not that up to scratch with formulas so wondered if anyone could help me with these tasks.
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.
Task 2 - Create a report formula which lists all of the records where a specific field has been updated and create a report with basic record detail and then provide that record detail next to the specific field which has been changed with the detail in that field.
Task 3 - I have a Notes On Progress field set with Log the edits to this field, and show them on forms option turned on am using the formula Trim(Left(NotLeft([Notes],"]"),"[")) in another field to trim off all the other tracked notes when running reports, but I need a formula which if there are no other updated or edited notes, it shows the original note OR the updated note. Can someone help?
Any help greatly appreciated.
Thanks, Adam
Task 2 - Create a report formula which lists all of the records where a specific field has been updated and create a report with basic record detail and then provide that record detail next to the specific field which has been changed with the detail in that field.
Task 3 - I have a Notes On Progress field set with Log the edits to this field, and show them on forms option turned on am using the formula Trim(Left(NotLeft([Notes],"]"),"[")) in another field to trim off all the other tracked notes when running reports, but I need a formula which if there are no other updated or edited notes, it shows the original note OR the updated note. Can someone help?
Any help greatly appreciated.
Thanks, Adam
------------------------------
Adam Hollman
Exec Director, IP Management,
Warner Bros.Int.TV Production.
------------------------------
