Can I get guidance on setting up a Meal By Meal Day by Day self calculating Calorie Counting jotform please?

  • IanRm
    Asked on September 14, 2019 at 7:16 AM

    Hi I want to create a Form with a series of Dropdowns containing list of Food items to generate and calculate Calorie intake 

    1) Can I achieve Calculation in conjunction with Dynamique Drop down Widget?
    If not how else might I approach this challenge please?

    I was hoping that one form would cover a weeks input (7 days) and be summarized / totaled for one week Calories Per day totaling to Calories per week etc.

    I was hoping to enter the attached food items into some form of drop down or dropdowns where I can select the food consumed and the amount of that food and that the form would auto calculate the calories of that component of that meal. and then at intervals subtotal the Intake Per Meal and Per Day And total for the week.

    Attached is an example of the core data that I'm starting with. Important to note that In Jotform I want to be able to enter the VARIABLE serving size per food item in each meal or snack and for the form to sub total and total calorie intake?

    no url supplied as I'm still planning / discovering how best to approach thsi in JOTFORM?

    Jotform Thread 1964197 Screenshot
  • AshtonP
    Replied on September 14, 2019 at 9:06 AM

    You may not be able to achieve this with Dynamic dropdown however it can be achieved with the standard DropDown field. Dropdown menus with calculation should help you create what you need.

    Let me know if you want me to design a sample form that can help you develop your own version of the calorie calculation form. 


  • IanRm
    Replied on September 14, 2019 at 9:46 AM

    Yes please AshtonP absolutely -  as i'm a novice in this regard.

  • roneet
    Replied on September 14, 2019 at 10:12 AM

    Let me work on your requirement and get back to you.

    Thanks.

  • IanRm
    Replied on September 17, 2019 at 3:39 AM
    just checking in to discover if this sample form worked out for you?
    roneet or AshtonP?
    Kind Regards
    Ian
    Ian Mullen
    Ross Print Services, 5 Applewood Drive
    Greystones, Co. Wicklow A63 V208
    *WWW.ROSSPRINT.IE *
    *T: +353 1 287 6612*
    M: +353 87 255 4216
    ...
  • roneet
    Replied on September 17, 2019 at 4:31 AM

    Sorry for the delay. As promised here is a Demo Form:

    https://form.jotform.com/92578263933973

    1. Added an Input table in the Form to add the Calories count and items.

    2. Added a Form Calculation widget to sum up the Calories.

    Can I get guidance on setting up a Meal By Meal Day by Day self calculating Calorie Counting jotform please? Image 10

    Result:

    1568709012form Screenshot 21

    Let us know if you have further questions.

    Thanks.

     

  • IanRm
    Replied on September 17, 2019 at 6:39 AM
    Hi - Thank you but what we are after is A DROP DOWN
    Where depending on the associated linked value of the food item another
    field will be populated
    Egg for example x 1 = 80 (Calories)
    Bacon x 2 - 180 (calories
    AN ITEM A QUANTITY = Calorie Value
    All items to be selectable from a predefined drop down where each of the
    ITEMS in the full menu will have a defined Calorie value so when you select
    Bacon in the drop down and enter a quantity of 2 that the Item LIne will
    auto populate with the total value for that item in that meal on that day
    Meaning: 1 Slice of bacon = 90 (calories) so the Data within drop down
    holds the associated calorie value for slices of Bacon which in this
    instance is 90 calories and a multiplication factor field where if you
    enter 2 the result field is auto populated with 180 Calories.
    So a drop down where you can choose an item from total menus and when you
    select that item you can add in a multiplication factor to produce the
    final result
    Might this be of sufficient help for someone to build a demo of a drop down
    with a long series of menu items each with unique calorie values and that
    you have the opportunity to also enter a calculation factor to achieve the
    final result?
    Kind Regards
    Ian
    Ian Mullen
    Ross Print Services, 5 Applewood Drive
    Greystones, Co. Wicklow A63 V208
    *WWW.ROSSPRINT.IE
    *
    *T: +353 1 287 6612*
    M: +353 87 255 4216
    ...
  • roneet
    Replied on September 17, 2019 at 8:22 AM

    Thanks for confirming your requirements.

    We will get back to you.

    Thanks.

  • IanRm
    Replied on September 18, 2019 at 4:39 PM
    Hi roneet
    Any progress on this demo please?
    Kind Regards
    Ian
    Ian Mullen
    Ross Print Services, 5 Applewood Drive
    Greystones, Co. Wicklow A63 V208
    *WWW.ROSSPRINT.IE
    *
    *T: +353 1 287 6612*
    M: +353 87 255 4216
    ...
  • Augustine_O
    Replied on September 18, 2019 at 5:56 PM

    Hello,

    We are still working on this we will get back to you as soon as it is ready. 

    Thanks

  • roneet
    Replied on September 18, 2019 at 9:33 PM

    I tried different ways of doing this. The best we can do is this way:

    1. Please add a text element in the Form and define all the values of the items there.

    Can I get guidance on setting up a Meal By Meal Day by Day self calculating Calorie Counting jotform please? Image 10

    2. Please select the Multi-type Columns in the Input table. One would be a dropdown and others would be a textbox. Assign the values in a dropdown:

    Can I get guidance on setting up a Meal By Meal Day by Day self calculating Calorie Counting jotform please? Image 21

    3. In the Form calculation widget add the Formula:

    total=item1*quantity+item2*quantity+item3*quantity

    Can I get guidance on setting up a Meal By Meal Day by Day self calculating Calorie Counting jotform please? Image 32

    Here is the Demo Form:

    https://form.jotform.com/92578263933973

    Result:

    1568856794form Screenshot 43

    Thanks.