Copy link to clipboard
Copied
Hi,
I am having problem with creating a fillable form formula to work in adobe. I have created a drop down menu titled "No.ofMeals", values being 3,4 and 5. I want the form to divide the field "ProteinGrams" by whats selected from the drop down - so divided by either 3,4,5. Thanks
As the custom calculation script of the field where you want to show the result, enter this:
event.value = Number(this.getField("ProteinGrams").valueAsString) / Number(this.getField("No.ofMeals").valueAsString);
Copy link to clipboard
Copied
As the custom calculation script of the field where you want to show the result, enter this:
event.value = Number(this.getField("ProteinGrams").valueAsString) / Number(this.getField("No.ofMeals").valueAsString);
Copy link to clipboard
Copied
Hi try67,
thanks for your response. the formula you provided works but is not quite 100% right yet.
to give you a scenario I have created a PDF Nutrition form that when you enter your weight (lbs) into the "Weight" field it will calculate a Total Calories sum in the "Total Calories" Field (Formula is weight in lbs x 10 kcal).
Now we have the total Calories field filled in based on selection of weight e.g. 150 lbs x 10 = 1500 calories.
The form then calculates %'s of food into the following fields -
"Calories Protein" = (1500 x 0.40) this then gives the "GramsProtein" (CaloriesProtein/4)
"Calories Carbohydrates" = (1500 x 025) this then gives us "GramsCarbs" (CaloriesCarbs/4)
"CaloriesFats" = (1500 x 0.35) this then gives us "GramsFats" (CaloriesFats/9)
The percentages of food from the total calories calculated are 40% Protein, 25% Carbs, 35% Fats.
I have managed to sort all this bit of the form perfectly myself.
The bit I am now struggling with is to divide the grams of food based on the dropdown menu "No.ofMeals" selection. - 3,4, or 5.
There are 5 individual meals boxes:
Meal 1
Meal 2
Meal 3
Meal 4
Meal 5
your suggestion divides all equally so the form does this:
So if 150 lbs x 10 kcal = 1500 kcal
Protein 150 grams
Carbs 93.75
Fats 58g.
Your calculation "works" except if I was to chose 3 meals 50 grams of protein shows in every box:
Meal 1: 50
Meal 2: 50
Meal 3: 50
Meal 4: 50
Meal 5: 50
If I now select 3 meals on the drop down menu 50grams shows in all 5 meal boxes rather than just 3.
the total grams of protein shows now 250g grams which doesn't make sense / wrong calculation as the total grams of protein is only 150.
I need the form to calculate the meals based on selection of "No.ofMeals" from the drop down menu.
So if 3 meals selected the form only divides Protein by 3 to show protein in meals 1, 2 and 3 boxes.
If the user selects 4 meals I need the form to divide protein by 4 to show protein grams in meals 1,2,3 and 4. only
and obviously is user selects 5 meals the form shows "ProteinGrams" / 5 to show calculation in all 5 boxes.
Hope all makes sense. Attached a photos to help.
Copy link to clipboard
Copied
OK, that's not quite what you asked for before...
There are various ways of doing it. Maybe the easiest is to add a condition to the 4th and 5th fields to only show the result if 4 or 5 are selected. Otherwise, keep them empty.
Something like this for field 4:
var numMeals = Number(this.getField("No.ofMeals").valueAsString);
if (numMeals==4 || numMeals==5) event.value = Number(this.getField("ProteinGrams").valueAsString) / numMeals;
else event.value = "";
And for field 5:
var numMeals = Number(this.getField("No.ofMeals").valueAsString);
if (numMeals==5) event.value = Number(this.getField("ProteinGrams").valueAsString) / numMeals;
else event.value = "";
The rest can remain the same.
Copy link to clipboard
Copied
Hi try67,
Thanks for your help and input, really appreciated.
I've copied and pasted your formula but it now just has Meal 4 blank and meal 5 blank even if I select 4 meals or 5 meals in "No.ofMeals" both meal box 4 and meal box 5 are blank below.
Thanks
Copy link to clipboard
Copied
I need to see the actual file to be able to help you further. Can you share it, either via a file-sharing website (Dropbox, Google Drive, Adobe DC) or privately via email (try6767 at gmail.com)?
Copy link to clipboard
Copied
Hi Try,
I need one more calculation then the form is complete. I am so thankful for your help...
Its the carbohydrates calculation.
If "No.ofMeals" selected is 5 I need the "GramsCarbohydrates" to divide by 2 and show in the last two boxes - meal 5 and meal 4 boxes.
If "No.ofMeals" selected is 4 I need the "GramsCarbohydrates" to divide by 2 and show in the boxes meals 4 and meals 3 and not to show at all in Meal 5 box.
If "No.ofMeals" selected is 3 I need the "GramsCarbohydrates" to divide by 2 and show in the boxes Meals 3 and Meals 2 and not to show in Meals 5 or 4 Boxes.
Hope that makes sense.
Thanks,
Chris
Copy link to clipboard
Copied
Hope you can help with the last formula Try - sure is very simple for you and wouldn't take you long.
Thanks so much.
Chris
Copy link to clipboard
Copied
Hi Try 67,
found the problem my formula is GramsProtein not ProteinGrams - my bad this is excellent work thank you so much.
Chris