I have a google form submission table for an event with up to E Tickets, with a form field for Ticket 1 Name, Ticket 1 Main Course, Ticket 1 Dessert, Ticket 1 Allergies and so on, up to Ticket 4. I want to create an array that bundles these tickets (only if filled out) and loop through each filled out ticket name to add a row to a google sheet and also generate an E-Ticket. I’m struggling to create an array (help from ChatGPT), this is where I’m at:
Welcome to the Make Community!
The first parameter of the map function accepts an array. You are incorrectly using a string there.
Please do the Make Academy to find out how to use the Map function, and get it right with a single map function, before you chain multiple maps in a row.
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 —
Getting Started
- Help Centre | Tutorials – Make “Manual” - search for help here first
- Make Academy – Basics 101: Learn Make properly to get your money’s worth
Help Centre Basics
- Mapping – What is mapping? What can I map?
- Mapping with arrays – How to map items in an array
- Aggregate an array for mapping complex fields
- Date Format: tokens for
parseDate| tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
Articles & Videos
- Router Magic Formula - YouTube
- Error Handlers in Make - YouTube playlist
- Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
- Text Parser module - Use pattern matching to extract the text you want
- Webhooks – Make Academy – tutorial on how to use Webhooks
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!