Question

Form- Using of Look Up Rule

Forms

Updated April 11, 2014

asked on February 10, 2014

Hi,

I am wondering is their anyway to automatically retrieve two or more data in SQL and fill that details in the table using the Look Up Rule. For example I have a Company Name "A" and had 2 contact persons and I want to fill in my form using their Company Name which is "A" and retrieve the data's and automatic fill their full name in the table.

Thanks,

Cherry

Form 1.PNG (96.04 KB)

| Download

2 0

Answer

APPROVED ANSWER

replied on February 10, 2014

Hi Cherry,

In Forms 9.1, lookup feature does not support automatically fill in multiple rows in table based on return results. We're planning to have this feature in future release.

Thanks for your feedback.

Abby

0 0

Replies

replied on February 10, 2014

The only way I've had luck with this setup is to use hidden fields, then use javascript to update the table when the hidden fields are filled. I haven't been able to have it fill out a table directly. I'm hoping the SDK will provide some other ways to do this.

0 0

replied on April 10, 2014

Chris,

Do you have the Javascript to populate the rows of a table from the hidden fields when they are filled? Any help is greatly appreciated.

Thanks,

Lance

0 0

replied on April 11, 2014

I usually use the val() function.

$('#unhidden1').val() = $('#hidden1').val();

0 0

You are not allowed to follow up in this post.

Question

Question

Form- Using of Look Up Rule

Answer

Replies

Sign in to reply to this post.