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 would typically setup the automation to dump all the necessary Airtable data onto its own tab in Google Sheets, and then on another tab in Google Sheets, you would have the pivot table that automatically generates itself from the dumped data. You would also set the conditional formatting there as well.
Below is a screenshot of a very simple way to set this up in Make, but this is just a very simple example of how you could do this in Make.
Most of my Make scenarios are significantly more complex than this, but this would be a good starting point for you.
This scenario creates the new spreadsheet, searches for specific records in Airtable, and then adds each record as a new row in the spreadsheet. (Make automatically loops through your found records, so you don’t need to specify any iterations.)
