Hi,

Can data be pulled dynamically using Javascript client object model?

I have a custom list, which has a title column which contains values like "Tester, developer", another column contains the trainings. example as below

Tester      =  Manual Testing
Developer   = SP2013 Training
Tester      = Selenium
Tester      = Other Automation tools

In another list, which has a title column which contains values like "Project A", Project B" , another column contains the trainings. example as below:

Project A  = Training 1
Project B  = Training 1
Project A  = Training 2

I am trying to create a custom list which will have following columns:

User Name, Role, Project, Training

When a particular Role and project is selected, all the trainings for that role and project should be listed. User should be able select the trainings which they have completed and save it.

Example:

Role is Tester and Project is "Project B", then the training column should have in a listbox and user should be able to select

Manual Testing
Selenium
Other Automation tools
Training 1

How to achieve this?

I cannot use InfoPath or Visual studio. I can add jquery in CEWP in the custom list.

Is it possible to use client object model/javascript object model in the above scenario and how to achieve it?

Thanks

you can use a CEWP in newform using JScript.

In this case, your drop down should always be blank and it should get values appended with the values from your master two lists.

Hi,

you can put a Script editor webpart in your new form and edit form, in script editor webpart load your java scripts file where you can write CSOM (JAVA script code) to get items on columns.

But this logic won't work in spread sheet view.