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

Question

Question

Forms - Quick way to delete last row in table

Forms
Updated March 28
asked on March 28

Hello,

I have a customer with a form that has multiple tables on it that are populated by lookups. Sometimes, they want to delete certain rows from these tables, which works great when there's more than one row - they can click the X on the far right side. However, when there's just 1 row in the table, there's no X to click, and they'd have to clear out each column manually. Even then, there are hidden columns that still contain data that we don't want to submit. Is there a quick way to delete that last row? Forms version is 11.0.2307.40556.

Thanks!

0 0

Replies

replied on March 28

Check your table configuration and make sure to change the minimum for your range from 1 to 0 allowing them to delete all rows.

1 0
replied on March 28

Wow, that might be all I need. There is a column that a field outside the table references to sum up all the values in that column - it looks I need to include an IF statement in the formula so it only runs if that table field isn't empty as it's throwing an error now with 0 rows. But I should be able to figure that out. Thanks!

0 0
replied on March 28

Here's a screenshot of the form:

The "Grain Total" field totals the "Amount Due" column in the Ticket Summary field. If I set the minimum number of rows in the Ticket Summary field to 0, I get this error in the Grain Total field. I've messed around with some IF formulas but can't get anything to work. Anything stand out to you?

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

Sign in to reply to this post.

Details
Related Posts
Loading ...