I am wanting a small repeating group with a food, you can select quantity and serving size. EX Beef: 1 oz or 1 cup. Each food will have 1-4 options of measurement.
I need to know how to set up my database to pull the correct nutrition information, depending on what is selected.
EX do I set up each food with the nutrition programmed at the basic measurement like per ml or per gram, then when the serving size is selected it multiplies it out (1 tablespoon=15g)
OR Do I enter the nutrition for each measurement separately? If so where and how does it connect? Thank you!
I thought I should enter nutrition separately as I add each ingredient but there is not enough fields, and they don’t seem to connect. Like for this one I tried to add nutrition for “whole pouch” and per ounce, but it wont even show all the choices, and it doesn’t connect to the right one.
I think you have the right idea with a per gram basic unit for nutrition and then you can multiply that for a given serving size. One advantage of that would be, down the line, giving your users the option to generate their own custom serving sizes and still getting an accurate figure.
As far as not having enough fields in the database you should always be abe to add as many as you need. Takes some getting used to but the connections between data types are entirely up to you to create also just by linking them with fields.
Welcome to the forum I hope this helps,
1 Like
Thank you for taking the time to answer. Do you know if there is something I need to do to connect the page choice to the data? Even when all put in for every option, it doesn’t seem to link.
you can have data sent to the page in the same workflow that sends the user there. Or imo it might be easier to just load up all the ingredients and recipes etc on page load. Doesn’t seem like it would be costly as its not complex data. I’m not sure I fully understood the question, feel free to run it by me again if this was unhelpful
1 Like
Thank you for taking the time to answer. I still don’t understand it, but I do have a class with a bubble expert tomorrow over zoom so I am sure he can set me straight. I think you are right, it might need a change in the flow to get there. Have a good one!
