Possible bug: repeating group + input

Need help Database
1

Hi, I might have found a possible bug.

I want to do a simple invoicing app

My data is:
ListPrice (the list price of the item)
DiscountPercent (% of discount)
DiscountReverse (the % opposite of discount. helps with calculation. i.e: if DiscountPercent =30%, DiscountReverse = 70%).
PriceEach (=ListPrice * DiscountReverse)
Quantity
PriceTotal (=PriceEach * Quantity)

I would like to show a repeating group with all these fields as input boxes

for each input box, there is a workflow of the type: When ____ is changed --> run the calculation

all the calculation formulas are fine, checked with the debugger

I consistently have issues with the PriceTotal field. The field is calculated fine and saved correctly into the database, but the value shown will only update once.

how to reproduce the issue:

change the value in the “quantity” field once --> the PriceTotal field is correctly updated
change the value in the “quantity” field again --> the PriceTotal field is no longer updated

I have added a second PriceTotal field and this is correctly updated. If I delete the misbehaving one, then the second will break.

any thoughts?

2

Do you mean the updated value doesn’t turn up in the database? Or in the text field, or in the input field?

I noticed that your PriceTotal input fields are editable, and the calculation no longer updates it after the user changes it. To force an update to override the manual edit, put the PriceTotal field in a group, and reset the group. The input field should then go back to using its Default content.

1 Like
3

if I change the “quantity” value, the PriceTotal value turns up correctly in the database and in the text field, but it doesn’t turn up in the input field.

I’ll try your suggestion with the group, thanks!