Advanced Customization Guide

Change the meal planning week to start on Monday #

  1. From your dashboard, open one of the days in the “Planning” section
  2. Unhide the hidden properties
  3. Locate the “Date53” property and change the “w” references to “W” (or copy/paste the following formula):

if(year(prop("Date")) - year(now()) == 1, (toNumber(formatDate(prop("Date"), "W")) == 1 and month(prop("Date")) == 11) ? 105 : (toNumber(formatDate(prop("Date"), "W")) + 52), if(year(prop("Date")) == year(now()), (toNumber(formatDate(prop("Date"), "W")) == 1 and month(prop("Date")) == 11) ? 53 : if(formatDate(prop("Date"), "DDD") == "1", -1, toNumber(formatDate(prop("Date"), "W"))), 0))

4. Locate the “Now53” property and change the “w” references to “W” (or copy/paste the following formula):

(toNumber(formatDate(now(), "W")) == 1 and month(now()) == 11) ? 53 : toNumber(formatDate(now(), "W"))

5. Re-hide the hidden properties

5. Back on the dashboard in the “Planning” section, drag the Sunday column all the way to the right and drop it after Saturday

Populate the shopping list immediately #

  1. Navigate to one of the date entries (in the Meal Planning database)
  2. Unhide the hidden properties
  3. Replace the “Within 3 days?” formula to:

if(timestamp(prop("Date")) > timestamp(now()) - 86400000, true, false)

This will activate any future days that have meals planned and add the ingredients to your grocery list immediately.

Change the 3-day grocery shopping rule to 7 days (or other) #

You can change the number of days for how frequently (or infrequently) you go grocery shopping. The formula is in the Meal Planning database. The property is titled “Within 3 days?” and is hidden. It looks like this:

if(timestamp(prop("Date")) > timestamp(now()) - 86400000, if(dateBetween(prop("Date"), now(), "days") + 1 <= 2, true, false), false)

Change the number “2” to the number of days between grocery shopping minus 1. For example, if you go grocery shopping once a week you would change the formula to this:

if(timestamp(prop("Date")) > timestamp(now()) - 86400000, if(dateBetween(prop("Date"), now(), "days") + 1 <= 6, true, false), false)

The Happy Kitchen - Change shopping days formula