Hot Lunch Order Form (with instructions)

Instructions

The link to the HACD Hot Lunch Builder that you will be using in the Spreadsheet to Form widget is here. (If you want to copy that sheet and make it your own, you can! Just remember that you will need to update the sheet from the copy and not from the one linked here.)

1. On the meals_from_518K page, enter the meals that you get from 518Kosher. You just need to fill out the sections that are highlighted in green.

2. When you're done, move over to the spreadsheet_to_form page and enter in the Lunch Month & Year, Order Deadline, and Number of Meals. Again, that section is highlighted in green. Please don't change the headings in the columns - the magic won't happen if you do that.

3. Once you've finished that, download the entire sheet as an Excel file. Click on Upload Spreadsheet below and remove the existing spreadsheet and upload the new one. Make sure that you choose spreadsheet_to_form as the sheet and lunchMonthAndYear as the Access Code Column.

4. For the Lunch Month & Year dropdown field, go to the Options tab and set the default month and year.

Updated 27 January 2025 to remove Alternate Meals from both the HACD Hot Lunch Builder google sheet and the form.

Updated 7 August 2025 to reflect new pricing.
Spreadsheet to Form Fields

Using the widget, remove last month's spreadsheet and upload this month's spreadsheet to the form.
Upload Spreadsheet
numberOfMeals
orderDeadline
meal_1
meal_2
meal_3
meal_4
meal_5
meal_6
meal_7
meal_8
meal_9
meal_10
meal_11
meal_12
meal_13
meal_14
Set Default Month and Year

Every month, you need to change this! You do that in the Properties -> Options -> Default Value.
Lunch Month & Year*
{lunchMonth} Hot Lunch

There are {numberofmeals} lunches this month. The deadline for ordering lunch for {lunchMonth} is {orderDeadline}.

Ordering Instructions

Select Monthly Order if you would like your child to receive the same meal option every day that hot lunch is offered. You will then be able to choose one of the 3 meal options:
- Junior Meal (a regular portion of the main meal)
- Large Meal (a larger portion of the main meal - recommended for middle-schoolers)
- Bagel & Cream Cheese Meal
Select Daily Order if you would like your child to receive different meal options on different days.

Pricing

$7.25 - Junior Meal
$9.25 - Large Meal
$7.25 - Bagel & Cream Cheese

Important Notes
- All meals are parve/dairy served by 518Kosher under the supervision of the Va’ad of Kashrut of the Capital District.
- The Junior Meal and Large Meal options are served with a vegetable side and whole fruit.
- The Bagel & Cream Cheese meal option is served with whole fruit.
- Beverages will not be included. Milk will be provided by HACD and sold separately. We recommend that students bring a water bottle daily.
Parent/Guardian Name*

First NameLast Name
Parent/Guardian Email*
For how many children are you ordering Hot Lunches?*
Please enter the first name of your child.*
Please enter the first name of one of your children.*
You can start with whomever you want.
childOneNameCollector*

{childOneNameCollector}'s Order
For {childOneNameCollector}, would you like to do a Monthly Order or a Daily Order?*

Monthly OrderDaily Order
{childOneNameCollector} Monthly Meal Option*
Monthly Order Total*
This is the price of the meal multiplied by the number of meals for the month.
Below are all of the meals available for {lunchMonth}. Please choose which days and meal options you would like to order for {childOneNameCollector}.
{meal_1}
{meal_2}
{meal_3}
{meal_4}
{meal_5}
{meal_6}
{meal_7}
{meal_8}
{meal_9}
{meal_10}
{meal_11}
{meal_12}
{meal_13}
{meal_14}
Daily Order Total*
{childOneNameCollector}'s Total*

{childOneNameCollector}
Monthly Order Option	{childonenamecollectorMonthly}
{meal_1}	{typeA164}
{meal_2}	{meal_2165}
{meal_3}	{meal_3166}
{meal_4}	{meal_4167}
{meal_5}	{meal_5168}
{meal_6}	{meal_6169}
{meal_7}	{meal_7186}
{meal_8}	{meal_8187}
{meal_9}	{meal_9188}
{meal_10}	{meal_10189}
{meal_11}	{meal_11190}
{meal_12}	{meal_12191}
{meal_13}	{meal_13192}
{meal_14}	{meal_14193}

moveOntoSecondChild
Please enter the first name of the next child.*
Pick one of them - it doesn't matter which one.
Please enter the first name of your second child.*
We won't tell them that you put them second.
childTwoNameCollector

{childTwoNameCollector}'s Order
For {childTwoNameCollector}, would you like to do a Monthly Order or a Daily Order?*

Monthly OrderDaily Order
{childTwoNameCollector} Monthly Meal Option*
childTwoMonthlyOrderTotal*
Below are all of the meals available for {lunchMonth}. Please choose which days and meal options you would like to order for {childTwoNameCollector}.
{meal_1}
{meal_2}
{meal_3}
{meal_4}
{meal_5}
{meal_6}
{meal_7}
{meal_8}
{meal_9}
{meal_10}
{meal_11}
{meal_12}
{meal_13}
{meal_14}
childTwoDailyOrderTotal*
{childTwoNameCollector}'s Total*
moveOntoThirdChild
Please enter the first name of your third child.*
We won't tell them that you put them last.

{childThree}'s Order
For {childThree}, would you like to do a Monthly Order or a Daily Order?*

Monthly OrderDaily Order
{childThree} Monthly Meal Option*
childThreeMonthlyOrderTotal*
Below are all of the meals available for {lunchMonth}. Please choose which days and meal options you would like to order for {childThree}.
{meal_1}
{meal_2}
{meal_3}
{meal_4}
{meal_5}
{meal_6}
{meal_7}
{meal_8}
{meal_9}
{meal_10}
{meal_11}
{meal_12}
{meal_13}
{meal_14}
childThreeDailyOrderTotal*
{childThree}'s Total*

Confirmation & Payment
Total Due*
My Products

prevnext( X )
USDDescription

Payment Methods

Debit or Credit Card

Choose from one of the PayPal options to make your payment.

Should be Empty:

Instructions

Spreadsheet to Form Fields

Set Default Month and Year

{lunchMonth} Hot Lunch

Ordering Instructions

Pricing

Important Notes

{childOneNameCollector}'s Order

{childTwoNameCollector}'s Order

{childThree}'s Order

Confirmation & Payment