I'm trying to sum the totalorder field from a list of documents in my Orders subcollection. I've set up a loop using an Action Output from a Firebase query that filters the documents by today's date.
In the loop, I want to update a variable (totalSum) by incrementing it with the totalorder field from the current document in each iteration. However, when I try to set the increment operation, FlutterFlow is asking me to "Filter List Items" again instead of just allowing me to select the totalorder field directly from the Action Output.
How can I correctly set up the loop so that I can increment totalSum using the totalorder value of each document in the loop without needing to reapply filters? Am I missing something in the setup?
Thanks in advance for the help!