I am trying to create an app that will help me have a running total on a weekly basis of fruits and vegetables consumed. Is this possible? It could contain a list of many fruits and veggies to choose from (would I put them in ABC order with each letter being a different tab?) and what would the formula look like to tally an ongoing sum?
When I try to do a checkbox then weird true/false values take over the title of the fruit/veg…
I’m stumped…
You should start designing your sheet first. This of course will be as per you envision your user interface. So as I read following will become your sheets.
Food master list - name, type, etc
Person - people who will eat these
Consumption - person id, food item Id, date and time of eating, etc
Your sub total and total will be derived from consumption sheet.
there are multiple ways to do this. its all based on how you want the user to view and input info. i would assume your first sheet would allow users to add a list item.
Layout: List, compact or tile view
Feature: filter by signed in user (settings privacy: public with email)
other: Add and edit
Filter this by signed in user.
Once you allow add, click the plus and add components for questions. Ask for the fruit and veggie (choice component), date (special value), how much eaten(text entry for each) and user email (special value). Also add a column to calculate with formulas in the sheet or math in the data editor. Add column to calculate days. Each of these are a separate column on the sheet.
This way you have one sheet so far for all users.
a choices sheet for a list of fruit, veggies and any other multiple choice question you may have(separate column). you can add an A to Z sort in the choice component to alphabetize your fruits and veggies from the app, no matter what order they are in, in the sheet.
You can use another sheet to add lists by weeks or add a filter or visibility condition by date on the first sheet.
This is the simplest way I can think of. Hope it helps.
Thanks for the great suggestions - feel like looking at this app 30 Fruits/Veg/Greens Per Week (https://eat30.glideapp.io) and giving me an idea about how would 1) write the formula to track how many fruits, how many veggies, and how many greens (not just the sum of the three) - as kind of a concurrent tally - and 2) how to have the value reset to zero on sunday at midnight so that i can start the tracking of the 30 per week again, and 3) is there a way to store the data on a weekly basis for future analysis?
Thanks for the great suggestions - feel like looking at this app 30 Fruits/Veg/Greens Per Week (https://eat30.glideapp.io) and giving me an idea about how would 1) write the formula to track how many fruits, how many veggies, and how many greens (not just the sum of the three) - as kind of a concurrent tally - and 2) how to have the value reset to zero on sunday at midnight so that i can start the tracking of the 30 per week again, and 3) is there a way to store the data on a weekly basis for future analysis?
I heard that I should be asking someone named George Burnabeck (sp?)? for help with that number 2 question above…If anyone wants to lend a hand though I’d take help from anyone!
You should be able to do something like a form button to submit each fruit/vegetable eaten to form response sheet along with a date timestamp. Then create another sheet and use a query to pull values from the response sheet that fall within the current week. Then in your tally sheet, you can use a simple COUNTIF to count the number of fruits/vegitables in the sheet that contains the query. Looks like Glide has a count function on the way that may work for this if you’re willing to wait.