Question

Can a table dynamically add rows?

Forms

Updated January 15, 2020

asked on October 18, 2018

We have a customer that has a lookup rule by Employee ID that returns anywhere from 1 to 6 by on the employee.

Is it possible to to have the table dynamically add rows based on the number of rows returned by the Lookup Rule?

We have tried "Range of Rows" and "Append..." set Min/Max = 0/0 through 1/6.

0 0

Answer

SELECTED ANSWER

replied on October 22, 2018

The reason "as new rows" is grayed out is because your "when" condition is looking at the column of another table.

Instead of using a one row "employee" table, perhaps you can just have a section and then use CSS to place the id, first name, and last name fields inline. Then when you configure the lookup rule to trigger based off of the EID value, you should be able to populate the "current position data" table with new rows.

0 0

Replies

replied on October 18, 2018

Hi Jonathan,

If you set your table to 'Range of rows' 1-Min and no max and then use the 'as new rows' in your lookup it should append all the rows returned.

1 0

replied on October 19, 2018

The table is set to "Range of rows" with 1 Min and no max but the lookup rule has the the "as new rows" grayed out.

0 0

SELECTED ANSWER

replied on October 22, 2018

The reason "as new rows" is grayed out is because your "when" condition is looking at the column of another table.

0 0

replied on January 15, 2020

Hi Alex,

Is there any way to activate the functionality to add new rows from table to table based on multiple results? I have a use case where this is a must have to populate one table based on lookups from another.

1 0

You are not allowed to follow up in this post.

Question

Question

Can a table dynamically add rows?

Answer

Replies

Sign in to reply to this post.