Hi, I create the app which will be possible to summarize the quantity if details. My SharePoint list looks like this:
The task is to summarize the total quantity (DataCardValue22) of details continuously during a day. For example, for work order 00000333"1+32+51+49=131" etc.
To solve it I created a "TextInput" in the EditForm for new values and created an "Add" button. OnSelect of this button has such formula:
The formula works good. there is no problem with summarizing but the problem is that the total quantity stays the same for each work order when I open an EditForm - in other words, for each new work order the total quantity equals to the last calculated value.
Please help, how can I calculate the separate quantity in accordance with the proper work order?
Should I use any Filters or Patch function?
Please if you have any ideas give a feedback.
Also see the attached images for more information. Thank you!
Thank you for your advice, but that is the problem - a can't just reset this information because I need to make some changes in my EditForm and each total quantity must be summarized. The issue is to make a conformity between the total quantity and the appropriate work order 😣
If you have time please look at the attached images - the first is my DetailScreenForm which is used to make changes with already inserted data. When I press "Edit" button I come to my EditForm and as you can see the "accepted" field is not equal for these both screens - for EditForm this quantity is equal to the last total quantity, as you mentioned before.
How can I save this quantity in accordance with its workorder? Is it possible?