Loading Default Information into a sub-list - Creating a New User Request form and I would like to copy profile information into a sub-list

Original Post by Sandy (Imported from Ardevia Forum)

Hi,

I am creating a new user request form and would like to be able to load profile information in a lookup table that could be used to populate a sub-list on my form.

The profile information stored in the lookup table relates to the department that a user works in and contains information about what systems they need access to. For each department, there are multiple rows with different systems on each row.

When the user is being created on this form, the department they work in is selected from our term store and it is the department that determines the system access.

Lists are like this:

User - User ID
        Name
        Department (from Term Store)
        and other information about the user

Profile - Department (from Term Store)
          System (Lookup)
          Project (Lookup)
          Level of access (Choice)

User-Profile (Sub-list on the form)
          User ID
          System (Lookup)
          Project (Lookup)
          Level of Access (Choice)

Is this possible at all?

Thanks
Sandy

ArdeviaForum

August 19, 2016 19:28

Original Post by Matthias Walter (Imported from Ardevia Forum)

Hi Sandy,
if I understand you correctly you want to have a filter on the lookups (System & Project) in the sub list on the form to show e.g. only systems from the department selected in the main form?
so you want to place the list User-Profile on the NewForm of a user.

Please correct if I'm wrong.
At the moment lookup filtering is supported in the main form only. (by fixed values or by a selection of another field on the main form)

Columns in sub lists support calculation and dynamic activation only.

BR Matt

Search

Loading Default Information into a sub-list - Creating a New User Request form and I would like to copy profile information into a sub-list

Comments