Best answer

Use variables to control colour in a document

  • 14 August 2019
  • 2 replies
  • 310 views

Userlevel 3

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!


icon

Best answer by jesse 16 August 2019, 19:45

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +9

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!


Userlevel 3

Thanks Jesse, I'll give this a go!