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

Question

question

MichaelHan-MSFT asked Oct 27, '20 EchoDu-MSFT answered Oct 29, '20

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

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

office-sharepoint-online

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EchoDu-MSFT · Oct 28, 2020 at 11:19 AM

This is a quick note to let you know that we are performing research on this issue.

Thanks,
Echo Du

0 ·

Answer 1 · 2020-10-29T08:57:49.797Z

EchoDu-MSFT answered Oct 29, '20

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:

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

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

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

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

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.

1.png (82.1 KiB)

2.png (59.7 KiB)

3.png (64.1 KiB)

jquery.txt (1.8 KiB)

4.png (35.8 KiB)

5.png (7.9 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question