# How to separate/concatenate numbers and send sms

**URL:** <https://community.glideapps.com/t/how-to-separate-concatenate-numbers-and-send-sms/63041>\
**Category:** Ask for Help\
**Created:** [June 22, 2023, 9:21am UTC](https://community.glideapps.com/t/how-to-separate-concatenate-numbers-and-send-sms/63041 "2023-06-22T09:21:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Official\_Giop](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/official_giop/32/56387_2.png) [@Official\_Giop](https://community.glideapps.com/u/Official_Giop)\
**Post date:** [June 22, 2023, 9:21am UTC](https://community.glideapps.com/t/how-to-separate-concatenate-numbers-and-send-sms/63041/1 "2023-06-22T09:21:34Z")

</div>

Hi, I have the following problem:  
I have a user table that contains all info about my users including telephone numbers.  
I have then another table that contains a row for each lists of users that I pick/choose each time based on some reasoning.  
In this “lists” table I have a column with the references of all telephone numbers of all users that then I separate in another column with a comma like: TelNumb1,TelNum2,TelNumb3… the problem is that since this column is a “calculated column” it is not shown in the “compose sms” component.

The final goal is to compose a sms with comma separated telephone numbers (it works only with Android).

The only workaround I found so far is to use a Google Sheet letting it to compose the list of separated numbers. But this is not the best solution for me, also because I have had to create a script with a trigger that every minutes execute the formula for new rows… very slow.

Any suggestions are more than welcome!

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [June 22, 2023, 11:59am UTC](https://community.glideapps.com/t/how-to-separate-concatenate-numbers-and-send-sms/63041/2 "2023-06-22T11:59:26Z")

</div>

You might be able to leverage something like Make+Twilio and iterate through your list.

For your existing setup I’d suggest switching to an onChange trigger.