What is your goal?
I have airtable field with emails comma seperated now when that field comes in Make i want to create an string like this:
{“email”:“email1”},{“email”:“email2”} and so on.
For Example (AT Field):
test@email.cm, john@gmail.cm, doe@gmail.cm
In make I want:
{“email”:“test@gmail.cm”},{“email”:“john@gmail.cm”},{“email”:"doe@gmail.cm}
Which i will pass in Google Calender Attendees as Map like this:
[ created string ]
so it will be treated as attendees array
Hey there,
you can do that with an iterator module followed by an aggregate to JSON module. Put your comma separated list inside a split() function in the iterator module and define the structure you want in the aggregate to JSON module.
Hi @Stoyan_Vatov , thanks for the reply. I got the desired output which is: [{“email”:“test@gmail.cm”},{“email”:“john@gmail.cm”},{“email”:“doe@gmail.cm”}]
But when I pass this to Attendees like this:
It gives error you have any idea how can i achieve this?
Note: For privacy I am using the fake emails in my scenario I have real emails.
Hi thanks all so I achieved this using Iterator module like @Stoyan_Vatov told, but after that have an array aggregator module with source as Iterator and Target as Attendees and fill the email with iterator value like below:
Then pass this array in attendees in create event module
3 Likes