I am unablel to use Computed column

Ask for Help
1

I split a column in 3 and then used array to get it in 3 different columns. Now these columns are computed. I cannot used them any where in fields or in workflows or in IFTTT

2

Hello @Mudit_Goyal :slight_smile:

Some external tools — like IFTTT — expect values in text format that look like arrays. In Glide, when you see values shown as “pills” (sorry, not sure of a better word :sweat_smile:), that usually means they’re being treated as arrays, not strings (correct me if I’m wrong).

Take a look at this example:

List of colors

In this screenshot:

  • List of colors is a string
  • Split in an array (of 3 elements)
  • Slice First Element is an array (of 1 element)
  • Extract First Element is a string

What external tools expect?
They often need the array in a plain string format, like this:

[“Red”, “Green”, “Blue”]


Here are a few different approaches you can try:

Option 1: Use Extract Matching Text + Template

You can extract individual elements from your list using Extract Matching Text columns.

For example, to extract the second value (e.g. "Green") from a comma-separated list, you could use this RegEx:
^[^,]+,\s*([^,]+),\s*.+$

Just wrap the part you want to extract in parentheses.
Then, combine the extracted values using a Template column like this:

Template
Template880Ă—425 24.6 KB

Option 2: Use Replace All
This approach is a bit more advanced but more direct. Use a Replace All column with the following RegEx setup:

Replace All
Replace All528Ă—482 22.1 KB

^\s*(.+?)\s*,\s*(.+?)\s*,\s*(.+?)\s*$
[“$1”, “$2”, “$3”]


The RegEx (Regular Expressions) used here can be generated or tweaked with the help of AI tools if needed — very handy when things get tricky.

Before going too deep into the technical side, make sure this approach actually solves your problem by testing with a plain Text column. If IFTTT accepts that format, then you’re good to go.

And of course, feel free to share more context — a screenshot, sample data (even with fake values), or error messages — if you hit a wall.

Happy to help further :+1:

1 Like
3

What do you expect the frontend to look like?

Some components can only accept a string, not an array.

Tables, for example, can accept a comma-delimited string and format it as tags (aka pills) if you choose tags as the type.

For IFFFT, if it’s like Make.com, you can find an option to split the string over there to process it as an array, rather than trying to do it in Glide.