Is there a way to enforce recalculation for calculated value control on form load.
I am using the function sum(text box on repeat section), it does not recalculate when the form loads. It works while editing.
so, reg. sum:
- I really don't see a problem with your scenario. I tested it on my own and it worked correctly.
- have you disabled or hid calculate control or it's enclosing panel?
reg. currentRowNumber - this is, I would say, by design. the function can only be used in formula within a repeating section.
it return current row number of a control you supply as a parameter, not row of a control that holds focus.
it normally works...
can you provide more details/example?
is it connected to a list filed or not?
is your sum inside or outside of rep. section?
what form mode doesn't it work (new/edit/view)?
is it list form or task form?
The control is not connected to the field, I don't want the data saved to appear on the control, it is amount field. The sum is outside the repeat section. I am trying on edit mode. In the new mode there is no existing values to calculate. Didn't try the view mode. It is a custom list. Also I cant use currentRowNumber() in a calculated value control for rules. It shows on the screen , but rules are not working as the value shown.
Yes, the issue was from hiding the panel, it doesn't calculate the total if it is hidden.
glad you sorted it out.
Sojan, consider marking correct answer the post that really helped you not your comment on that. thanks.
Retrieving data ...