I have one tab to which you can add any food you’ve eaten on a given day.
I can’t make the vlookups in Google Sheet because when I’d add a new item, it would be added below and the formular would not apply. Screenshot by Lightshot
So I made a relation + lookup in Glide. Now you can add food and how much and it will calculate how many calories you’ve eaten.
=> However in another tab I need the sum of consumed calories in a day. Screenshot by Lightshot
a) any way to make the data from Glide formulars also appear in GSheets?
b) any way to make a sumif date=today then sum calories.
is there an option to add search functionality to the choice item? Going through hundreds of foods to find the ingredient you ate today is a bit inconvenient
Thank you so much, this is (hopefully) the last piece!
To my knowledge, there’s no way to create GSheet columns from original Glide Data. If you need to have all the data in your sheet, the VLOOKUP can still work if you first sort the data within the formula. Something like: =VLOOKUP(__,Sort(_____),__ ,False)
However, to do a sum by date within Glide is a bit tricky as the rollup tool doesn’t allow you to reference a second column. So, do this:
In a second sheet, create a column of unique dates ( =unique(LogSheet!B2:B))
In Glide, go to that sheet and create a multiple relation between the unique dates sheet and the log sheet:
You now have a tab that will sum by date dynamically. Build out this tab in your app! Bonus: in the details view of the inline list, create another inline list component with that relation column to get the items that constituted that total:
Ok I am officially mindblown. This is some glide/gsheet magic. One thing though: I don’t need it in a list like you have, in this case I’d only need the current day!
Or you could do if it’s today, then “Today” (or anything) else blank and then filter by “is not empty”. Personal preference.
Now, the only limitation is that Today() and Now() formulas don’t auto update the app, so tomorrow it will still think it’s “today” and show the totals from the previous day until a new form entry is submitted to create the new date and there by update the app. If you have a Pro app, then this is a non issue as you can have the Glide app refresh “every few minutes in the background”.
@JackVaughan …another situation where a “current date/time” column would come in handy
Hm, maybe i am missing sth. the sum happens through the rollup in glide. so yes, could sorta blend out all the other days which are not today. however, I need the specific value (sum of calories) from that sheet/tab in another tab.
so blending the others out to make that one appear is unfortunately not helping. out of all of them, would need to pick the one for today and get that into another tab/sheet.
Ok. So, are you simply wanting to take the “sum of today” and use it as value in some sort of “today dashboard”? Where is this value going and for what purpose?
Ok…I think all you have to do is create a relation to the Today() column (seen here as "new Column) in your dashboard by creating a column (either in the spreadsheet or as a template column) where the value is persistently “true” (seen here as “TodayTrue”). So, the relation will only ever refer to “today’s data”.
Then do a lookup of the sum calories (New Column 0):
One more thing though came up (sorry). Since I am doing more math now in Glide vs Sheets, any way to round results? Currently getting results like “433.23423423kcal burnt” which obviously doesn’t look nice.
