We have a Form that has a sql lookup of the supervisors email. The lookup works and a valid email shows up on the form. After submitted there is an approval process in Forms 9.1 and we are trying to use that email variable in a Task to send an notification of a request that needs to be approved. Using this variable fails. Why? How can I use this variable to notify a supervisor of a pending approval? This needs to be a variable as we have over 100 employees that have different supervisors. The lookup is keyed to their employee id and pulls their current supervisor. Thanks!
Question
Question
Answer
The problem is that you are using an email address to try and assign a user task. User names in Forms and Laserfiche do not use an email address format. The variable needs to be the same format as the user name in order to have a user task assigned correctly. We currently take the email address and do a database lookup to find the supervisors username in our system that is the same as the username in Forms. This way we are able to assign the user task to them.
Replies
This is a big feature request for us! Our usernames are not super straight forward, so I don't want to ask people to enter their supervisor's username because it will probably be incorrect.
Its way easier to ask them to enter the email address of someone and have LF Forms resolve who that is in the AD.