Add key value to existing array

Questions
1

:bullseye: What is your goal?

Hi all,

Thanks for your time!

I am working on a scenario which create event on Google Calendar from Airtable with attendees. I am creating the attendees array using array aggregator which gives me the required array to use in Google Calendar Attendees module. Now on that array on the 1 attendee i want to add responseStatus: confirmed. So that by default it is confirmed for me as always the first one will be my email in the attendees field.

Please find the attached screenshot.

:thinking: What is the problem & what have you tried?

Not able to figure it out how to.

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

SS.png
SS.png1920×886 114 KB

1 Like
3

Hey there,

sorry can you clarify - you want to add the status to all of them? Or only to specific ones?

4

Only the 1st one from the array returned by array aggregator. Highlighted in the screenshot.

1 Like
5

And do they need to be bulked together in an array for airtable? What does the table look like?

My point is, if its just a separate column you can add an if formula there - if the email is this one then add this status.

6

This is the flow:

  1. User creates a record in Airtable with attendees as: email1,email2,email3

  2. Then this automation triggers which aggregates the emails using array aggregator and then this array is passed on to Create Event module of Google Calendar. So before passing it to Google Calendar I want to edit the array in which I want to add key: responseStatus value: confirmed on the first record of the array. so the new array after adding should be like this:

    Array:

    1. (Collection)
      1. Email: john@gmail[.]com
      2. Name: empty
      3. Response Status: confirmed
    2. (Collection)
      1. Email: doe@gmail[.]com
      2. Name: empty

And so on

1 Like
7

Ok, you can place a set variables module between the iterator and the aggregator and have it set a variable called responseStatus. Then have the variable itself be an if statement that checks if the email matches - if it does, set it to confirmed; if it doesn’t, don’t set it. In this case however all entries in the array will have the responseStatus, it will just be empty.

image
image1409×567 48.2 KB

If you need only the specific one to have it, then you need a router - one array will have the main email with the confirmed status and the other array will have the rest without that key-value pair. Then you merge the two arrays. Something like this.