#SharePoint Tip: Workaround for default value on a form when using a required lookup column (no code).

tip

When using a Lookup Column on a SharePoint form, and it’s a required field, SharePoint unfortunately defaults the value on the Lookup Column, to the first field on the Lookup List. This may not be the best option when completing a form. The user may forget to select the required field, as it is already appears to be completed. A quick solution to this issue, is to add an item in the Lookup List that starts with, ‘……’ including a prompt of some sort as follows:

SharePoint Tip 1This item will then default as the first field that appears on the form as follows:

SharePoint Tip 2

 


2 responses to “#SharePoint Tip: Workaround for default value on a form when using a required lookup column (no code).”

  1. Michelle Barker Avatar

    Lester, thank you for the feedback and useful tip.

    Like

  2. Lester Avatar
    Lester

    You could envision users missing the selection box and ending up with the default being submitted. Easy to introduce a bit of javascript to either enforce a selection or blank the dropdown when the page loads. For large dropdowns I really like using jQuery AutoComplete.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: