Hoping for an added feature to control the colors of a chart block.
Please correct me if I missed a feature in anything I say below !
So far, the only way I found to control the colors of a chart block is to group based on a single-select field. Unfortunately, the colors of single-select options are :
- limited by the AirTable UI available colors
- limited to manual changes (I can’t find a way to change them through formulas or API calls)
My use case : as I explained here, I have various correlated charts plotting data from a “Sessions” table, and I group them by customer (link to the “Customers” table). I need consistent colors to analyze these at a glance.
Possible implementations that would work for me :
- Basic feature enabling workarounds : Allow control of Single-select option colors through formulas, through the API, or any other way…
- Maybe too narrow : Blocks > Chart > ‘Group by’ field > Add a ‘Custom color’ choice which could be based on table relations. In my case, expecting ‘Group by’>“Customer” link field and ‘Custom Color’>“CustomerColor” chosen in the customers table. [Eventually, implementing a ‘Color’ field type at the same time] (New Field: Color 🌈) would be the icing on the cake ! 🙂
My best solution at the moment : I use a Node.js bot (built for various third-party syncs) to sync the “Customer” link value of a “Sessions” record into a Single-select field of the same record which holds the manually input color of that customer. Really not practical at all 😅
I’d be pleased to read anything related to my needs if someone manages to understand the mess I just wrote :thinking:
