Forms Designer Forum

Hi,


Is it possible to query other lists and set text and drop-down field values for a new/edit item based on a user selection?


Example:

Lists, all in the same site:

- Leave Request

- Manager per Employee

- Department

- Department Locations

Process:

1) For a new item in 'Leave Request', the user selects and employee from a people picker field

2) The form would lookup field "Employee" in list "Manager per Employee" and set the field "Manager" in new item in list 'Leave Request'

3) For the same new item, user selects a 'Department' from a lookup to list 'Department'

4) The form would lookup field Department in list 'Department Locations' and populate a drop-down list field 'Locations' in the new item for 'Leave Request'


Let me know if this is possible. I didn't really see and cross-list query examples. Thanks!


Joel


-------------------------

Joel Hill

Centrence - Work Smarter

www.centrence.com

Hello Joel,

You can request the additional information via REST or CSOM when the user fills in the Employee and Department columns:

http://msdn.microsoft.com/en-us/library ... e.15).aspx

Our support team can help you with this task. It will take about 200 support minutes.