Hi All, I’ve set up a DM function on my app using comments. Each user can create a DM with another and exchange messages via comments. This has been the easiest way for me to set up a DM. Here’s how it works: User A clicks on a DM button on User B’s profile An inline list appears creating a DM between User A and User B In a Google sheet called “Chats” a row is added with the emails of User A (sender) and User B (receiver), as well as a unique Chat ID. Once in the chat, User A and User B can comment (message) each other A new row is added in the default Glide “Comments” Google sheet Now for the problem: I set up a vlookup, pulling the Chat ID and from Comments and using that to find the recipient of the DM (comment). However, the vlookup only works when details are pre-populated. I.e. it doesn’t populate properly when new rows are added. Does anyone have any tips? I’d like to set it up such that each time a new DM (comment) is added, the person the DM is intended for gets a notification that they have a DM. I have no problem setting up the email, but it’s the logic to get the email to the right person that’s tricky!

[image] saucy: I’d like to set it up such that each time a new DM (comment) is added, the person the DM is intended for gets a notification that they have a DM. Are you using an add row action or a form to create new “comments”? Or is it the “comments” component in Glide Apps?

Comments component - that’s what I’m referring to by “default Glide Comments” sheet

[image] saucy: I set up a vlookup, pulling the Chat ID and from Comments and using that to find the recipient of the DM (comment). However, the vlookup only works when details are pre-populated. I.e. it doesn’t populate properly when new rows are added. Do you use a normal vlookup formula or have you looked at arrayformulas? [image] Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts Ask for Help Hi, Today I will show you the script that can make copying formulas down work, when it does not work with arrayformula. But first, let’s have some introductions about arrayformula, for those who has not used this before in Google Sheets, some equivalents in Glide and some good practices while using it. I hope it can help you in building your Glide apps as well as applying it in your normal day job. 1/ Definition Arrayformula is defined as “a range, mathematical expression using one cell range …

Creating email notifications each time a comment is added

Ask for Help

ThinhDinh December 11, 2022, 12:14am 4

Do you use a normal vlookup formula or have you looked at arrayformulas?

Topic		Replies	Views
How to notify a new comment? Ask for Help	2	268	May 17, 2022
Zaps based on comment activity Ask for Help actions	9	1017	February 4, 2021
Notification (email) when forms submitted Ask for Help	46	5705	July 30, 2021
I need some pro advice on showing new comments Ask for Help	10	950	November 19, 2020
How can i access the comments table? Ask for Help	5	499	June 14, 2022

Creating email notifications each time a comment is added

Related topics