Forgot a number in InDesign, and want an easy way to put it into sequence? This tutorial will teach you how to renumber your signs in FileMaker, giving you more automation and flexibility.
Sometimes in a large project, you may forget a sign, or the client may choose to add one where you weren't expecting. It can be a real pain to re-number all your signs in InDesign, even using the helpful renumbering tool. Here's an easy way to fix that problem.
1. Add your Sign in InDesign
When you add your sign in InDesign, give it a number in between the 2 numbers that it sits between (for example, if it's between 112 and 113, make it 112.1)
This will ensure that it sorts numerically in FileMaker
Don't worry, it won't keep this ugly number when we're done.
Sync with FileMaker to move this sign information over to the database.
3. Find the Relevant Signs
Next, in FileMaker, do a Find for the relevant signs. For example, if you'll need to re-number all the signs on Level 1, do a find for Level 1.
If you only need to renumber all the E1 signs on Level 1, do a Find for both the Type of E1, and the Level of 1.
4. Sort by Number in FileMaker
Do a simple sort by number in FileMaker by clicking on the header saying "No." twice. (Be sure to click on the words, and not on the little box with the arrow coming out of it)
When done correctly, the Sort Order at the bottom-left corner of the SIGN table should display Number, Level
5. Mass Replace the Numbers
1. Once you're happy with the Sort, click the Mass Replace Number button
2. Input the number you'd like this found set to start with.
3. Input the value you'd like this found set to increment by
4. Click OK.
The numbers re-flow, giving us nice whole numbers again. And once we sync...
You can see that the sign tags in InDesign now have the proper, cleaner numbers.