Auto Populating textboxes or a table from data thats in a list- sharepoint 2020

MichaelHan-MSFT 18,016 Reputation points
2020-10-27T07:40:58.4+00:00

Hi,

I am doing a project at work to do with share point and in this project I have a 'list' with lots of employees details on such as employee ID number, Name, Number and email ect...

I then have a table on another page I would like for the user to put the Employees ID number in and all other details such ask email name ect will auto populate giving you all the employees details.

Have done some research on this and ive found that I will need to use a lookup but as I am very new to this, I don't know where to start.

Is anyone able to tell me if this is doable and how to go about it.

Thank you

lolbird

Source link from TechNet

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,684 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Echo Du_MSFT 17,116 Reputation points
    2020-10-29T08:57:49.797+00:00

    Hello @MichaelHan-MSFT ,

    You could use JQuery to auto Populating textboxes/form in SharePoint online/13/16.

    Please follow these steps:

    1.Create two customized SharePoint Lists, named "Employee Table" and "ET.1". As shown below figure:
    35879-1.png

    2.Go to ET.1 List, click new item link to jump to NewForm.aspx >> click "Edit page"
    35907-2.png

    3.Click "Add a Web Part" >> click "Media and Content" folder, and then add "Script Editor" web part
    35936-3.png

    4.On the "Script Editor" web part, click "EDIT SNIPPET" >> on the Embed dialog box, paste the below script: The JQuery.txt

    35926-4.png

    5.When you create new items , you will find the following effects
    36022-5.png

    Thanks,
    Echo Du

    ==================

    If an 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