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

Question

Question

Rows in a Table

Forms Version 9
Updated March 15, 2016
asked on March 11, 2016

Hello,

I'm wondering if there is a way to display a variable number of rows in a table, based on a variable pre-populated from a lookup.

For example when a user logs into the form my variable acctcount populates from a look up, I would then like the table to dynamically display rows equal to my acctcount variable.

Is something like this possible through js?

Alternatively, I've been reviewing js code on here that would 1) count the number of table rows and then 2) validate them against my acctcount variable and display an error message if the result is !=.

I'm open to all suggestions! 
Thanks,

Melissa

1 0

Replies

replied on March 14, 2016

Hi there,

Can you show an example using a form screenshot?

0 0
replied on March 15, 2016

Hi Abby,

Here is screenshot of my form.  We have a look up that is populating the drop down "Brokerage Accounts" field.  I'd like the Account numbers that are returned in that field to be used as my row labels in the table.

I know this functionality exists out of the box in LFF 10, but I need a work around for the time being prior to our upgrade schedule.

Thanks for taking a look!

 

Table example.png
Table example.png (45.39 KB)
Download
0 0
replied on March 15, 2016

This is doable with database lookup.

Basically you will create a table to fill the Table row data based on the value of the Brokerage Account dropdown

0 0
replied on March 15, 2016

I think I understand what you mean, but it's not quite what I'm looking for.  I think you are saying that I can place the look up values as a drop down in a table field (as opposed to outside of the table).

I would like all rows (the number will vary, based on number of accounts) to display once the look up is completed.

I've been referencing these two posts in an attempt to troubleshoot.

 

https://answers.laserfiche.com//questions/55591/Populating-a-table-with-a-sql-lookup-values-via-dropdown-options-without-user-interaction

https://answers.laserfiche.com/questions/48840/Populate-Table-Row-Label-with-Look-Up

Can I make the account numbers a row label?  How would I go about that?

0 0
replied on March 15, 2016

You will need the one outside of the table.

Once user select the field outside of the table (Lookup When criteria), the lookup rule will populate the table column with the value based on user's select outside of the table (Lookup Fill action).

It's not good to put that value as Table label, because Table label is not a data get submitted when you submit the form, which means you won't be able to use it later in the process. So it will leave you a table with each row with no account number.

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

Sign in to reply to this post.

Details
Attachments
Related Posts
Loading ...