• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

InDesign Merging with Conditions

New Here ,
Feb 20, 2024 Feb 20, 2024

Copy link to clipboard

Copied

I need some help because I've hit a wall. I have designed car tag pick up cards for parents to pickup their child(ren). Each grade division needs to be a different color (ie: elementary, middle, high). I can get the merge to work great but I need the merge to hold a conditional formatting from Excel in terms of the color OR does anyone know how to set a condition in InDesign based on a grade level and turn that grade level to a color? Does that make sense? I need each child to merge with a color based on their grade division. Is it possible... everything I see says NO? 

TOPICS
How to , Import and export , Print , Type

Views

104

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Participant , Feb 20, 2024 Feb 20, 2024

I would put the grade and name in the same paragraph — that way, after you do the data merge, you can do a GREP find-and-replace to apply the color to both the grade and the name at the same time.

  1. Insert a tab before the first name, adjust the tab stop in the paragraph style so it's where you want it, insert a line break (not a hard return) after the first name, and in the paragraph style apply a hanging indent that aligns with your tab stop. 

Screenshot 2024-02-20 at 11.11.29 AM.png

 

 

 

 

 

 

 

2. For each color, create a new paragraph style

...

Votes

Translate

Translate
Participant ,
Feb 20, 2024 Feb 20, 2024

Copy link to clipboard

Copied

It may help to provide a screenshot of your InDesign template to show what you'd like to change the color of (is it text, a background color, a graphic element? etc.). There may not be a direct solution via data merge but perhaps we can figure out a different way to accomplish it. 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 20, 2024 Feb 20, 2024

Copy link to clipboard

Copied

patriciag25474359_0-1708449214817.png

 

I can format the InDesign to do this and merge fine, but the problem is - what if the second child needs to also be yellow or red? I would have to format each finished merge separately and it's about 800 students so I am hoping (but not looking good) to have it recognize the grade and make the color according to the school division. 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Feb 20, 2024 Feb 20, 2024

Copy link to clipboard

Copied

I would put the grade and name in the same paragraph — that way, after you do the data merge, you can do a GREP find-and-replace to apply the color to both the grade and the name at the same time.

  1. Insert a tab before the first name, adjust the tab stop in the paragraph style so it's where you want it, insert a line break (not a hard return) after the first name, and in the paragraph style apply a hanging indent that aligns with your tab stop. 

Screenshot 2024-02-20 at 11.11.29 AM.png

 

 

 

 

 

 

 

2. For each color, create a new paragraph style, based on the existing paragraph style, with the only difference being the font color (or you could create a new character style for each color).

3. Use a GREP find-and-replace to apply the new style. For example, each of the following lines is what your Find what field might look like for each grouping of grade levels (adjust the items in the parentheses as you need to, separated by vertical slashes):

^(K1|K2)\t.+\n.+
^(1st|2nd|3rd|4th|5th)\t.+\n.+
^(6th|7th|8th)\t.+\n.+
^(9th|10th|11th|12th)\t.+\n.+

Leave the Change to field blank, and in the Change Format field select your desired style.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 20, 2024 Feb 20, 2024

Copy link to clipboard

Copied

Hmmm that might just work. I'm going to try it right now. Thanks so very much! 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 21, 2024 Feb 21, 2024

Copy link to clipboard

Copied

LATEST

It worked! You are a lifesaver. I appreciate your expertise. Taught me something new. I had to change my spreadsheet to match but I just did a find/replace on that too.  I'm going to video me doing it so I will remember for May when we roll this out... otherwise, I will forget since it's going to be a once a year thing. 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines