# Figuring out how to display 'current status'

**URL:** <https://community.glideapps.com/t/figuring-out-how-to-display-current-status/24767>\
**Category:** Ask for Help\
**Created:** [March 26, 2021, 3:06pm UTC](https://community.glideapps.com/t/figuring-out-how-to-display-current-status/24767 "2021-03-26T15:06:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Milwaukee\_County\_Par](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/milwaukee_county_par/32/4726_2.png) [@Milwaukee\_County\_Par](https://community.glideapps.com/u/Milwaukee_County_Par)\
**Post date:** [March 26, 2021, 3:06pm UTC](https://community.glideapps.com/t/figuring-out-how-to-display-current-status/24767/1 "2021-03-26T15:06:17Z")

</div>

Hi all,I’m looking for some help with a ‘current status’ feature in my app.

I have a choice component feature in our app that allows an admin user to change the ‘open status’ of a venue. The specific use case is that when we close a beer garden due to the weather, the beer garden manager can change the status to ‘closed due to weather’

At the moment the choice component updates a column which shows on the venue page - but I’d also like to trigger a notification when the status changes. The Zapier ‘update spreadsheet row’ trigger doesn’t work as it only triggers if the cell content is new - so switching between open/closed won’t trigger.

So I’ve tried using a form instead, and it almost gets me there - the form allows me to trigger notifications, but I couldn’t figure out how to update the correct row - as a form submission appends a row onto the sheet. So I’m now using a seperate sheet to collect form entries, and a relation column to connect the venue to the status - but I only want to show the most recent status, not link to all statuses.

Any suggestions on how I can achieve this?

Here’s the app: [https://mkecountyparks.com](https://mkecountyparks.com/dl/ewAiAHQAIgA6ADAALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AQQB0AHQAcgBhAGMAdABpAG8AbgBzACIALAAiAHIAIgA6ACIAWQAtADUARwBPADcAcwBoAFEAWABpAHcAVgA5ADkAMQBXAE0AWgB1AFoAdwAiACwAIgBuACIAOgAiAFcASABJAFQATgBBAEwATAAgAEIARQBFAFIAIABHAEEAUgBEAEUATgAiAH0A)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 26, 2021, 3:08pm UTC](https://community.glideapps.com/t/figuring-out-how-to-display-current-status/24767/2 "2021-03-26T15:08:26Z")

</div>

How about a Webhook?