Is it possible to loop over a list e.g. SPLIT(“email1, email2, email3”, “,”) and for each email create a row in a table?
Yes, there is a SPLIT() function that can do this.
Well I know there is a split function, the question is can I loop over it somehow?
Not directly but you should be able to do that with the Webhook / Appsheet API.
The part that is a problem is “create a row”. We don’t yet have an action to create a row in another table. Once we do, it will become easier to support this kind of composite action.
Yes, this is indeed missing. I ended using zapier-code, it gets very complicated to do it in appsheet. I almost managed to simulate a loop with Action and Workflow, but the workflow does not response to a second event on a table in the same round.