Skip to main content

Zipping arrays in Make (Integromat)

  • November 25, 2023
  • 2 replies
  • 38 views
Andrey_Kovalev
Forum|alt.badge.img+20

Hello everyone!

I have a database with multiple linked tables and I have a JSON response with which parts I need to update corresponding records in those tables. To achive that (as I'm thinking) I need to solve a simple problem of zipping two arrays into one. Say, I have [rec1, rec2, rec3] and [val1, val2, val3]. I need to get a zipped array [[rec1, val1],[rec2,val2],[rec3, val3]]. How could I make this transformation with Make? Any ideas?

Andrey

    2 replies

    ScottWorld
    Forum|alt.badge.img+35
    • ScottWorld
    • Genius
    • November 25, 2023

    It’s possible that my 20-minute demonstration of Make’s Array functions and Make’s Array tools will give you some insights on this:

    Working With Airtable Arrays in Make

    —
    ScottWorld
    Expert Airtable Consultants

     

    Andrey_Kovalev
    Andrey_Kovalev
    Forum|alt.badge.img+20
    • Andrey_Kovalev
    • Author
    • Inspiring
    • November 27, 2023

    Solved. That was easy, but at first site not obvious. 

    1. Use an Iterator for the first array
    2. Configure Record Update module to take Array_1 element and collect corresponding element from Array_2 using a bundle index

      Hope it will help somebody 🙂

    Regards,

    Andrey

    ScottWorld
    Terms & ConditionsAccessibility statement