Topic Options
#35582 - 04/05/11 04:19 PM If then with a graphic
A Plus Letter Offline
OL Newbie

Registered: 04/10/08
Posts: 15
Loc: USA
I have a set up that is giving me some trouble. I have variable data with ask1,ask2,ask3,ask4,ask5,ask6 and not all the time are all of these fields filled. So when they are populated I need to put a box in front of each ask as if they are going to check it off. When I past the symbol from word it becomes a "q" and not a box. So I end up with a my statement looking like this:IF([Paraask] = "6", " q
" & [Ask1] & "" , "")I need to make this for all six asks. example if paraask=1 I would put a box then ask1, if paraask=2 I would put a box then ask1 5 spaces then another box then ask2. and so forth.

Top
#35590 - 04/06/11 09:09 AM Re: If then with a graphic [Re: A Plus Letter]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4953
Loc: Objectif Lune Montreal
APlusLetter,

The "q" only shows up as a box if you use the Wingdings font. What you'll want to do is use two variables next to each others, one for the box, and one for the actual data. Both will have essentially the same condition, but one will display "q" if the field is not empty, and the other will display the actual data. Once created, you will give the "Wingdings" font to the variable that display "q". This will make it display a box next to the variable.

Hope that helps!

Regards,
Raphaƫl Lalonde Lefebvre

Top
#35596 - 04/06/11 10:17 AM Re: If then with a graphic [Re: Raphael Lalonde Lefebvre]
A Plus Letter Offline
OL Newbie

Registered: 04/10/08
Posts: 15
Loc: USA
I do not understand what you mean by two variables next to each other?

I am doing an expression for the paraask field.
If paraask =6 then I need to put this statement:
 ask1  ask2  ask3  ask4  ask5  ask6
for paraask=5 I put this statement:
 ask1  ask2  ask3  ask4  ask5
for paraask=4 I put this statement:
 ask1  ask2  ask3  ask4
for paraask=3 I put this statement:
 ask1  ask2  ask3
for paraask=2 I put this statement:
 ask1  ask2
for paraask=1 I put this statement:
 ask1
for all the ask fields are a merge within the expression.

Karen A. Kelly

Top
#35603 - 04/06/11 12:22 PM Re: If then with a graphic [Re: A Plus Letter]
A Plus Letter Offline
OL Newbie

Registered: 04/10/08
Posts: 15
Loc: USA
can I change the fonts in the expression? That is is the only way I can make this work.

Top
#35604 - 04/06/11 12:29 PM Re: If then with a graphic [Re: A Plus Letter]
Eric Lachance
Unregistered


Karen,

What Raphael means is that you need to create 2 expressions (2 variables) that are side-by-side in your Text object.

So if you have @Checkbox@@paraask@ , then you can have a similar expression for both variables, but the contents would be different:

Checkbox: IF([Paraask] = "6"," q ","")
paraask: IF([Paraask] = "6",[Ask1],"")

If you then apply the wingding font to @checkbox@ and a regular font to @paraask@ , you should be golden.

Top
#35607 - 04/06/11 12:49 PM Re: If then with a graphic [Re: ]
A Plus Letter Offline
OL Newbie

Registered: 04/10/08
Posts: 15
Loc: USA
Will that work with the sometimes they might have 6 asks other times 5,other times4,other times 3, other times 2 and then 1 ask?

Top
#35608 - 04/06/11 12:50 PM Re: If then with a graphic [Re: A Plus Letter]
A Plus Letter Offline
OL Newbie

Registered: 04/10/08
Posts: 15
Loc: USA
I did work it out with use 2 different text boxes with the expressions for each in their own text box then overlaying them 1 other the other.

Top