How can I check the group name that a user belongs to in Forms? Thanks.
Priya
How can I check the group name that a user belongs to in Forms? Thanks.
Priya
You can add a new Data Source of your Forms database, then have Lookup Rules that:
1. fill out the dropdown of users by looking at cf_user_snapshot (your choice of username, email, or displayname - really depends of your licensing model)
2. have a hidden field (that has data Saved instead of ignored in Field Rules) that will get the "id" from the same table from step 1
3. finally a read-only single line field for your Teams output and another hidden field for your Team Id
4. in the Team Id field, you will do a lookup from the "team_members" table (when "user_id" of the team_members table matches "id" of the cf_user_snapshot, load all "team_id")
5. "full_group_name" column in the cf_usergroup table will have your Team name and team id (called "group_id") - so load the group names based on the team_id form step 4 into your Team dropdown
Based on this information I am sure you can tailor it closely to your needs :) Let me know if you need more help!!
Thanks. I would like to know what group in LFDS that user belongs to please not Teams. Thanks.
Priya
Laserfiche Directory Server right? If so, I am not sure because we are on avante license.
If you have someone on your team, you can have them run a discovery query against the LFDS database I have below to find keywords so you can figure out which table they are in:
SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%group%' ORDER BY schema_name, table_name
Yes, Laserfiche Directory Server, thanks.
Priya