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

Question

Question

lookup not consistent in forms

asked on December 1, 2017 Show version history

I have found that I am not always getting the results of my field lookup for email addresses in my form.

 

Use case:  The user identifies themselves as the one who completed the form by selecting their name from the 'Completed By' drop down.  This 'Completed By' drop down is populated from an HRExtract SQL table.  When that selection has been made, a second lookup fills a hidden field with the user's email address which is from the same HRExtract table.

On some forms this email field gets filled and on others it does not.  I have not been able to identify any other commonalities among those that do/do not show the email.  I do have the hidden field set NOT to ignore the content when hidden.

12-1-17 formnoemail.PNG
12-1-17 formnoemail2.PNG
0 0

Replies

replied on December 3, 2017

Hey, I have a few ideas on what could be causing this. Could you post your forms process? Also is there a reason why do you need this value stored in a hidden field? The submitter email address is available by default after the form is submitted.

0 0
replied on December 4, 2017 Show version history

The users who are submitting this form consist of users with dedicated named user logins and those who use a generic login account.  Since I could not consistently use the submitter information to communicate to those users who operate under the generic account, I pull the information from my HRExtract which has their email address.

12-4-17 FHP process.PNG
0 0
replied on December 4, 2017

Ok so it wasn't what I thought it was. I did try to reproduce it but it worked fine :S. Here are a few questions/ideas that may help. 

Have you turned on the SQL profiler to see if the lookup is being called?

Have you checked if this issue is triggered by a specific browser(chrome/IE)?

The lookup that is performed to get the email address does it only use the name or is there a second variable?

Is the field set to read only?

0 0
replied on December 5, 2017

Have you turned on the SQL profiler to see if the lookup is being called?

          Not familiar with this will have to look into how to use it.

Have you checked if this issue is triggered by a specific browser(chrome/IE)?

          Currently using IE to enter these. Tested with Chrome and it did populate the field. 

The lookup that is performed to get the email address does it only use the name or is there a second variable?

           Only uses name.  But, the name is obtained from the same table when the user chooses the person completing the form.  So there should always be a match.

Is the field set to read only?

           Field is NOT read only.  Setting when hidden is set to 'Save the data when the field/section is hidden'

0 0
replied on December 5, 2017

Hmmm, the profiler will help work out if its a laserfiche issue or not but if you can't reliably trigger the issue then it will be hard to gain any insight.

The other thing you could do it add some javascript to the submit button click event that prevents form submission if the value of the hidden field is blank, maybe also display an alert or something to inform the user why the submission didn't go ahead?

If that's something you think would help I can assist with the code for this.

0 0
replied on December 6, 2017

Aaron, I'd be interested in looking at the submit button click controls on the value in the hidden field.  Thanks.

0 0
replied on December 6, 2017

Hey,

The code is pretty simple. Give this a shot and see how you go.

$(document).ready(function() {
  $('.Submit').click(function(e) {
    if($('#q1 input').val().length > 0)
    {
      
    }
    else
    {
      e.preventDefault();
      return false;
    }
  });
  
});

You will need to change the selector for the hidden textbox but that should be it.

1 0
replied on December 7, 2017 Show version history

I'm not yet a javascript novice, so this will be a first!  I'll give it a try and let you know how it goes, thanks Aaron!

 

I would still like to know why my lookup is working intermittently, in IE.  Since it's our corporate standard, I really want to make sure I don't have to put similar javascript in for all lookups of this kind.

0 0
replied on December 7, 2017

Are you running the latest version of forms?

0 0
replied on December 8, 2017

Running 10.2.0.789 Forms, not 10.2.1 update 2 yet.  I've got 10.2.1 update 2 in my test environment but haven't yet updated production.

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

Sign in to reply to this post.