How to filter variable CMS data with bolean values that equal true in a collection /array

How To
, ,
1

Hi everyone, I’ve been using make for simple flows over the years such as passing data from Google sheets to Webflow, or vice-versa. And also use Airtable for similar purposes. But I am completely stumped on this problem that I have tried to solve for several days now.

The setup:
I am using make.com to get a form submission from Webflow. The form submission is a catering order form where a customer can select the food/beverage of their choice using a checkbox in the form which will return a boolean value in the form submssion of true or false per catering item.

The goal:
Pass the data into Make.com and filter out the boolean items that are false. Send an email to the catering company that shows the fields in the form submission such as:

  • name (text field)
  • phone (number field)
  • message (text field)
  • catering list (food/beverages selected as true, and do not show false

The challenge:
The catering items are being created from a dynamic collection in Webflow so the catering list can change over time (controlled by the client when the site is handed over). So I need a dynamic way of filtering any catering menu item that may appear in the data collection with a value of true (not false).

I’ve went through Make Basic and Make intermediate training just to solve this problem. I’ve learned about aggregators and iterators get() and map() functions and I was super excited thinking I can finalize solve this. But after another full day of banging my proverbial head against the wall, I can’t solve it. I tried reviewing all I could on youtube and in the make community threads but I just don’t see another issue like the one I am having.

I appreciate any help on this. Sharing my blueprint too.
blueprint.json (3.8 KB)

2

Do you have any control over the structure of the catering items? It might be easier to iterate over the items if they have a more structured JSON format like this:

{
  "cateringItems": [
    {
      "name": "catering-item A",
      "value": true
    },
    {
      "name": "catering-item B",
      "value": false
    },
    {
      "name": "catering-item C",
      "value": true
    },
    {
      "name": "catering-item D",
      "value": false
    },
    {
      "name": "catering-item E",
      "value": true
    },
    {
      "name": "catering-item F",
      "value": false
    },
    {
      "name": "catering-item G",
      "value": true
    },
    {
      "name": "catering-item H",
      "value": false
    }
  ],
  "name": "John Doe",
  "email": "john.doe@example.com",
  "phone": "5551234567",
  "cateringLocation": "Generic Location",
  "cateringInstructions": "Please deliver between 9am and 11am"
}

Then you could probably filter the true items more easily with an array aggregator.

L

3

Thanks the JSON structure you provided makes sense and I can see from there how to map any boolean value that = true.

But I don’t know how to restructure the JSON file. The fomat I provided from the JSON Parser is basically the structure of the webflow Bundle output.