I’ve setup a coda document to have a list of features. Those features have owners and then a testing state. When a tester marks the feature as passed testing a slack message is sent to our group channel saying that the given feature passed testing.
I’d like to @ the specific feature owners that are tied to that feature in Coda.
I already have a table of all our engineers and their unique slack handles. You can’t just input ‘@garrett’. So I figured that problem out but now I’m stuck on step 2. I need to take in the list of feature owners and add their unique slack handles to the concatenated message.
I’ve created an example of what our current document is like.
If anyone can assist with this I would greatly appreciate it!
@Garrett_Frey
Took a quick look at your doc and I think this formula should do that you are looking for -
This is for Design Testing -
Concatenate(thisRow.[Feature Name]," on MUT “,thisRow.[MUT Number],” has passed Design Testing “, FormulaMap(Owners.Filter(thisRow.[Feature Owner(s)].Contains(People)).[Slack Handle].ListCombine(), RegexReplace(CurrentValue,”@" ," @" )))
This looks a little crazy
FormulaMap(Owners.Filter(thisRow.[Feature Owner(s)].Contains(People)).[Slack Handle].ListCombine(), RegexReplace(CurrentValue,"@" ," @" )
But what I am doing is Filtering the Owners table to get the slack handles for the people in this row.
The result is a list of handles.
I use Listcombine to make it a string.
Then RegexReplace to add space between the handles.
Hope this works and helps!
Hey @mallika and @Garrett_Frey, great to see that you got this working.
I’m working through a similar issue at the moment and I think this solution will work but I’m having difficulty getting the row fields that I’m trying to insert into the message to work.
I’m doing this through an automation and am wondering if you were doing the same thing @Garrett_Frey or whether you were using a button?
@Harry_Harrison I used a button. I haven’t played around with automations at all so I’m not sure I can offer assistance there. The buttons were pretty straight forward though.
