I’m seeking assistance with an issue I’m encountering in my Glide app related to user-specific form submissions and triggering Slack notifications.
Here’s the scenario:
1. App Setup:
• I created an app (Glide tables) with a form screen anyone with link can fill out. This form is designed with a custom container, utilizing various choice and text entry components.
• Each of these form fields is user-specific.
2. Data Handling:
• The user-specific form inputs are stored in a “Form Table.”
• Upon submission, these inputs are transferred to another table, let’s call it the “Result Table,” where all the user-specific values land.
3. Notification Requirement:
• I want to create a notification template using a template column that pulls data from the “Form Table” to send to Slack.
• The challenge is that if I add a template column to the “Form Table,” it is not user-specific. This results in the creation of multiple records in the “Form Table” instead of maintaining a single row per user.
4. Automation Trigger Issues:
• I need to trigger an action to send a Slack message based on the data in the “Form Table.”
• If I attempt to do this at the “Form Table” level, the template column is not user-specific, which complicates the automation.
• If I try to trigger the automation at the “Result Table” level, users don’t interact with this table directly, making it difficult to set up the trigger using the Actions set-up page.
Question:
How can I set up my Glide app to:
Maintain the user-specific form submissions, and trigger an Action - Slack Notification based on a Template column on that submissions value.
I would greatly appreciate any guidance or suggestions on how to resolve these issues.
Thank you in advance for your help!