IMPORTANT ANNOUNCEMENT

These forums were permanently set to read-only mode on July 20, 2022. From that day onwards, no new posting or comment is allowed on the site, but the historical content remains intact and searchable.

A new location for posting questions about PlanetPress Suite is now available:

OL Learn - PlanetPress Classic (opens in new tab)

Topic Options
#39251 - 04/18/12 10:20 AM Expression Help
MIBPP Offline
OL Newbie

Registered: 02/10/12
Posts: 3
Hi...I have a business card in PSM and on one line will be displayed the Telephone and fax numbers if they exist. I have a database field for the phone and one for the fax. The expressions I have created so far works well, but when the PHONE number does exist and the fax number does not is there an expression that I can add to the below PHONE field expression?

I would like to add like an OR expression to say state If the tel & Fax exist, display Tel: 00000, Fax: 00000 OR IF PHONE exists and Fax does not, display Tel: 000000. can I do that in one expression or am I approaching this in the wrong way. I've tried OR, but can't get it to work.

For PHONE field
IF([PHONE] > "" AND [FAX] > "",("Tel:"&" "& [PHONE]&", Fax:"&" "& [FAX]),"")

Displays Tel: 0207 88 77 88, Fax: 0207 88 88 11 or nothng

and for FAX field
IF([PHONE]="" AND [FAX]>"","Fax:"&" "& [FAX],"")

Displays Fax: 0207 88 88 11 or nothing

Top
#39254 - 04/18/12 10:56 AM Re: Expression Help [Re: MIBPP]
MIBPP Offline
OL Newbie

Registered: 02/10/12
Posts: 3
Figured it out....Here's what I did for someone else who has the same question.

IF([PHONE] > "" AND [FAX] > "",("Tel:"&" "& [PHONE]&", Fax:"&" "& [FAX]), IF([PHONE] > "" AND [FAX] = "",("Tel:"&" "& [PHONE]),""))

Top
#39279 - 04/19/12 05:06 PM Re: Expression Help [Re: MIBPP]
Benoit Potvin
Unregistered


nice job wink

Top