About JohnRae

JohnRae

I suggest using google apps script to send the email if you add new files in that folder.

JohnRae

Appsheet has it's own list of icons you can choose from for styling your buttons. There's no option to upload a custom icon to be used as a button.

JohnRae

Use a bot in appsheet to automate the deletion for you.

JohnRae

If you're on a google workspace account you'll be able to send 1,500 mails per day. Refer to this Quotas for Google Services to learn more.

JohnRae

I recommend using a script file from Extensions > Apps Script in google sheets and write a custom formula. Here's a script I've written which you can easily modify: function sendEmailOnEdit(e) { const ss = e.source; const sheet = ss.getActiveSheet();...

My Stats

JohnRae's Bio

Badges JohnRae Earned

Recent Activity

Re: Use data from Google Drive and bot automation

Re: Use an action button customize

Re: appsheet

Re: Service invoked too many times for one day

Re: Sheets notifications for protected tabs