# Threshold notiication **URL:** \ **Category:** Ask for Help\ **Created:** [March 11, 2024, 9:17pm UTC](https://community.glideapps.com/t/threshold-notiication/71603 "2024-03-11T21:17:22Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![We\_the\_Makers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/we_the_makers/32/69750_2.png) [@We\_the\_Makers](https://community.glideapps.com/u/We_the_Makers)\ **Post date:** [March 11, 2024, 9:17pm UTC](https://community.glideapps.com/t/threshold-notiication/71603/1 "2024-03-11T21:17:22Z")
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! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 12, 2024, 12:43am UTC](https://community.glideapps.com/t/threshold-notiication/71603/2 "2024-03-12T00:43:03Z")
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? ---
**Author:** ![We\_the\_Makers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/we_the_makers/32/69750_2.png) [@We\_the\_Makers](https://community.glideapps.com/u/We_the_Makers)\ **Post date:** [March 12, 2024, 8:23pm UTC](https://community.glideapps.com/t/threshold-notiication/71603/3 "2024-03-12T20:23:35Z")
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 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 12, 2024, 11:08pm UTC](https://community.glideapps.com/t/threshold-notiication/71603/4 "2024-03-12T23:08:14Z")
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. ---
**Author:** ![We\_the\_Makers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/we_the_makers/32/69750_2.png) [@We\_the\_Makers](https://community.glideapps.com/u/We_the_Makers)\ **Post date:** [March 13, 2024, 12:33pm UTC](https://community.glideapps.com/t/threshold-notiication/71603/5 "2024-03-13T12:33:07Z")
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?) ![Screenshot 2024-03-13 at 13.32.36](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/8/e8fa3db8661474ac8633df50f7c9808410df3861.png) ![Screenshot 2024-03-13 at 13.31.46](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/c/5c542a6c4675abac36ba40a800efa081647ca485.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 13, 2024, 3:16pm UTC](https://community.glideapps.com/t/threshold-notiication/71603/6 "2024-03-13T15:16:52Z")
> [@We\_the\_Makers](#): > > 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? ---
**Author:** ![We\_the\_Makers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/we_the_makers/32/69750_2.png) [@We\_the\_Makers](https://community.glideapps.com/u/We_the_Makers)\ **Post date:** [March 14, 2024, 7:56am UTC](https://community.glideapps.com/t/threshold-notiication/71603/7 "2024-03-14T07:56:58Z")
@ThinhDinh they are being added automatically through a Make scenario Stripe \> Google Sheets. ---
**Author:** ![We\_the\_Makers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/we_the_makers/32/69750_2.png) [@We\_the\_Makers](https://community.glideapps.com/u/We_the_Makers)\ **Post date:** [March 15, 2024, 9:49pm UTC](https://community.glideapps.com/t/threshold-notiication/71603/8 "2024-03-15T21:49:11Z")
@ThinhDinh Can you think of any solution ? Or shall i modify anything to achieve it? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 15, 2024, 11:23pm UTC](https://community.glideapps.com/t/threshold-notiication/71603/9 "2024-03-15T23:23:47Z")
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? ---
**Author:** ![mattwensing](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattwensing/32/72905_2.png) [@mattwensing](https://community.glideapps.com/u/mattwensing)\ **Post date:** [March 31, 2024, 5:06pm UTC](https://community.glideapps.com/t/threshold-notiication/71603/10 "2024-03-31T17:06:11Z")
Are you open to doing this with Zapier or Make?