I am still pretty new to Appsheet so sorry if I have missed this. I am looking to send an email to 1 or two users whose emails will be in child records of the table where the send email action goes.
I can get the list of emails using the virtual column pointing to the child records. However, this returns a list.
So I am looking for a function doing the opposite of SPLIT() but I can’t find one. In PHP. split is the same as explode() so I guess I am looking for implode().
I think it can be done using CONCATENATE and sorted SELECT statements but it seems a bit cumbersome, in particular if you don’t know if you have 1, 2 or 3 child records.
Is there an easy way to do this?