Add Rows to Form

By - Updated May 28, 2015

In Kepion, we can use an Add X Rows rule to create dynamic forms which will allow users to add rows to the form as needed. The video below shows how it works.

The trick behind this form is Hide Empty feature. Let’s take a look at the row definition first.

When Hide Empty Rows is turned on, the form will only show rows that contain data.

Therefore, what we need to do in the rule is to add some data to the rows that we want to display. In this article, we will introduce how to configure this rule step by step.

Let’s first create the SQL rule together. We will need to define two parameters in this rule. If you are not familiar with rule parameters, please refer to¬†Use Parameters in SQL Rule

In the DEFINITION tab, we gather the filter selections, and pass them and these two rule parameters together to the stored procedure.

In the stored procedure, we find the row LineItemIDs and insert a value to those LineItem so that they will show up in the form.