- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2022 03:57 AM
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.
Solved! Go to Solution.
- Labels:
-
Change Management

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2022 04:00 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2022 04:00 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2022 08:12 PM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2022 04:00 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2022 04:02 AM
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