Reply To: Subtracting Percentage from Pricing Script

We don’t put any of the sale pricing information into the database because it constantly changes from book to book. So when the initial copy block is pushed onto the page it comes in with just the regular price (which is NOT barred).

When the item goes on sale I then use find/change queries to “add” all that information to the copy block as you’ve seen in previous screenshots. Once the copy block has the Red Save $0 in the first paragraph, and the Sale Price in RED in the other paragaraphs, I use the scripts to change the pricing.

So the database doesn’t contain anything but the basic information and regular price. Everything after that is added in Indesign on the fly when it needs to change.