cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamically hiding table row depending on input in prompt

Former Member
0 Kudos

Hi All,

We have this requirement where we have to provide a user prompt with comma separated values in input.

Like:

Please enter Type: ABC; XYZ;

Then we have to show value for these type in horizontal table rows.

If user didn't provide any input, those rows should stay hidden. This table contains other rows too which are fixed.

Any help will be appreciated.

Regards,

Shrutika

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

As shown in the following image.

First row total will be sum of all the values in the first column except date.

And the 3rd last row 'Total credit lines available' will be sum of values of last 2 rows.

I want to dynamically hide/show the last 2 rows, depending on the user input from the prompt.

Regards,

Shrutika

amitrathi239
Active Contributor
0 Kudos

Hi,

One Option is to use two tables.One for last two rows.

Right click on the second table Format-table->General-Checked the option Hide when formula is true and put your user response condition there.

sample =UserResponse("Year")=""

If user will not enter any value then second table will hide.

After that use relative position to  bound these two tables together.

Amit

Former Member
0 Kudos

Hi Amit,

It solved my issue. This is exactly how I wanted it to work.

Many Thanks

Regards,

Shrutika

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

Hi,

Share your table screenshot.

Amit