We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Need to replace {MERGEFIELD} Boolean with CHECKMARK symbols....

MitchellVII
MitchellVII asked
on
Medium Priority
749 Views
Last Modified: 2009-07-29
Hi,

I have some Boolean Fields I'm importing from Access that are returning -1, 0 values.  I want to write my MergeField so that it exchanges a -1 (true) value for a Checkmark Symbol.

Can I do this in the MergeField itself or do I need to do a For Each...Next Loop to replace them on the open?

M
Comment
Watch Question

GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
You can wrap the mergefield with an IF field and do Insert symbol.

Select the mergefield << Maybe >> and press Ctrl+f9
You should then look like this

{ << Maybe >> }

You can then insert the IF, test and the symbol(s):

{ IF << Maybe >> = -1 &#8730; X }


Author

Commented:
I cant see to get that to work.

Author

Commented:
Ok I got it to work, I just neede to insert the symbol directly into the formula from the menu.  works great now :)
Retired
CERTIFIED EXPERT
Top Expert 2012
Commented:
Form Fields and Mail Merge are not really compatible. To for a form document to work properly, it must be protected. This prevents it from being used as main document in mail merge.

You can show a symbol, depending on the value of a merge field (although it doesn't show successfully in a browser):

http://www.experts-exchange.com/Applications/MS_Office/Word/Q_21800195.html

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
Sorry, Mitchell, I meant to refer to this question, not post a comment in it.

Author

Commented:
Hey Graham,

I've broken down, after all this, and just decided to create a web page to gather the information.  It has been a steep learning curve but it is almost done.  Basically I just created my form in word, saved it as a web page then opened it in Dreamweaver and plugged in fields.

Now the data is just emailed to me.  Pretty cool actually.  The web page should be up tomorrow, I'll link you to it for grins.
GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
Thanks Mitch. I'll look forward to it.

Author

Commented:
Hey Graham,

Here's the finished (well close anyway) product.  Much learning curve sweat and toil here but I think I have it.

Right now my form is sending me a TXT email with all the data in it.  Next step will be to figure out how to use PHP to write all this directly to a database.

Anyway, here's the link to my main website and you can navigate to the form from there...

http://www.executivedecision.biz/

M
GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
That looks good.
Shame I'm too old & in the wrong country to apply.

Author

Commented:
Thanks,

How old are you?  I'm 45 (ack)

Do you think the font is too small?  I personally HATE large fonts on forms, but I don't want it to be too small to read.

Also, does the opening web page look ok?  It isn't much, just a business card really.
GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
It's 22 years since I was 45. But as they say about old age - it's not so bad when you consider the alternative.

The same can be said for the font size. I think it's OK. Any bigger and you'd be scrolling up and down, and losing the place.

I think that the opening page conveys an appropriate professionalism.

Author

Commented:
Ah cool.

You know, I would have NEVER guessed you to be 67, not that that is particularly old, but you come across as quite youthful.  Rarely in my travels have I met someone quite so knowledgeable and helpful.

I kind of miss it over here - a couple of the "Experts" over on the HTML side are really arrogant jerks and love to make insulting comments about new ideas on doing a web page.

One fellow over there savaged my new pages saying they all had too small text, it wasn't good to have the text fields hidden, i should have a click noise when you enter a text field, blah, blah, blah.

I guess I need to be designing my page for those people with 14 inch screens running Windows 97?  Lol.

Anyway, thank again :)
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.