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

Question

Question

Does a lookup work on a user task?

Forms
Updated April 11, 2016
asked on April 6, 2016

Hello,

In a user task, I have a SQL lookup to find the rank of an employee.  The rank returns, then depending on rank with a field rule, a drop down list of users is populated.  A reviewer of the form can choose who to route the form to next.  This works just fine on the initial form, but once these fields are put into a user task, the look up doesn't seem to do anything.  I'd like to know if this is possible, and I have an error in my configuration, or forms doesn't have this functionality.  Thanks,  

Scott   

0 0

Replies

replied on April 6, 2016

It should work, are you sure to use the same form and not another one for that user task.

I use a lot of SQL lookup in some of my forms and have not seen your issue.

 

I also create 2 different form and the starting form has it is own lookup versus the next user task form that have a copy of the starting form but with different information, use another sql lookup table to do another specific task dedicated to that user.

 

0 0
View 1 previous reply
replied on April 6, 2016

It is a different form that was copied from the original starting form.  The look ups have been modified, and I have looked at them a number of times and they seem correct.  Just not getting any data back.  I am waiting for a minute or so, since on the original form it takes a number of seconds to perform a lookup in v10.

0 0
replied on April 6, 2016

Do you have an issue with using the {/_currentuser_display} token?

0 0
replied on April 8, 2016

No, well I do see any issue using internal variable.

Did you look up return a big list of data.

 

because the bigest delay I see is if I do a look up to populate a list field or to get able to shoose from a list the value for a field.

 

if the list is really long , the upload time forms take more time.

0 0
replied on April 11, 2016 • Show version history

So upon further testing it does seem to work properly, however, this is only from the server.  I'm currently connected via VPN to our Forms server, and this seems to be where the slow down is.  I timed the lookup from my desktop and it took 28 seconds.  From the server, it was much quicker.  

Seems as though others have the same issue http://answers.laserfiche.com/questions/87832/Forms-10-Lookup-Fields  with a few threads on it.  The update didn't change the speed for us.  

 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...