Skip to main content

Hello! I'm trying to think of a way to make a PDF that will have tables colour-coded to the results of variables I'll be passing through (pass/fail red and green, basically).

At the moment my best idea is to create a HTML template with CSS controlling the colours, pass the colour-states in through Zapier and then PDF-print (Google Cloud print or similar) the resulting file.

I'm not sure how to achieve this, however. Has anyone either got a way for me to import and format the HTML, or a better way to do this?

Thanks in advance!


Hey @SimonJP!

Have you considered using Airtable for this? You can create a page designer "block" where you can design the template and then color code the data that comes into your table, by changing the column to "single-select" or "multi-select". From there, you can choose which data comes into the page designer. :)

Does that sound like it might help? Let me know - this sounds like a fun thing to think through if you went the Airtable route!



Thanks Jesse, I'll give this a go!