In a list type field is it possible to add both groups and users

SM27
Tera Contributor

In change added a list field referencing to group table to select multiple groups and also i wanted to add individual users but can't able to add. Can anyone please help me with this.

1 ACCEPTED SOLUTION

Sourabh26
Giga Guru

Hi,

How can a field which references to group table will be able to add the users (which exists on user table).

You need to create a separate field though.

 

Regards,

Sourabh

View solution in original post

4 REPLIES 4

Community Alums
Not applicable

Hi SM,

Reference/List fields can only refer to one table at a time. So using reference/list field you cannot achieve this. You need two different reference/list type fields. 

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

Community Alums
Not applicable

Hi SM,

I believe you have marked the correct answer wrongly, as i have said the same thing on my answer Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

Sourabh26
Giga Guru

Hi,

How can a field which references to group table will be able to add the users (which exists on user table).

You need to create a separate field though.

 

Regards,

Sourabh

Filipe Cruz
Kilo Sage
Kilo Sage

Hello SM,

That is not possible.
The list will reference only one table: if you are referencing the groups table, you will only be able to select groups.

If you want to select single users, you need to create a new List field with a reference to the sys_user table.

The only "exception" is when you reference a table that contains multiple child tables. In that case, you can select records in list that belong to different child tables.

But that is not the case of what you are exposing.

So, long story, short: it's not possible to reference groups and users in the same list. Create a new list field to select users.

Hope this helps!

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz