Page 1 of 1

Form Designer Group based on another (Lookup) List

Posted: 14 Mar 2017
by Kim Jeim
Hi,

We have a list called "Project Ideas". It has a lookup to a "Programs" list where we store Program information such as "Program Owner".

If an Idea is "In Review", all other users other than the Program Owner get sent to an empty form (non-editable view). Is it possible to set the user-defined rule for the group to check if the "Program Owner" in the other list contains the current user? The lookup is a mandatory field so the link is there.

Re: Form Designer Group based on another (Lookup) List

Posted: 14 Mar 2017
by Dmitry Kozlov
Hi Kim,

Unfortunately, you cannot use fields from other lists in the Groups manager but you can do it via JavaScript. Say, you can retrieve the Program Owner field with JSOM or REST-api and compare it with the current user then based on the result, disable or enable controls in the form:
https://msdn.microsoft.com/en-us/librar ... e.14).aspx

Our support team can assist you with the task. Just send the detailed requirements with screenshots of lists and forms to support@spform.com and we will estimate them.

Re: Form Designer Group based on another (Lookup) List

Posted: 20 Mar 2017
by Kim Jeim
Hi Dmitry,

Thanks for that. We will send you the detailed requirements if we choose to go down this path.