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

Question

When Auto Fill / Look-Up Returns No Values

Forms

Updated November 10, 2017

asked on January 15, 2016

Hi.

I have a look up on my form. If the end user enters correct information, the look-up turns a value.

Is there a way to inform/msg the end user when the information is incorrect and there are no values to look-up?

For example, a message that says - Sorry, but we couldn't find any information for this look-up.

Thanks in advance

0 0

Replies

replied on January 15, 2016

How familiar are you with Javascript? Typically, when a lookup executes, it triggers a javascript Change event for each of the "filled" fields. Even when your lookup returns no value, it populates the filled fields with a blank and triggers the change. You could write an event handler to catch this empty field on a change event, then display a message with an alert() or some other dialog of your own design.

0 0

replied on January 15, 2016

Hi there,

If you lookup to a single line field. You can use Stored Procedure to return the message to the field.

0 0

replied on November 10, 2017

I am new to LF forms. I'm working on a form with username, password, and autofill button (renamed to Search) that if it returns no records then I want to show a message that the username and/or password is not valid. What route did you use to fix the lookup? Javascript, stored procedure, or something else? Thanks!

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.

Asked January 15, 2016
Updated November 10, 2017
191 views