Conditional Colors from Make to Google Slides Based on a Survey Score 0-100

Questions
1

I’ve seen three similar thread topics, but none helped me for this issue. I am having Make pull a 0-100 score field from a survey. I want to map the score to a Google Slides textbox. That is working fine. However, I want to fill the text box with one of four color backgrounds based on the score (i.e. 90+ green, 80-89 blue, 70-79 yellow and <70 red). I have both the RGB and hex number for each color. At this point I am trying to do it via Accent1 (through 4) colors in the Google Slide theme. Using a Google slides Make an API Call. I’m struggling to get the correct Body in that module as well as the correct set variable for the color formatting in the Tools module. :slight_smile: Thanks.

4

Hi @Bill_Glenn

Maybe you could post the body that you are trying to use.

Are you setting the accent on the Master Page? Accent colors are part of the theme, and themes are defined on Master pages. You need to target the specific Master page whose accent colors you want to modify.

I googled a possible body for an UpdatePagePropertiesRequest and got this simple example:

{
  "requests": [
    {
      "updatePageProperties": {
        "objectId": "your_master_page_id",
        "pageProperties": {
          "colorScheme": {
            "themeColorType": {
              "ACCENT1": {
                "rgbColor": {
                  "red": 1.0,
                  "green": 0.0,
                  "blue": 0.0
                }
              },
              "ACCENT2": {
                "rgbColor": {
                  "red": 0.0,
                  "green": 1.0,
                  "blue": 0.0
                }
              }
              // other accent colors
            }
          }
        },
        "fields": "colorScheme"
      }
    }
  ]
}

@damato