I have a form where users enter items into a numbered list. I want the total number of items entered into that list to appear in another field as they update it. This can easily be accomplished using a Default Value of Count(List)
HOWEVER
I would also like the user to be able to override the total field with their own value, in case entering that many list items would be impractical. For example, they might write "1 through 100" in a single line on the numbered list, and then go and change the Total field to 100 instead of the 1 that is being calculated.
The issue arises when the form is reopened after submit, and the default value is recalculated back to 1 as the form loads, even though the user submitted value of 100 is still stored. My thought was then to set the Total value with a rule on the numbered list, instead of using a default value on the total, and trigger the rule "when the field changes"
The problem is the rule won't work correctly, as the Count will always return a value of 1 if it is set to run "when the field changes"
The same rule applied to a button works with the expected result, but this is clunky and not aesthetically pleasing.
Am I overthinking this? How do I get the form to total up a numbered list as it changes in real time (and allow the user to change it), but not on form load?