Question

Forms - Modern Designer - Calculations across table row

Forms Forms Layout Designer

Updated June 6, 2023

asked on June 1, 2023

Hello,

Working on a form for a customer that involves some simple calculations using values within the same table row. The field that contains the calculation starts acting weird when additional rows are added to the table. You can see this in the attached video where the calculated field goes blank until you click around a little bit. It'll also display an error message if you click into that field sometimes.

The formula I'm using in that Line Total field is =PRODUCT(INDEX(Labor_Charge.Hours,ROW()), INDEX(Labor_Charge.Rate,ROW()))

The Labor Type field is populated via a lookup, and the Rate field is populated via a lookup based on which Labor Type is chosen, if that matters. Forms version is 11.0.2106.10367

bandicam 2023-06-01 09-18-31-003.mp4 (1.18 MB)

0 0

Answer

SELECTED ANSWER

replied on June 5, 2023

Hi Jacob, I can reproduce the issue on 11.0.2106.10367 but not on 11.0.2212.30907, so it might be a bug that has been fixed. Would you consider upgrade your environment to latest version?

1 0

replied on June 6, 2023

Upgrade seems to have been the fix. Thanks!

0 0

Replies

replied on June 5, 2023

Hello, could it have anything to do with the picklist? It seemed like it worked fine with the first labor and cleaning, but when you added another "labor", it wiped out the amounts.

1 0

View 1 previous reply

replied on June 5, 2023

Looking at the video again, it doesn't look like it's related to the picklist.

I played around with the following and got it to put the line totals in correctly.

=MULT(INDEX(Table_1.Rate,ROW()),INDEX(Table_1.Hours,ROW()))

1 0

replied on June 5, 2023

I changed my formula to use MULT instead of PRODUCT but I'm still seeing the same thing, unfortunately. It's like even though I'm using INDEX in my formula, the Line Total calculation on existing lines gets erased until the RATE column gets filled in on a new line. Once it's filled in, the calculations remain correct in each line, but I still don't want the calculations to disappear like that.

bandicam 2023-06-05 11-59-22-229.mp4 (1.14 MB)

0 0

replied on June 5, 2023

I don't have a lookup set up or a picklist selection, so definitely not the same setup as what you are trying to do.

My only other thought was if your rate and Line Totals are set to read-only. Or there is a default set that it looks at.

1 0

You are not allowed to follow up in this post.

Question

Question

Forms - Modern Designer - Calculations across table row

Answer

Replies

Sign in to reply to this post.