Question

Could not find user's account information (except user name,name,e-mail) in forms?

Forms Workflow

Updated May 20, 2015

asked on May 16, 2015

There is a requirement that a starting form which's sent from employee of a department would be send to approve by the manager of that department.

So I need to know the information from AD such as department of initiator for routing the form to the right manager

This is what I found from edit form page.

And I found this optional properties in LF Workflow.

How could I get the AD's other information from LF Forms?

Or I have to fetch out others values of AD 's information from LF workflow and fecth in the values into LF Forms.

What is the right way to accomplish this?

Any suggestion would be greatly appreciated.

0 0

Answer

SELECTED ANSWER

replied on May 20, 2015

Currently Forms does not have the ability to pull information you need straight from AD. The functionality that you are describing can be achieved by a SQL lookup but the SQL table with the information you need needs to be created first. I found this Stack Overflow article online that may help you build the table you want.

Information about how to create a SQL lookup in Forms can be found here. I would recommend using the initiator's name to trigger the lookup, which can be prepopulated using the variable, {/_currentuser}.

1 0

Replies

replied on May 18, 2015

Forms should be automatically retrieving information such as email addresses from AD. It appears that your Administrator trustee does not have any information assigned to it on the AD level, so make sure the details exist in AD before you proceed.

If you are using Laserfiche named users, you can specify their email address as a user attribute in the Admin Console. Users can also change their user information on the Account page.

1 0

View 2 previous replies

replied on May 18, 2015

Hi Cathy,

you could see from my screenshot of Edit page that I can retrive some AD information as

1. user name

2. name

2. email

from LF Forms because there are variables for reference.

But the other AD information such as

1. First Name

2. Last Name

3. Title

4. Department

5. Company

There are no such variables on the Edit page or the Account page.

But I can find the other variables from LF Workflow on optional properties tab.

If I need to use the Department or the Title value from the AD information to be display or reference on LF Forms.

How could I do that?

Or do I have to fetch out information from LF Workflow and then fetch in LF Forms?

Please suggest the right way to get these information.

Regards,

0 0

replied on May 19, 2015

You could create a SQL lookup (you would need to create a SQL table with this information in) to retrieve this information first before the form is submitted, which then can be used as variables within the Process Modeler.

0 0

replied on May 19, 2015

Please describe for more details to accomplish this.

How could I retrieve AD information into table?

Do I have to trigger this from a workflow?

Regards,

0 0

SELECTED ANSWER

replied on May 20, 2015

1 0

replied on May 20, 2015

Hi Cathy,

Thank you for your additional information.

Regards,

0 0

replied on May 20, 2015

Hi there,

If anybody has ever pulled AD information using workflow please share.

Thanks in advanced.

0 0

You are not allowed to follow up in this post.

Question

Question

Could not find user's account information (except user name,name,e-mail) in forms?

Answer

Replies

Sign in to reply to this post.