Text In colors

[mo]

Hi,

I'd like to bring text from my Google sheet to the certificate in Slides in the color in sheets, based on Hex color listed in the sheet. How would I do this? Thanks

[ete...@gmail.com]

I don't believe you can as the Add on will just pick up the bare text and place it into the document overwriting any formatting within the template.

[Joseph Schmidt]

Try changing the color in the template.   

The merge tag should bring in the text but the color, font, and size should remain the same.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

On Thu, Sep 30, 2021 at 7:29 AM mo <mord...@israel365.com> wrote:

Hi,

I'd like to bring text from my Google sheet to the certificate in Slides in the color in sheets, based on Hex color listed in the sheet. How would I do this? Thanks

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/4c9ec1ea-4774-42c1-baaf-ea185d94e600n%40googlegroups.com.

[Mordecai Altose]

Yes, I know I can adjust the template, but I want to change the color based on the text. For example, if a boy's name, the text color should be blue, if a girl's name, the color should be pink.

Thanks

You received this message because you are subscribed to a topic in the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/nv-autocrat-add-on/BaM-0NP8WJQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAPWPTOT5SXiKOwCYLansNPZgqEFVxXUqOw%3DVTzp%2BvC%2BG4q%2BoNw%40mail.gmail.com.

[Douglas Kirby]

This is how I would do it, although Joe is the expert:

I would have 2 merge jobs with 2 separate templates, one with pink and one with blue (that I assume you would have a question on the form to differentiate). Have the jobs trigger off of that question response.  If a girl, it would kick off the girl merge job with the pink template and vice versa.

Doug Kirby

01000100 01101111 01110101 01100111

ISD

kir...@franklinschools.org

317-346-8717

 

 

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAE3p5tOaPyuOOoeo_khoVEnevcUuG%3Dtn4U2aiGk4-zT_jLRXDQ%40mail.gmail.com.

[Joseph Schmidt]

I have never done this but if you can figure out the codes to change colors you can make them part of the merge tag.

I use CHAR(9) for a tab or CHAR(10) for a LF.  That goes back to my days of controlling a printer with codes.

It would be "codes"&merge text.

I don't know any easy way to do that.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

On Thu, Sep 30, 2021 at 9:30 AM Mordecai Altose <mord...@israel365.com> wrote:

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAE3p5tOaPyuOOoeo_khoVEnevcUuG%3Dtn4U2aiGk4-zT_jLRXDQ%40mail.gmail.com.

[Joseph Schmidt]

Doug,

I'm far from an expert.  I just have lots of experience.  If there are just the two colors, your idea is great.

 

If you want to have lots of color changes such as changing the color based on the grade.  Red is terrible and Green is good.

I consider myself an experienced learner.  Somedays, I learn quickly and others not so much.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/CAMp8jagLTFEWRfC5voy-MW_D%3DUQwiRaaZkawHfsVCHP5HNe%2BFA%40mail.gmail.com.