You are viewing limited content. For full access, please sign in.

Question

Question

Querying Active Directory Groups in Forms

Forms
Updated October 21, 2014
asked on May 14, 2014

We would like to populate drop-down lists with users that are in a specific group in active directory.  This doesn't seem possible with any built in functionality in Forms.  Is this possible some other way, like javascript, that anyone has implemented?  Also, is this something that could be implemented in a future version of Forms? 

0 0

Replies

replied on May 15, 2014

I'm not sure if it is possible using JavaScript or not. One thought would to schedule an export of the specific group to a csv file and then have that imported into a SQL or Oracle database. Forms could then do a database lookup to populate the drop-down list. SQL Agent could do the import into SQL, but you would have to find a way to schedule the export.

1 0
replied on October 21, 2014

AD lookup from forms would be excellent feature to have available.

 

I got around this manually by creating an excel spreadsheet with appropriate columns i.e. user id etc.

Then created another sql database and added this table. Then used the lookup rules.

 

 

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...