Nutrition database

[Welshgasman]

No, not yet, on my phone. Not going back to my laptop until tomorrow.

[DMT Dave]

No worries, although not VBA related this conversation with yourself and Edgar, both have given me some useful info

It is a world of learning with diabetes

Mine is jumping so quickly from lows to highs, I have a 2.2 low and came back from Mexico honeymoon feeling very unwell, sugar reading was 32, should be between 4 and 9...

Manage it and move on now

Can't thank you guy's enough for all of your help with all subjects, have a good evening

[Edgar]

I'm glad I could help, even if just with words.

I guess the ideal app should have this workflow:
1. login
2. gets results from previous captures
3. add new record
4. meals section
4.1. if choose existing meal, then load the latest used nutrition data for that meal, let the user edit
4.2. if add new meal, then call the api and load the nutrition data for that meal, let the user edit
5. physical activity
5.1. same with meals, but for physical activity
6. insulin section
6.1. choose target, calculate automatically based on physical activity and food intake? maybe also sugar reading?

I think physical activity should be a part of the formula. But I'm just guessing.

[kd2017]

FWIW the USDA provides a nutrition db free to download. They provide it in excel, cvs, and access format, though if I remember correctly I think they are phasing out the access db??...
Anyway, you can also get a free api key to access the data online. I used it as an excuse to learn qt for python to make a meal planning app a few years ago

https://fdc.nal.usda.gov/

[Welshgasman]

Yeah, phone spreadsheets are a nightmare. An app is better. If any of you have a link to a formula, maybe I can create a web app you can use from your phone.

Also there is the fact that VBA will not run on the phone.

[Welshgasman]

WGM have you downloaded mine ?, I have never used VB in Excel but if it's as easy as Using Sum, Avg Max functions etc, i can use those in Excel calculating the cells etc

I have seen VLookup etc in excel but never tried any VB work

Your DB is along the same lines as mine. More detailed as you need the sugar levels etc.

[DMT Dave]

Thank you guy's all of this helps massively, the world doesn't share enough to help each other like on here

[Welshgasman]

You might also want to take a look at MajP's FAYT classes, that turn a control into a fayt control with two lines of code.
Post #4
https://www.access-programmers.co.uk.../#post-1867654

[DMT Dave]

Thank s WGM, will take a look

[Welshgasman]

Thank s WGM, will take a look

I just added it to mine. Makes finding the food in the combo so much easier.