Hello Gliders,
How can I set up an email notification in Glide when a certain threshold is surpassed in a sum calculated within my Excel table. Is there a native way to achieve this?
Thank you a lot!
1 Like
So do you have Excel/Google Sheets as your backend? Are you using a Glide computed column for this use case or formula in your Excel/Google Sheets?
How is the relevant number calculated and is it changed based on a user action?
2 Likes
Thanks for the response!
Yes I have Google Sheets as backend
I am using a Glide computed column for this use case - simply calculating the sum of all transactions. It is not related to any user action . In the dashboard the “big number” module is showcasing the sum from the computed column. What i want is simply a notification email and a warning sign (or the big number turning red for example) when a certain threshold is reached.
Thank you a lot
If you have it as a Glide computed column, and a form submission is powering the “sum of all transactions”, then in a form environment, you can have an on-submit action that:
- Checks if the “sum of all transactions” is greater than the threshold.
- Send an email if the threshold is surpassed.
I don’t know if the sum can be calculated in time, but that’s something you can try.
Thank you Thinh! Appreciate it!
However there is no “form submission” I am just monitoring a google sheet table and calculating a sum with every new transaction being added. (or is this what you mean with form submission?)
Yes, I meant how are you adding rows to that table?
@ThinhDinh they are being added automatically through a Make scenario Stripe > Google Sheets.
@ThinhDinh Can you think of any solution ? Or shall i modify anything to achieve it?
I don’t think there’s a good way to do it. Even if you have access to Business/Enterprise to query Glide tables, you would still have to replicate the logic to get your calculated number, since you can’t get computed column numbers from the API.
Is it straightforward to pull single transaction values? Is it a basic column or a computed column itself?
Are you open to doing this with Zapier or Make?