Forcing a user to select an item from a combobox field in a form

Posted on 2006-05-12
Last Modified: 2013-12-18
Please could anyone point me in the right direction for forcing a user to select an item from a field.
I have a form with various fields on it.

I also have a layer on the form which is hidden until an item within a field is selected.
This opens up the layer and I now want the user to select one of the options in the drop down combobox.
At the moment it does open but I can just carry on without selecting it, therefore not capturing the data.

I have looked in the designer help and think I need to write a command that uses @Failure on the Input Enabled or Input Validation part of the field, therefore forcing the user to select an option from the field.

I really need to do this urgently if anyone can help - thanks a lot !

Question by:gray180
    LVL 19

    Accepted Solution

    Field Input Validation:
    for Field1:
    @If(@ThisValue="";@Failure("Please enter value");@Success)

    for Field 2:
    Field Field1:=Field1;
    @If(Field1!="";@if(@Thisvalue="";@Failue("Please enter value");@Success);Field2)
    LVL 40

    Expert Comment

    Hi gray180,

    Just a guess but is there a way of marking an item as the default item so you will always have AN item selected? If the user doesn't pick one the default will be used.


    Richard Quadling.
    LVL 18

    Expert Comment

    Hi gray180,

    Also, after the value is selected you need to refreshhideformulas... to get the hidden stuff to show.


    Author Comment

    Hi all,
    Sorry for the delay in getting back to you.

    Thanks for your help Madheeswar. I had to make a slight change to get it to work though; I don't know if it was because the layer was hidden I'm not too sure.
    Here's the field 2 command I have put in.  It works, but would be grateful if anyone can see a problem with it?

    FIELD Network:=Network;
    @If(Domain!="customer1";@Success;@If(@ThisValue="";@Failure("Please enter value");@Success))

    What happens is the user selects the network field and if it is not equal to "customer1" the "Customer_List" field doesn't require validating, hence success.

    If it is "Customer1" then the field appears and a selection needs to be made.  I don't require the field data to be captured due to it is just there for information to the user.

    Does this seem OK?  I understand what is going on with the command and it does work but I am no expert so I don't know if it will be OK.

    Thanks for everyones input.  
    Also Marilyn I had somehow unchecked the form properties for refresh all fields so thanks!
    LVL 19

    Expert Comment

    Looks OK to me ..

    Author Comment

    Good stuff.

    Thanks again for your help.  Really is appreciated!!!!


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

      In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
    This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now