Forms Calculations - Can you calculate data on a table row without leaving behind unnecessary rows after looking up data?

asked on January 4, 2024

If I have a table that returns lookup data and I put a calculation in a field that sums the value of 2 other fields on the row, as data is returned from the lookup the table row size always remains the largest last size.

For example if I return 10 rows, then the lookup runs again and returns 2 row, there will still be 10 rows because of the previous calculations.

Can I have calculations in place only to calculate on the data returned from the lookup and not try to save previous calculated rows?

This is what it looks like when I return 1 row for example after the previous lookup included more rows

0 0

replied on January 5, 2024

Hi Chad, if using Cloud, check again today as there were some fixes about calculations and Tables rolled out last night, be interesting to see if those might change this behavior.

0 0

replied on January 5, 2024

It continued to have the same behavior but I figured out how to do it. If you set the number of rows to be appended by a data source instead of a range, then it always updates the proper table size even with calculations. If you use a range of row 0 to infinity then it does not work.

So you can really have it work however you want, which is great, it just was not obvious since without calculations in a row, both range of rows and append rows work exactly the same.

0 0

Question

Question

Forms Calculations - Can you calculate data on a table row without leaving behind unnecessary rows after looking up data?

Replies

Sign in to reply to this post.