I’m absolutely new to Airtable and I have no idea what to start with. Tried looking up at YouTube guides and Airtable guides but couldn’t find a solution.
I’m working as a Frontend Trainee and my manager is asking me to do a certain task with Airtable (I have no idea why), and here I am asking you to share your experience with me.
So I will add screenshots to make it clear what my task is about.
In table “Raw Data” I have some data with 2 shops K12 and K59 and formulas on percent done to goal.
And then there is a Summary Bar at the bottom of sheet which has an option of displaying an average of selected field
First question would be how do I stream/broadcast Summary Bar’s Avg to another rows/table?
From what I know by reading guides it is not really possible.
If that’s correct, is there a workaround to display average of “K12 Percent” field (and later “K59 Percent”’) fields in a selected row?
Selected row might be in another table like so (but thats not necessary)
Next if lets say K12 KPI percentage goes <50% then solution(s) appear.
Currently solutions are in Resolving table (this can be in the same table that’s also not necessary).
So if Overall % Avg field goes below 50% then Solution field gets a record from Name records in Resolving table for example “Hire more people”.
I understand this might be not really well explained, but any opinion on this solution is welcome and sorry for such a long post!