Is it possible to loop over a list e.g. SPLIT...

(Yossi Oulu) #1

Is it possible to loop over a list e.g. SPLIT(“email1, email2, email3”, “,”) and for each email create a row in a table?

(GreenFluxLLC) #2

Yes, there is a SPLIT() function that can do this. - SPLIT() SPLIT()

(Yossi Oulu) #3

Well I know there is a split function, the question is can I loop over it somehow?

(Aleksi Alkio) #4

Not directly but you should be able to do that with the Webhook / Appsheet API.

(Praveen Seshadri (AppSheet)) #5

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.

(Yossi Oulu) #6

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.