Show values from other list in Form Designer

Discussions about Forms Designer for SharePoint 2013 / 2016 and Office 365.
Locked
ching29
Posts: 15
Joined: Thu Mar 13, 2014

29 May 2018

Hi,

I have another query, I would like to ask if its possible to show values from another list in the Forms Designer, like 'JOIN' in SQL? I would like to show some details(columns) from 'List 1' to 'List 2' using a 'primary key' that is found both in 'List 1' and 'List 2'.

If it's possible, I wouldn't like to create another column for 'List 2' just to 'Lookup' from 'List 1' because it would be tedious to update both lists when there would be a change on their values and I think it's 'Data Redundancy'.

Btw, I am using Forms Designer Client 3.1.5.

Thank you.


Regards,
Ching

User avatar
Nikita Kurguzov
Posts: 889
Joined: Mon Jul 03, 2017

29 May 2018

Dear Ching,
Do you mean just on the form or in the list view with other columns? If you mean just the form, it should be possible to retrieve values from the other list with JS, following this article by Microsoft. It's fairly straighforward - send the request once the form opens, retrieve the correct value with CAML query and display it somewhere on the form - either append to an existing element, or use HTML control, or insert into a field, etc.
Cheers

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 14 guests