I have created a Gantt View to represent a schedule of Audits. Currently completing one Audit per month.
Despite my newness on Airtable I seem to have something that looks like a planner, and what i would like to do next is create some information for managers to quickly appreciate the planner, e.g. a dashboard or App.
#1 So in my picture you see I have a Today Line, and you can see the next Audit is in Jan22 Management Systems Manual, so is it possible to have some Dashboard style indicators, e.g.
Next Audit “24” days
Audit “Management Systems Manual”
#2 Further to this what would also be nice is if I click on the coloured box on the Schedule
and I could access some more information, maybe who the Auditor will be and what type of Audit will be conducted.
Hope that makes sense, I am used to Excel but as my company is cloud based and wants better deployability amongst remote users, wants to develop tools in Airtable.
You could use the Summary app if you’re using Dashboards, or the Number element if you’re using Interfaces, to show the minimum value of a formula field that relates the number of days until a record’s date field if that date has not yet elapsed (in other words, the next occurrence). Such a formula could be:
If you click a record on the timeline view it should already produce a popup of information from that record. Control which fields are shown using the “Customize labels” button at the top of the screen. EDIT: just realized you’re using Gantt instead of Timeline. Consider using the Timeline view instead to enable that functionality
So far so good, thanks for your help.
Looks pretty respectable, considering it was in EXCEL and we have moved over to Airtable recently.
One last question if you stick with me :-)… The Gantt is a schedule that repeats every 12months (52wks), and would be nice to show the repeat Audit on the same line in the Gantt. I added the ‘next’ audit as its own record entry, but this puts it at the bottom of that group.