Link to home
Start Free TrialLog in
Avatar of MitchellVII
MitchellVIIFlag for United States of America

asked on

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

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
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

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 }


Avatar of MitchellVII

ASKER

I cant see to get that to work.
Ok I got it to work, I just neede to insert the symbol directly into the formula from the menu.  works great now :)
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Sorry, Mitchell, I meant to refer to this question, not post a comment in it.
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.
Thanks Mitch. I'll look forward to it.
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
That looks good.
Shame I'm too old & in the wrong country to apply.
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.
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.

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 :)