Forum Discussion
andrewmice
Apr 14, 2020Copper Contributor
Generate an id reference field
hi When we get a new order, my team click the '+ New' icon and do some data entry into a dataset page and click save. I want to configure Sharepoint so that, when they click 'Save' it automat...
Swaminathan Sriram
Apr 14, 2020Iron Contributor
Hi andrewmice,
You can create a new Calculated Column with the below formula in your List/Library to concatenate Client Name field (Text field) and Today's date and display as per your need. Please ensure to make the Client Name field as mandatory field in your List/Library. The below formula has to be entered in the Formula space after selecting Calculated in your create new column screen.
Formula is =CONCATENATE([ClientName_Field],TEXT(Today(),"ddmmyyyy"))
Please change the fields name as per your List/Library Columns.
I hope this is helpful, please like it or mark it as a solution if it answers your query.
Thanks.
You can create a new Calculated Column with the below formula in your List/Library to concatenate Client Name field (Text field) and Today's date and display as per your need. Please ensure to make the Client Name field as mandatory field in your List/Library. The below formula has to be entered in the Formula space after selecting Calculated in your create new column screen.
Formula is =CONCATENATE([ClientName_Field],TEXT(Today(),"ddmmyyyy"))
Please change the fields name as per your List/Library Columns.
I hope this is helpful, please like it or mark it as a solution if it answers your query.
Thanks.