Help needed if there is a way to have variable check boxes

[HPIvt]

Thanks Dan, Id be glad to share the job files if you'd want to take a stab at it, It would be an InDesign file or pdf and an excel sheet with the data.

[Dan Korn]

Originally Posted by HPIvt

Thanks Dan, Id be glad to share the job files if you'd want to take a stab at it, It would be an InDesign file or pdf and an excel sheet with the data.

I think I've suggested pretty strongly, in this thread and others, that it's almost always better to post the job files, as that makes it much easier for me, or anyone else who's trying to help, rather than just looking at the job through a keyhole.

The collected PDF template is usually the best way to share the job. You can just do a Collect from the FusionPro menu in Acrobat and collect to a Zip file. This will bring in the data file. (You don't need to collect the fonts, unless the issue is specific to the fonts in the job, and they're really used only in Server and Producer compositions anyway. In this case, I already have the fonts I suggested, so I don't need yours.)

Though as my signature notes, I make no promises about looking at any files. Others can feel free to look at them, though, and answer any questions. (In this case, it's pretty likely that I'll at least take a peek.)

Of course, please do not post any personal or proprietary data. You can always mock up some dummy data, just enough to be able to compose or preview the job to reproduce whatever the issue is that you want looked at.

[HPIvt]

I have been trying and still no luck, I didn't even see that your last reply had gone to a page 2 of the thread, I'd be glad to post the files if you or anyone else wants to take a stab at it.

Just to recap, this is a reply card, the data file has three years of $ giving, some people have none, so the goal is to have an unchecked box of there is no $ value, if there is a dollar value of any amount, the box should be checked.

Many thanks in advance!

EDIT by Dan Korn: Attachment deleted as it contained personal data.

[Dan Korn]

Originally Posted by HPIvt

I have been trying and still no luck, I didn't even see that your last reply had gone to a page 2 of the thread, I'd be glad to post the files if you or anyone else wants to take a stab at it.

Thanks, having the files makes it a lot easier to help. Although, you should post some dummied-up data instead of actual people's personal information. (I had to delete your attachment for security reasons.)

Originally Posted by HPIvt

Just to recap, this is a reply card, the data file has three years of $ giving, some people have none, so the goal is to have an unchecked box of there is no $ value, if there is a dollar value of any amount, the box should be checked.

Sure. You can do what I mentioned in my previous post, and create a set of Drag-and-Drop rules, without any JavaScript. See the attached template where I've done that.
Of course, this can be done with just a few lines of code instead, if you prefer.

[HPIvt]

Hey Dan, sorry I thought I had removed the personal data, I uploaded the wrong one, this file has just the dolor amounts listed, no addresses or names. Again sorry about that!

[HPIvt]

Hi Dan, posting a new zip file. Same idea just another client who has 6 levels to create check boxes for.

I used the rules you had set up for the previous one. All works now yet I can't get the dollar signs to produce when linked to the XLS file. This is perfect except for that. If I switched to a csv file instead, it will make dollar signs, but the boxes seemed to stay all the unchecked version.

Would love to use this as is if I could make the dollar signs visible.

Last time when I did check boxes manually I had used the number to currency rule to do this, but since we have a rule to return the graphic based on the amount column itself, ice t possible to apply 2 rules to the same field? Sorry if this is getting too complex, just that automation is the key here. Let me know your thoughts. Thanks.

[Dan Korn]

Originally Posted by HPIvt

Last time when I did check boxes manually I had used the number to currency rule to do this, but since we have a rule to return the graphic based on the amount column itself, ice t possible to apply 2 rules to the same field? Sorry if this is getting too complex, just that automation is the key here. Let me know your thoughts. Thanks.

Sure, you can apply as many rules as you want. You're on the right track. You've created the rule "Number to Currency Rule: _2017GIFTS". You just need to actually call out that rule in the text frame instead of just the field. Then you can create a similar rule for each of the other fields and apply them in their frames.

[HPIvt]

Feel silly asking this but what do you mean by call out that rule in the text frame instead of just the field. Not like this right? When I did this it made a dollar sign in ones that need to be empty.

[Dan Korn]

Originally Posted by HPIvt

Feel silly asking this but what do you mean by call out that rule in the text frame instead of just the field. Not like this right?

Well, it's very hard to see that low-resolution picture, but Yes, I mean, in the Variable Text Editor dialog, instead of selecting the name of the field in the Variable drop-down, select the name of the rule and insert that into the text.

Originally Posted by HPIvt

When I did this it made a dollar sign in ones that need to be empty.

Right, that rule doesn't do exactly what you want in this circumstance, so you'll need a custom rule, like so:

var val = StringToNumber(Field("_2017GIFTS"));
if (!val)
    return "";

return FormatNumber("$#,###.##", val);

Make a version of that for each of the years, and insert those rules into the appropriate text boxes.

[HPIvt]

Thanks Dan, just getting back into the swing of things after the holidays. I will take a stab at this, thanks again for your insight and help. Lao the low resolution image was because there seems to be a file size limitation which is quite low for images, I had to keep making it smaller and smaller for it to take the attachment.


- Ben