Auto populate Custom Memo ID field in InfoPath

SharePoint Asked by TBR_2019 on December 2, 2021

I’m currently working on a SharePoint list and have been asked to develop a new form for when an Item is added to the list. I have the new form completed except for the final edit. I have a column Named “Memo ID”, on the new form this field needs to be automatically populated to the next Memo ID # when you open the form by clicking on add new item in the SharePoint list. For Example: Memo ID # of last item added to list is 202010. When the form opens up to add a new item The Memo ID # should already be 202011.

I’m new to SharePoint and InfoPath, any help would be greatly appreciated.

One Answer

Create a Receive data connection to the list, on Form Load retrieve the item with the largest number, increment that number by one and populate the field in the new form.

More details and step by step instructions here.

Answered by teylyn on December 2, 2021

Add your own answers!

Related Questions

Error creating SPFx with React JS

1  Asked on October 28, 2020 by tezz-chaudhary


Depolying SPFX Web Part on On Prem 2019

0  Asked on October 12, 2020 by kurt-cooney


Automate posting to SharePoint with Python

1  Asked on October 4, 2020 by brinley


Workflow updating a multiple value lookup column

1  Asked on October 3, 2020 by jl421


how to search people in search box in sharepoint 2013

1  Asked on September 6, 2020 by sharepointman


How to see checked out file

2  Asked on September 2, 2020 by dingo


SharePoint o365/online – This site can’t be reached

1  Asked on August 26, 2020 by rohit-waghela


Ask a Question

Get help from others!

© 2023 All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP