new to SP and need help with creating a form
As mentioned in the title, this is the first job i’ve used sharepoint at and i’m not sure of all its capabilities and such so this may seem like a simple task 😅
i’m trying to create a form for employees to submit per diem requests. so i need them to have access to the form for starters.
When they enter their name, i want the “employee code” field to auto populate with their code based off a data list that contains all employees and their codes.
next, when they start typing the job number, i want a drop down menu of all the available matching job numbers based on what they entered so they can select it. currently, we have it so they manually enter the job number, but if they make a typo without realizing and submit their form, it creates a mess behind the scenes so we want to prevent that by allowing them to select the number from a drop down list.
i have a list of all available job numbers as well as employees and their codes, but im not sure how to connect those to the sharepoint form for the data to be pulled from.
any and all help and advice is appreciated :)