Hi all,
I have an app where peope can react on ideas.
Of course I know that notifications in the classic sense are not possible on the Mac. But what would you do to make the people concerned know there is a new reaction? These are my two ideas, but I know there are far more experienced people in this field.
My two directions:
Visible. When a new comment on a topic is added, a new row is added so an action can follow (higher number, different image).
Via mail. When a new comment on a topic is added, a new row is added so a mail to the idea-owner could be sent with a Zap as trigger.
Do these directions make sense, or would you do it different?
ADDED| plus: how do I get to the App:comments sheet that is in GS? Glide doesnt see it?
I can’t remember who but there’s someone who, recently, accomplished something like this using the popup modal that @Lucas_Pires posted a few days back.
If you want to use the data from App:comments elsewhere in your app, you can create another sheet and then use an arrayformula or query formula to keep the data in sync. I do this for my App:logins sheet. The formula looks like:
=QUERY({'App: Logins'!A1:A}, "SELECT * WHERE Col1 <> ''",FALSE)
What I do is as you said. Duplicate a sheet so Glide can see it, take the latest comment to show it on the “front”. The email is taken care of by the Zap, which doesn’t need the duplicated sheet anyway.
A thought would be to bring the same value using single value to all tabs that you want the modal, then when an action happens then a condition will hide the modal.