IF AND Validation Formulas in Custom Form

Status
Not open for further replies.

maxwello

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Hi,

I am a Newbie to Outlook Custom Forms and I want to know if it is possible to use a IF AND formula in the validation tab under properties.

What I want to happen is, If the user has selected Bloomberg in the platform field and the Clearing Applicable field is Blank then to throw up a message "Please advise if Clearing is applicable"

I have tried, IF [Platform]="Bloomberg" AND [Clearing Applicable] <> "" and different variations and I have broken it down and tried just using [Clearing Applicable] <> "" which gives me the message but when I tried [Platform]="Bloomberg" nothing worked.

I have searched the internet but haven’t had any luck finding a solution PLEASE HELP.

Appreciative Newbie
 

maxwello

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Thanks Larry,

Although I still cannot get it to work, will the statement work in the Validation Formula bar?

=IIf([Platform]="Bloomberg",[Clearing Applicable] <> "")
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Anything available in Fields and Functions should work.

Do you get any error messages?

The formula format is IIf( expr , truepart , falsepart ) and it looks like you are missing the falsepart. (I'm not sure the true part is right either)
 

maxwello

Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Anything available in Fields and Functions should work.

Do you get any error messages?

The formula format is IIf( expr , truepart , falsepart ) and it looks like you are missing the falsepart. (I'm not sure the true part is right either)

Hi Diane,

What I want to happen is If Bloomberg = yes then the user needs to put a value in client clearing field, if they dont I need the error message to pop up asking the user to add a value and if Bloomberg isnt selected at all then to ignore everything and carry on.

So far I have entered the formula in the properties validation line and then entered the message in the line below. But with the formulas that I have played around with so far I cannot get anything to work. I would really appreciate some further assisance as this is stopping me getting any further on my project.

Kind Regards

OLiver
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
F Validation on custom task form after task acceptance Outlook VBA and Custom Forms 1
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
B Date validation in Outlook Custom Form Using Outlook 2
C Forms: Validation Using Outlook 0
C Outlook Forms: Validation Using Outlook 7
S Reminder Time and Reminder Validation Outlook VBA and Custom Forms 2
F Data validation Outlook VBA and Custom Forms 4
C Adding date Validation between 2 months Outlook VBA and Custom Forms 3
C date formulas / mathematics, setting a field one hour past another field value Outlook VBA and Custom Forms 1
C Create Meeting With Custom Form Outlook VBA and Custom Forms 3
FryW Need help modifying a VBA script for in coming emails to auto set custom reminder time Outlook VBA and Custom Forms 0
J custom form not displaying pictures Outlook VBA and Custom Forms 7
I Button PDF in Outlook Contact custom form Outlook VBA and Custom Forms 1
K Font Sizing in Custom Form Regions for Contacts Outlook VBA and Custom Forms 1
V Update new custom field Outlook VBA and Custom Forms 5
D Anyone tell me where custom view settings are stored? Outlook VBA and Custom Forms 9
S Outlook 2016 Arrange tasks by date, additional custom sorting, but still use friendly terms like Today, Tomorrow, This week? Using Outlook 1
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
H Custom Outlook Contact Form VBA Outlook VBA and Custom Forms 1
S Custom Field Cannot Be Displayed In Views Outlook VBA and Custom Forms 2
D Custom Search Folders not refreshing/updating automatically Using Outlook 0
K UDF with formula not showing on Calendar custom view. Outlook VBA and Custom Forms 0
S Create a clickable custom column field Outlook VBA and Custom Forms 0
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
M VbScript for Command Button on Contacts Custom Form Using Outlook 1
G Other users can't see P.2 with custom fields in Form Outlook VBA and Custom Forms 0
O Create a custom contact form - questions before messing things up... Outlook VBA and Custom Forms 4
S Reference Custom Fields with VBA Outlook VBA and Custom Forms 2
L Custom Form Tutoral? Outlook VBA and Custom Forms 6
D Lost Access to Custom Form Outlook VBA and Custom Forms 4
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
S Outlook Custom Form Scripting only working when clicking on "Run this form" Outlook VBA and Custom Forms 2
A Custom VBA to sort emails into folders Outlook VBA and Custom Forms 0
Victor_50 Outlook 2013 Custom Contact Form starts with "E-mail 2" Outlook VBA and Custom Forms 2
C Custom Form (seperate layout pages and message reading pane) Outlook VBA and Custom Forms 0
C Reading Pane for Custom Form Outlook VBA and Custom Forms 2
M Custom Calendar Print Suggestions? Using Outlook 0
K Custom Category Colors Using Outlook 2
N Custom Form Controls Not Visible To Recipient Outlook VBA and Custom Forms 3
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
Randy Redekopp How To Merge Contact Info to Email Custom Form Template Using Outlook 2
D Problem with custom form including _DocSiteControl1 Outlook VBA and Custom Forms 0
C Custom Outlook Form - Populate Information from Radio Button / Check Box Using Outlook 0
H Custom Signature Not Displayed When Account Selected Outlook VBA and Custom Forms 10
E Custom formula for columns Using Outlook 3
W Message class changes of a custom form changes to the default form Using Outlook 2
A Possible to hide ribbon with custom appointment form? Outlook VBA and Custom Forms 3
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
Andrew Quirl Custom form to route requests based on input criteria Outlook VBA and Custom Forms 1
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4

Similar threads

Top