Creating email notifications each time a comment is added

[ThinhDinh]

@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?

Tutorial: Arrayformula in Google Sheets, good practices & how to overcome Arrayformula restrictions with scripts

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 …