Hello there!
I’d like to know if there’s a way to optimise an operation linking a form submit to Slack notification, based on specific conditions.
Context:
I have a table of ~1000 rows listing the issues raised with our product + the solution we provided.
It is populated by the users filling the form on the Glide app, and is connected to Google Sheets.
What I want:
When submitting the form, IF the type of issue = “Sales returns” AND IF the solution offered = “voucher” → notify us on our Slack channel.
What I did:
- I created a template field “A new report from [agent] has been reported, we need to create a voucher [amount] [currency] etc.”
- I edited the action from the “submit” button with a IF condition, connected Slack and selected the template field I created early on.
The workflow runs properly. However now, all my 1000 rows are storing a long template text (the Slack notification message), even if only 1% of my cases will meet the conditions to activate the Slack scenario.
My questions:
- Can a template field like this impact the performance of my app?
- If yes, would there be a smarter approach in order for the Slack message notification not to be stored in every single row, but only when the conditions are met?
Thank you!