- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2022 12:40 PM
Hello,
I have a requirement to allow users to select multiple values within 1 field. For example, the field is called Select User. They can select multiple user into the field; then submit the record. What field type should I use on the variable and table definition to make this work? How will I limit to show on a group of users instead of ALL users?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2022 12:47 PM
Hi,
If this is for a catalog item/record producer, for exmaple, you'd want to use a list collector variable and referencing the sys_user table, or a "list" type field is this is for a table. Once that is selected, you can use a reference qualifier to them limit the amount of data (users) that would show.
Please mark reply as Helpful/Correct, if applicable. Thanks!
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2022 12:47 PM
Hi,
If this is for a catalog item/record producer, for exmaple, you'd want to use a list collector variable and referencing the sys_user table, or a "list" type field is this is for a table. Once that is selected, you can use a reference qualifier to them limit the amount of data (users) that would show.
Please mark reply as Helpful/Correct, if applicable. Thanks!
Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-02-2022 02:06 PM
Hi Allen,
Thanks for the suggestion. Ref qualifier worked.