Populate fields with default values in SharePoint Online grid view

John Doe 16 Reputation points
2020-10-14T14:03:00.79+00:00

Hi,

I have defined default values in my SharePoint list (presented in Teams with Microsoft lists tab). If I create a new entry using a form the default value is automatically populated. Though in grid view this is not working.

How can I achieve this?

Thanks for any advice
John

Microsoft 365 and Office SharePoint Server For business
Microsoft 365 and Office SharePoint For business Windows
Microsoft 365 and Office SharePoint Server Development
{count} votes

2 answers

Sort by: Most helpful
  1. Sharath Kumar Aluri 3,071 Reputation points
    2020-10-14T18:03:43.333+00:00

    That is by design in SharePoint Online Grid View. In the Quick Edit Mode values won't be populated automatically. You might have to go with customization.

    https://www.codeproject.com/articles/813090/master-detail-with-jsgrid

    Thanks & Regards,

    0 comments No comments

  2. Elsie Lu_MSFT 9,801 Reputation points
    2020-10-15T07:03:14.4+00:00

    Hi @John Doe ,
    Per my test, the default value will be automatically populated after you exit grid view and it will not be displayed when editing, please take a quick look at the screenshots below.
    This is a by-design behavior for editing in grid view. We cannot customize it. If you have some thoughts about this feature, make a new post in UserVoice and make MS know your ideas.
    32547-10151.jpg32516-10153.jpg32517-10152.jpg


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.