This post was split from the topic:
Another question in this thread!
i am now working on the Zap to remove people from certain groups in Mailerlite, and then i want to update their record in Airtable to reflect the groups that they are currently part of.
i did a similiar paths zap where i’m removing subscribers from the groups and then using Zapier Storage to keep track of which groups were removed.
i need a step at the end that comes up with the list of groups that they are still a part of & puts that back into Airtable (or clears the groups field in Airtable if they’ve been removed from all groups). i tried a bunch of things & can’t get it to work. is there a straight-forward solution here that i might not be aware of?
if not, here’s what i tried & what’s happening:
i’m not sure if i need the delay, but wanted to make sure i had the full list of groups removed before i used Get Value.
i put in the step to remove extra spaces from the list of groups because if i have “Members,Individual Donors” and i Replace “Members” with “”, then the list becomes “,Individual Donors” and Airtable puts a blank multi-select value in my field. and i put in the step to replace blank data with 3 spaces so that if they end up in no groups, the field will be cleared.
but the final step doesn’t actually update the record. i moved it up in the path & put in 3 spaces by hand, and it works, but not at the end of the loop like that. perhaps there’s something i don’t understand about Looping.
i also tried putting a field in Airtable for groups removed & then using an Airtable automation to remove the values, but it seems pretty clear i’d need scripting for that & i don’t know how to script.
thanks!
