Question

Forms SQL Lookup configured but fields not populating

Forms

Updated July 16, 2018

asked on July 16, 2018

Hey guys, I'm having an issue with a SQL lookup I have configured for a Form. Basically I have a custom SQL table that contains vendor data (mainly Vendor Number and Vendor Name). On my Form, I have a lookup rule that when the Vendor Number field matches data with the VendorNumber Column in my SQL table, fill out the Vendor Name field with the data in the VendorName column from the SQL table. I have done this several times before so everything is configured correctly as far as I can tell but when I test the process....the Vendor Name field won't populate.

Here's my Data Source configured:

Here's my lookup rule:

Here's my sample data from SQL:

And here's the results:

So I can confirm the data source found the Database AND the lookup rule can even identify the correct table and columns....but for whatever reason the lookup won't work.

Also, I'm building all of this using our VAR demo license....I don't know if that has any restrictions on lookup capabilities but wanted to clarify.

0 0

Replies

replied on July 16, 2018

Hi Grant,

Are the Vendor numbers going to be unique and only based on what is on the DB? if so, why not do the following:

1. Have the first lookup rule to fill the Vendor number > based on your screenshot i have highlighted what you do to remove it and just fill the field with data

2. Keep the rule you have as it is then checking if the field is matching, populate the Vendor name..

Let us know how you go with that, that is the way i usually set it up

Regards

Ziad

0 0

replied on July 16, 2018

Hey Ziad, I removed the condition and just left the "Fill Field with Column Data" option and no luck...

now the Vendor Name field isn't a drop down field so I don't know how that lookup rule is supposed to interact with just a single line field but I tried clicking into it just to see if it would give me options but nothing happened

0 0

replied on July 16, 2018

Hi Grant,

Not sure if this is something you have checked, as you are using the VAR demo, you have the option to use Forms Essentials or Forms Professional.

Have you selected Forms Professional in this instance? As that would provide you with the DB lookup options.

I cannot see why it would not function apart from that at the moment.

Another thing I would do is try to re-create the rule all over again, a single line field should give you the drop downs of the field you want to fill from a DB.

As in, when using "Fill Field" for a single line field, when you select that field with the form, it would then give you the list of all available in the DB column.

Thanks

Ziad

0 0

replied on July 16, 2018

Ok so I tried removing the rule, saving, then re-adding the rule. I also tried making the fields not required and even changing the table to another custom sql table but still couldn't get the fields to populate.

I even tested it out directly on the server and it still wouldn't populate...it's weird that the rule can see the Table and Columns perfectly but won't perform the lookup when tested.....I'm going to test it out on IE instead of Chrome and see if that works

I may end up having to open a ticket on this one....

0 0

You are not allowed to follow up in this post.

Question

Question

Forms SQL Lookup configured but fields not populating

Replies

Sign in to reply to this post.