Hello community,
I am trying to figure out a method to count a total of specific selected options in a form:
The columns would be the WEEK, each of the 7 days of the week (Monday to Sunday), plus a TOTAL column, the week registers the current week, each day will register either Diet, Cheat and Unknown.
TOTAL is the count of Cheat and Unknown in the form.
The problem I am having is figuring out hot to calculate, update and show the TOTAL, I would like it to calculate and show in the form while I am changing the values of the 7 days of the week in the form.
Is this even possible with appsheet?
Does anybody have a reference video or post on how to count non numerical values from the form?
Is it possible to update a different form field when you change a value of another form field? (example, changing the value of Monday forces TOTAL to recalculate).
LinkedIn
Twitter
