Hi!
I’m floundering a bit with a Zap I’m trying to create and I’m hoping some of you may have suggestions or a solution.
Background/Context: We have an AirTable Database set up to collect project records. Whenever a new record is entered into the AirTable database, it automatically creates a Slack Channel using some of the info from fields in that record. In my case the naming protocol for the Slack Channel is:
“(Grantor)-(Project Name)-(School)-(Project ID)”.
The Zap I’m currently trying to create:
When a project is finished I want the corresponding Slack table to archive.
The issue:
The issue I’m running into is that Zapier cannot locate the Slack channel name even with my inputting the dynamic fields I referenced above. I understand why it can’t, but I can’t figure out how to fix it since there is no function to look up a Slack channel (that I know of). Right now the problem is that the zap is pulling these fields in and many of them contain spaces in the entries. But Slack automatically inserts hyphens between all words. I can’t figure out how to accurately tell it what record to look for or format the info it’s pulling in a way that slack will understand. I cannot change the entries in AirTable as these are entered by hundreds of different users and there’s no way I can get them all to use (or in some cases even understand) a required naming protocol.
Thoughts?