Skip to main content

On a dashboard interface, I have a pivot table that counts the number of times a parameter (e.g. the ticket price for the exhibition) was mentioned by visitors in their reviews and I have those counts be computed for each venue (see Attachment #1). I would like to have cells be color-coded depending on their value: shades of green for the Strengths pivot table, shades of red for the Weaknesses pivot table. Unless I'm mistaken, as yet it's not possible to get this visualization feature on Airtable. Would you have any workaround to suggest?

Similarly, I'd like to get the same formatting on the table that's displayed on the PDF report that gets generated by Documint (see attachment #2). Any other PDF-generating tool to suggest that would allow me to get this color-coding?

 

You're right that Airtable doesn't currently support native color-coding within pivot tables. However, there are a few workarounds that might help you achieve the desired visualization. 

You can export your pivot table data to Google Sheets or Excel, both of which have robust conditional formatting options. Once there, you can apply shades of green for strengths and shades of red for weaknesses.

You're right that Airtable doesn't currently support native color-coding within pivot tables. However, there are a few workarounds that might help you achieve the desired visualization. 

You can export your pivot table data to Google Sheets or Excel, both of which have robust conditional formatting options. Once there, you can apply shades of green for strengths and shades of red for weaknesses.


@thomas67, thanks for the advice. I'll look into an integration with Google Sheets.

Reply


Terms & Conditions