Glide's Community Built Messenger

[Darren_Murphy]

@Mauronic

Also, that message bundle sheet requires the formula in column C to be manually copy/pasted down the sheet because array formulas won’t work here. This would require a script to maintain, perhaps the same one that would also periodically clear chat history to minimize row usage.

This might be useful for that… (the first bit)

Scripts, scripts, scripts!

Here is another one that I use all the time as an alternative to ARRAYFORMULA. The neat thing about this is that it works with any formulas, whereas ARRAYFORMULA has some limitations. Again, I didn’t write this one myself, and I can’t recall where I got it from (probably Stackoverflow), so I can’t take any credit for it. But I’ve been using it for 3 or 4 years and it’s never failed me. What it does and how it works is described in the comments.

Summary

/** * Copy Formulas Down * This script…