Appear in your list experience so let's check it out in [Music] action to get started with Microsoft lists in.
Office.com I'll go to the app launcher and select Microsoft lists I can click on new list and select from a wide variety of list templates provided by Microsoft or I can pick any.
List templates that are shared from my organization my scenario is I would like to gather information about users who would like to sign up for training programs within my.
Organization I'll start off with a blank list contoso training signup list give it a description I can choose an icon give it a color and I can save this either to my.
Types I'll go ahead and create a column of type date and time I'll call a training date and save I'll add a column of type multi lines of text called commands and.
Save if I try to add a new item in this list it opens the standard list form experience and to customize this we have various options we have the ability to edit the.
Columns we can reorder columns show and hide columns by writing conditional formulas we also have the ability to configure the layout wherein we can format the header of the form the footer.
Of the form as well as the body by using Json formatting we also have the ability to customize our forms by leveraging power apps now we have an additional option.
Called forms I'll select forms and I'll click on new form I can give my form a title I can also give a description for.
Posts Related:
- How to Add Responsive Tabs Design to Your Blogger Website
- The AMAZING TRICK To Add Different User Security Rights to ANY Excel Sheet and User Login
- How To Obfuscate JavaScript Code - Live Blogger BlogSpot
My
Form and these are the current Columns of my form I can reorder the these by drag and drop I can also hide columns by simply unselecting.Them I can select a specific column like training date I can change the name of the column here in the form preferred training date can also give a description I have the option to make it.
A required field and that's gone ahead and made the updates for the specific form my column commands I'll change the title add a.
Description I also have the ability to add new Fields these will land up as actual columns in my list and these are the list of columns.
Supported by forms I'll add a column of type person I'll call it participant provide a description and I'll make this a.
Required field I will reorder participant to sit right at the top next I'll add another field of type Choice training program.
Description I'll go and plug in all my choices I will make this a required field and I will position this right here so this has gone ahead and saved all my.
Changes I can go ahead and preview the form experience when I'll share the link to my recipients this is the form experience that will light up for.
Them it will give out the name of the current user filling the form and will let them know that the owner of the form will be able to see your name an email address and these are all the different.
Columns that I added as part of my form
Experience we also have an option for themes so there are different theme styles that you can choose can also go to create your own.Style and under settings accept responses the form is open to accepting responses confirmation message once the recipient submits the form what's the.
Message you would like to show to the recipient I'll go ahead and change the confirmation message now to send this form all I have to do is click on send form.
People in my organization with the link can respond I click copy link which I can share with users in my organization any user in my org will be able to respond to this I can share it.
In an email or teams or more now Sarah can launch the form experience participant Sarah is signing up for herself she sets her preferred date of training picks the training.
Program and submits her response back to my list signed in as Resa I can see that Sarah has made a submission for a specific training program Sarah has no access on the list.
Sarah cannot see all the items in the list launching the form as another user James James submits his response and the list gets updated now a user can submit multiple.
Responses so James can submit another response can go back to forms so this is my form that I created which is currently open meaning open to responses if at any moment you want to.
Turn it off you can say stop accepting responses and when a user tries to access the link it states we are not accepting responses at the moment this message as well we can.
Customize right here under form settings and if you start accepting responses that same link that was shared becomes active you can also create multiple.
Forms for the same list let's say I'll go ahead and duplicate this form so here's another variation of the form in this form I do not want to show.
Additional commands I'll add a yes no column have you taken this training before I'll click Send form and copy the link to my newly created.
Form Sarah tries to launch the URL to the new form and all the information will be saved in the same.
List the form is going to respect your column settings I would like a particular participant to only sign up for a single program so participant needs to be.
Unique and all I have to do here is go to the column settings and enforce unique values now if a user tries to make a submission for a participant that.
Already exists you can see that the list rule enforcement comes into play here I have a modern SharePoint list where I would like to store idea.
Submissions any user in my organization can submit an idea but I do not want to give them access to this list so they can see submissions that other users have made well I can use.
Forms approval decision is a column that I would like to maintain internal to my form and I do not want to expose that to the recipients filling out this form my form's ready I'll get the link.
That I can share within my organization and users can leverage that link to start submitting ideas Sarah submits her idea click submit.
And all that information gets logged in my list if you enjoyed this video then do like comment and subscribe to my YouTube channel and thank you so much for.
