# Splitting data in a collection/array **URL:** \ **Category:** Beginner Questions\ **Tags:** error, google-sheets\ **Created:** [June 18, 2024, 12:49am UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150 "2024-06-18T00:49:00Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Mike\_Hughes](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@Mike\_Hughes](https://community.make.com/u/Mike_Hughes)\ **Post date:** [June 18, 2024, 12:49am UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/1 "2024-06-18T00:49:00Z")
Let me preface this with I am very new here and this might be an elementary question I am looking to take this data from a webhook export and put it into Google Sheets to make a dashboard I have spent hours trying to figure out how to split up this data so I can enter into Google Sheets. Every time I go to the Google Sheets module it will only give me one of the metrics as an option ![Screenshot 2024-06-17 at 8.45.46 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/9/690862514a745280ce21c8af194f7c59cf0b1282.png) ![Screenshot 2024-06-17 at 8.45.35 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/9/19566dad83e697708f7e7f4d49a038aa5a218e55.png) ![Screenshot 2024-06-17 at 8.45.24 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/1/21040b21ab1d7f6449da6dcdabfe34ab317d83c9.png) ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 18, 2024, 1:33am UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/2 "2024-06-18T01:33:07Z")
Welcome to the Make community! You’ll need to use the map and get functions to map values within an array. For more information, see Mapping with Arrays below: Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too — ### General - [Help Center](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) - [Make Academy](https://academy.make.com) – learn Make and get your certificate - [Discord Server](https://samliew.com/make-discord-invite) – join us in live chat for fans of Make! ### Help Center Basics - [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map? - [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array - [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output) - [Tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [Tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) - [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file - [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks ### Articles & Videos - [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube - [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist - [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) [samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make) > Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with other makers! ---
**Author:** ![Mike\_Hughes](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@Mike\_Hughes](https://community.make.com/u/Mike_Hughes)\ **Post date:** [June 25, 2024, 2:14am UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/3 "2024-06-25T02:14:53Z")
I tried mapping this and asking a friend who uses make and we are both stumped. The data is being nested as a collection and it doesn’t let me parse the test or extract any values ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 25, 2024, 8:23am UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/4 "2024-06-25T08:23:33Z")
Could you provide a sample full output bundle as shown in your screenshots? This will allow others to help you further. ## 1. Screenshots of module fields and filters Please share screenshots of relevant module fields and filters in question? It would really help other community members to see what you’re looking at. You can upload images here using the Upload icon in the text editor: ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/0/20b53cdf28d223e85fc9654c350eadebd37f5d3c.png) ## 2. Scenario blueprint Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item. ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/2/2ff55ee04419049c127f183db2b3eebfbbbbfc64.png) (Note: Exporting your scenario will not include private information or keys to your connections) Uploading it here will look like this: > blueprint.json (12.3 KB) ## 3. And most importantly, Input/Output bundles Please provide the **input** and **output** bundles of the trigger/iterator/aggregator modules by running the scenario (or get from the [scenario History tab](https://www.make.com/en/help/scenarios/scenario-execution-history)), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”. ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/8/2876156ab3ea5bc9e40bbc0edfb9f025406b7c48.png) ### A. Save each bundle contents in your text editor as a `bundle.txt` file, and upload it here into this discussion thread. Uploading them here will look like this: > module-1-output-bundle.txt (12.3 KB) ### B. If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner: - Either add three backticks ````` before and after the code, like this: - Or use the format code button in the editor: ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/4/b485b6572c7a1c438f9b191c54e63d351008304c.png) Providing the input/output bundles will allow others to _replicate_ what is going on in the scenario even if they do not use the external service. Following these steps will allow others to assist you here. Thanks! [samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make) > ### Join the [Make Fans](https://samliew.com/make-discord-invite) Discord server to [chat](https://samliew.com/make-discord-invite) with other makers! ---
**Author:** ![Mike\_Hughes](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@Mike\_Hughes](https://community.make.com/u/Mike_Hughes)\ **Post date:** [June 25, 2024, 5:10pm UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/5 "2024-06-25T17:10:04Z")
This is the text of the data that shows up but in the next 2 screenshots you’ll see I have no way to gather that data. It will keep showing up as “data” and then switching between one of the 3 metrics I am trying to pull in { “data”: { “metrics”: [ { “data”: [ { “qty”: 231.3304761904762, “date”: “2024-06-20 00:00:00 -0400”, “source”: “MacrosFirst” }, { “date”: “2024-06-21 00:00:00 -0400”, “qty”: 289.82608695652175, “source”: “MacrosFirst” }, { “source”: “MacrosFirst”, “qty”: 78, “date”: “2024-06-22 00:00:00 -0400” }, { “date”: “2024-06-24 00:00:00 -0400”, “source”: “MacrosFirst”, “qty”: 169.31293595263725 } ], “units”: “g”, “name”: “carbohydrates” }, { “units”: “g”, “name”: “protein”, “data”: [ { “date”: “2024-06-20 00:00:00 -0400”, “qty”: 132.2357142857143, “source”: “MacrosFirst” }, { “qty”: 106.17391304347827, “source”: “MacrosFirst”, “date”: “2024-06-21 00:00:00 -0400” }, { “qty”: 56, “source”: “MacrosFirst”, “date”: “2024-06-22 00:00:00 -0400” }, { “qty”: 185.9289451022605, “date”: “2024-06-24 00:00:00 -0400”, “source”: “MacrosFirst” } ] }, { “data”: [ { “date”: “2024-06-20 00:00:00 -0400”, “qty”: 52.56380952380952, “source”: “MacrosFirst” }, { “qty”: 79.21739130434783, “date”: “2024-06-21 00:00:00 -0400”, “source”: “MacrosFirst” }, { “date”: “2024-06-22 00:00:00 -0400”, “source”: “MacrosFirst”, “qty”: 8 }, { “source”: “MacrosFirst”, “date”: “2024-06-24 00:00:00 -0400”, “qty”: 56.82576157158235 } ], “units”: “g”, “name”: “total\_fat” } ] } } ![Screenshot 2024-06-25 130950](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/d/ed8ca66a45793de714b8a3c6f0ed1ba553aabcb1.png) ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 26, 2024, 2:27am UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/6 "2024-06-26T02:27:53Z")
Can you briefly describe how you want the output / final data to look like? I don’t think you’ve covered that yet. Or could you break down the steps what you are trying to achieve? E.g.: 1. I would like to loop through each day 2. I would like to get the metrics (carbohydrates, protein, total\_fat) for the day 3. I would like to insert the days’ metrics into a new row of the spreadsheet Also, you did not provide #1 and #2 in my previous post. [samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make) > ### Join the [Make Fans](https://samliew.com/make-discord-invite) Discord server to [chat](https://samliew.com/make-discord-invite) with other makers! ---
**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\ **Post date:** [June 26, 2024, 3:53am UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/7 "2024-06-26T03:53:58Z")
Hi @Mike_Hughes You can use the iterator module to loop through all the arrays and map the values to the Google Sheet. If you specify which values you want to map to the Google Sheet, we can provide further assistance. If you require additional assistance, please don’t hesitate to reach out to us. [MSquare Support](https://calendly.com/msquarepro/meeting)| [Book Live Implementation](https://calendly.com/msquarepro/msquareautomation-live) Visit us [here](https://www.msquare.pro/) [Youtube Channel](https://www.youtube.com/channel/UCqidlIIwbejxZmRUWBICcjQ) ---
**Author:** ![Mike\_Hughes](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@Mike\_Hughes](https://community.make.com/u/Mike_Hughes)\ **Post date:** [June 26, 2024, 9:57pm UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/8 "2024-06-26T21:57:10Z")
Im sorry im really frustrated and getting my thoughts out isn’t the best. Ideally I can have this webhook run each day to map peoples data to a google sheet which I then have flow into a dashboard and eventually an app ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 27, 2024, 1:20am UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/9 "2024-06-27T01:20:08Z")
No problem, I’m here to help. Perhaps a good first step is to create an example spreadsheet of how you want to structure your data, so we can advise how to map/insert your data into there. [samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make) > ### Join the [Make Fans](https://samliew.com/make-discord-invite) Discord server to [chat](https://samliew.com/make-discord-invite) with other makers! ---
**Author:** ![Mike\_Hughes](https://avatars.discourse-cdn.com/v4/letter/m/ed655f/32.png) [@Mike\_Hughes](https://community.make.com/u/Mike_Hughes)\ **Post date:** [June 27, 2024, 1:28pm UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/10 "2024-06-27T13:28:15Z")
Im just looking to map the data in its most simple form. ust a simple column for date, protein, fats and carbs. Once I get the data into google sheets I am good to manipulate it how I need. ![Screenshot 2024-06-27 092726](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/4/9499b9f7480a550362bca7b8fcf2d103761ee26e.png) ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 27, 2024, 1:47pm UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/11 "2024-06-27T13:47:04Z")
Welcome to the Make community! Yes, that is possible. You’ll need a minimum of two modules: ![Screenshot_2024-06-27_210640](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/c/6c2fb73fa897c7d8dfb6429019bc50f127b846d8.png) # 1. Iterate any metric’s data array ![Screenshot_2024-06-27_210636](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/4/a46032ec191eef5d5ee9c7df9830829b29119ec9.png) # 2. Use map and get functions to map each date’s data ![Screenshot_2024-06-27_210632](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/5/c5314a6f825d831b2096c0881e2d0e6a40953ef0.png) Give it a go and let us know if you have any issues! # Output ![Screenshot_2024-06-27_210656](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/f/af86beb5107e1a7e89ef60c76402013406cfd572.png) [samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make) > ### Join the [Make Fans](https://samliew.com/make-discord-invite) Discord server to [chat](https://samliew.com/make-discord-invite) with other makers! ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [June 27, 2024, 1:47pm UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/12 "2024-06-27T13:47:34Z")
## Module Export You can **copy** and **paste** this module export into your scenario. This will paste the modules shown in my screenshots above. 1. Copy the JSON code below by clicking the copy button when you mouseover the **top-right** of the code block ![Screenshot_2024-01-17_200117](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/b/2b1b692880388420db5045bf51ef344e6698a816.png) 2. Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (paste keyboard shortcut for Windows) to paste directly in the canvas. 3. Click on each imported module and save it for validation. You may be prompted to remap some variables and connections. > **View Module Export Code** > > #### JSON > > ```json > { > "subflows": [ > { > "flow": [ > { > "id": 5, > "module": "json:ParseJSON", > "version": 1, > "parameters": { > "type": "" > }, > "mapper": { > "json": "{\n \"data\": {\n \"metrics\": [\n {\n \"data\": [\n {\n \"qty\": 231.3304761904762,\n \"date\": \"2024-06-20 00:00:00 -0400\",\n \"source\": \"MacrosFirst\"\n },\n {\n \"date\": \"2024-06-21 00:00:00 -0400\",\n \"qty\": 289.82608695652175,\n \"source\": \"MacrosFirst\"\n },\n {\n \"source\": \"MacrosFirst\",\n \"qty\": 78,\n \"date\": \"2024-06-22 00:00:00 -0400\"\n },\n {\n \"date\": \"2024-06-24 00:00:00 -0400\",\n \"source\": \"MacrosFirst\",\n \"qty\": 169.31293595263725\n }\n],\n \"units\": \"g\",\n \"name\": \"carbohydrates\"\n },\n {\n \"units\": \"g\",\n \"name\": \"protein\",\n \"data\": [\n {\n \"date\": \"2024-06-20 00:00:00 -0400\",\n \"qty\": 132.2357142857143,\n \"source\": \"MacrosFirst\"\n },\n {\n \"qty\": 106.17391304347827,\n \"source\": \"MacrosFirst\",\n \"date\": \"2024-06-21 00:00:00 -0400\"\n },\n {\n \"qty\": 56,\n \"source\": \"MacrosFirst\",\n \"date\": \"2024-06-22 00:00:00 -0400\"\n },\n {\n \"qty\": 185.9289451022605,\n \"date\": \"2024-06-24 00:00:00 -0400\",\n \"source\": \"MacrosFirst\"\n }\n]\n },\n {\n \"data\": [\n {\n \"date\": \"2024-06-20 00:00:00 -0400\",\n \"qty\": 52.56380952380952,\n \"source\": \"MacrosFirst\"\n },\n {\n \"qty\": 79.21739130434783,\n \"date\": \"2024-06-21 00:00:00 -0400\",\n \"source\": \"MacrosFirst\"\n },\n {\n \"date\": \"2024-06-22 00:00:00 -0400\",\n \"source\": \"MacrosFirst\",\n \"qty\": 8\n },\n {\n \"source\": \"MacrosFirst\",\n \"date\": \"2024-06-24 00:00:00 -0400\",\n \"qty\": 56.82576157158235\n }\n],\n \"units\": \"g\",\n \"name\": \"total_fat\"\n }\n ]\n }\n}" > }, > "metadata": { > "designer": { > "x": 1, > "y": -265 > }, > "restore": { > "parameters": { > "type": { > "label": "Choose a data structure" > } > } > }, > "parameters": [ > { > "name": "type", > "type": "udt", > "label": "Data structure" > } > ], > "expect": [ > { > "name": "json", > "type": "text", > "label": "JSON string", > "required": true > } > ] > } > }, > { > "id": 28, > "module": "builtin:BasicFeeder", > "version": 1, > "parameters": {}, > "mapper": { > "array": "{{5.data.metrics[].data}}" > }, > "metadata": { > "designer": { > "x": 245, > "y": -262, > "name": "Each Day" > }, > "restore": { > "expect": { > "array": { > "mode": "edit" > } > } > }, > "expect": [ > { > "name": "array", > "type": "array", > "label": "Array", > "mode": "edit", > "spec": [] > } > ] > } > }, > { > "id": 27, > "module": "google-sheets:addRow", > "version": 2, > "parameters": { > " __IMTCONN__": 95013 > }, > "mapper": { > "mode": "fromAll", > "insertUnformatted": false, > "valueInputOption": "USER_ENTERED", > "insertDataOption": "INSERT_ROWS", > "spreadsheetId": "1G4oYDWJLUT2KhsC4TbFp7Owh_dyG_-0NQOEk4gcMVNU", > "sheetId": "Sheet1", > "includesHeaders": true, > "values": { > "0": "{{28.date}}", > "1": "{{get(map(first(map(5.data.metrics; \"data\"; \"name\"; \"protein\")); \"qty\"); 28.` __IMTINDEX__ `)}}", > "2": "{{get(map(first(map(5.data.metrics; \"data\"; \"name\"; \"total_fat\")); \"qty\"); 28.` __IMTINDEX__ `)}}", > "3": "{{get(map(first(map(5.data.metrics; \"data\"; \"name\"; \"carbohydrates\")); \"qty\"); 28.` __IMTINDEX__ `)}}" > } > }, > "metadata": { > "designer": { > "x": 487, > "y": -263 > }, > "restore": { > "parameters": { > " __IMTCONN__": { > "collapsed": true, > "label": "Google Docs", > "data": { > "scoped": "true", > "connection": "google" > } > } > }, > "expect": { > "mode": { > "label": "Select from all" > }, > "insertUnformatted": { > "mode": "chose" > }, > "valueInputOption": { > "mode": "chose", > "label": "User entered" > }, > "insertDataOption": { > "mode": "chose", > "label": "Insert rows" > }, > "sheetId": { > "mode": "chose", > "label": "Sheet1" > }, > "includesHeaders": { > "nested": [ > { > "name": "values", > "label": "Values", > "type": "collection", > "spec": [ > { > "name": "0", > "label": "date (A)", > "type": "text" > }, > { > "name": "1", > "label": "protein (B)", > "type": "text" > }, > { > "name": "2", > "label": "fats (C)", > "type": "text" > }, > { > "name": "3", > "label": "carbs (D)", > "type": "text" > }, > { > "name": "4", > "label": "(E)", > "type": "text" > }, > { > "name": "5", > "label": "(F)", > "type": "text" > }, > { > "name": "6", > "label": "(G)", > "type": "text" > }, > { > "name": "7", > "label": "(H)", > "type": "text" > }, > { > "name": "8", > "label": "(I)", > "type": "text" > }, > { > "name": "9", > "label": "(J)", > "type": "text" > }, > { > "name": "10", > "label": "(K)", > "type": "text" > }, > { > "name": "11", > "label": "(L)", > "type": "text" > }, > { > "name": "12", > "label": "(M)", > "type": "text" > }, > { > "name": "13", > "label": "(N)", > "type": "text" > }, > { > "name": "14", > "label": "(O)", > "type": "text" > }, > { > "name": "15", > "label": "(P)", > "type": "text" > }, > { > "name": "16", > "label": "(Q)", > "type": "text" > }, > { > "name": "17", > "label": "(R)", > "type": "text" > }, > { > "name": "18", > "label": "(S)", > "type": "text" > }, > { > "name": "19", > "label": "(T)", > "type": "text" > }, > { > "name": "20", > "label": "(U)", > "type": "text" > }, > { > "name": "21", > "label": "(V)", > "type": "text" > }, > { > "name": "22", > "label": "(W)", > "type": "text" > }, > { > "name": "23", > "label": "(X)", > "type": "text" > }, > { > "name": "24", > "label": "(Y)", > "type": "text" > }, > { > "name": "25", > "label": "(Z)", > "type": "text" > } > ] > } > ], > "label": "Yes" > } > } > }, > "parameters": [ > { > "name": " __IMTCONN__", > "type": "account:google", > "label": "Connection", > "required": true > } > ], > "expect": [ > { > "name": "mode", > "type": "select", > "label": "Choose a Method", > "required": true, > "validate": { > "enum": [ > "select", > "fromAll", > "map" > ] > } > }, > { > "name": "insertUnformatted", > "type": "boolean", > "label": "Unformatted", > "required": true > }, > { > "name": "valueInputOption", > "type": "select", > "label": "Value input option", > "validate": { > "enum": [ > "USER_ENTERED", > "RAW" > ] > } > }, > { > "name": "insertDataOption", > "type": "select", > "label": "Insert data option", > "validate": { > "enum": [ > "INSERT_ROWS", > "OVERWRITE" > ] > } > }, > { > "name": "spreadsheetId", > "type": "text", > "label": "Spreadsheet ID", > "required": true > }, > { > "name": "sheetId", > "type": "select", > "label": "Sheet Name", > "required": true > }, > { > "name": "includesHeaders", > "type": "select", > "label": "Table contains headers", > "required": true, > "validate": { > "enum": [ > true, > false > ] > } > }, > { > "name": "values", > "type": "collection", > "label": "Values", > "spec": [ > { > "name": "0", > "type": "text", > "label": "date (A)" > }, > { > "name": "1", > "type": "text", > "label": "protein (B)" > }, > { > "name": "2", > "type": "text", > "label": "fats (C)" > }, > { > "name": "3", > "type": "text", > "label": "carbs (D)" > }, > { > "name": "4", > "type": "text", > "label": "(E)" > }, > { > "name": "5", > "type": "text", > "label": "(F)" > }, > { > "name": "6", > "type": "text", > "label": "(G)" > }, > { > "name": "7", > "type": "text", > "label": "(H)" > }, > { > "name": "8", > "type": "text", > "label": "(I)" > }, > { > "name": "9", > "type": "text", > "label": "(J)" > }, > { > "name": "10", > "type": "text", > "label": "(K)" > }, > { > "name": "11", > "type": "text", > "label": "(L)" > }, > { > "name": "12", > "type": "text", > "label": "(M)" > }, > { > "name": "13", > "type": "text", > "label": "(N)" > }, > { > "name": "14", > "type": "text", > "label": "(O)" > }, > { > "name": "15", > "type": "text", > "label": "(P)" > }, > { > "name": "16", > "type": "text", > "label": "(Q)" > }, > { > "name": "17", > "type": "text", > "label": "(R)" > }, > { > "name": "18", > "type": "text", > "label": "(S)" > }, > { > "name": "19", > "type": "text", > "label": "(T)" > }, > { > "name": "20", > "type": "text", > "label": "(U)" > }, > { > "name": "21", > "type": "text", > "label": "(V)" > }, > { > "name": "22", > "type": "text", > "label": "(W)" > }, > { > "name": "23", > "type": "text", > "label": "(X)" > }, > { > "name": "24", > "type": "text", > "label": "(Y)" > }, > { > "name": "25", > "type": "text", > "label": "(Z)" > } > ] > } > ] > } > } > ] > } > ], > "metadata": { > "version": 1 > } > } > > ``` Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too — ### General - [Help Center](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) - [Make Academy](https://academy.make.com) – learn Make and get your certificate - [Discord Server](https://samliew.com/make-discord-invite) – join us in live chat for fans of Make! ### Help Center Basics - [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map? - [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array - [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output) - [Tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [Tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) - [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file - [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks ### Articles & Videos - [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube - [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist - [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) [samliew](https://samliew.com/services) – [request private consultation](https://samliew.com/request-quote?ServiceType=Automation%20Consultation&Referrer=Make) > Join the unofficial [Make Discord server](https://samliew.com/make-discord-invite) to chat with other makers! ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [September 25, 2024, 1:51pm UTC](https://community.make.com/t/splitting-data-in-a-collection-array/42150/13 "2024-09-25T13:51:18Z")