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

Question

Question

Display lookup data

Forms
Updated December 8, 2017
asked on October 6, 2015

Using Forms 9.2

I'm looking for ideas to display data retrieved from a lookup.  A table seemed like the obvious solution but it doesn't seem to handle multiple rows.  Rather than populating table rows with the results of the lookup, I get blank text boxes.  Clicking on those boxes shows the results of my lookup for that column.

A basic rundown of my case:

  1. User supplies their account number
  2. Forms does a lookup displays all the associated property (description, price, etc)

 

How would you tackle this?

Thanks!

1 0

Answer

SELECTED ANSWER
replied on January 15, 2016

Hi there,

Populate Table field with multiple return results from DB lookup is supported in Laserfiche Forms 10.

1 0

Replies

replied on October 8, 2015

Hey Erik,

If you're just looking to make it more 'obvious' that the properties (desc., price, etc.) need to be selected, try changing the field types to drop-down lists.  The lookup will populate the drop-down with the values supplied from the database.  If your concern is dealing with the multiple rows - the database must know what result to return, if there are multiple, it doesn't know what value you want to return.  In that event, you will need some other type of value (Static or user entered) that will determine what row to select.  

 

Hope that helps!  

Nate

3 0
replied on October 16, 2015

If your concern is dealing with the multiple rows - the database must know what result to return, if there are multiple, it doesn't know what value you want to return.  In that event, you will need some other type of value (Static or user entered) that will determine what row to select.  

 

This is exactly it.  There will be multiple rows and I need to return all of them.  

The use case is a tax filing system.  I want to give them a list of all the property we already know about from last year.  Then the user will enter new taxable property, report property sold, etc.  

I would like to display that list in a multi-row table, but I'm open to easier ideas.

Thank you Nate.

0 0
replied on October 16, 2015

I believe something is being worked on with Forms 10 to accommodate the need of bringing back multiple rows from a database lookup to populate a Forms table field with multiple rows.

1 0
replied on December 8, 2017

I have something like this in a currency calculation table.  My VAR came up with the following Javascript and it works great.  

 

$(document).ready(function () {
  $('[name="Field70(1)"]').val(1);
  $('[name="Field70(2)"]').val(2);
  $('[name="Field70(3)"]').val(5);
  $('[name="Field70(4)"]').val(10);
  $('[name="Field70(5)"]').val(20);
  $('[name="Field70(6)"]').val(50);
  $('[name="Field70(7)"]').val(100);
});

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

Sign in to reply to this post.

Details
Related Posts
Loading ...