User-Specific Form Submission and Slack Notification Automation

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!

Most computed columns become user specific if they are fed data from user specific columns. They compute directly on the user’s device, so the experience is already unique to them.

The action would be triggered by your submit button. If you create a custom action, you can execute several individual actions with the same button.

2 Likes

Thanks for helping affirm that logic!

I think I got confused when the values wouldn’t clear within the table when I was testing. But I sent it to a couple devices to test in different browsers and didn’t encounter an issue.

Thanks!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.