Receive Notifications from Google Sheets When Checkbox is Checked

[TIMAI2]

Are you compiling and installing your app for testing ?

Delete all columns and rows except for cell A1 in your toItoo sheet.

[Samhappy]

This one is appearing

without any message

[TIMAI2]

@TIMAI2

Delete all columns and rows except for cell A1 in your toItoo sheet.

You have not done this yet.

[Samhappy]

[TIMAI2]

That's better

[TIMAI2]

I have just seen that you have not updated the itoo extension to the latest version - itoo.v4.4, maybe this is the issue.

A blank aia for you to test:

GSMessageiToo_Ind_blank.aia (151.4 KB)

[Samhappy]

@TIMAI2 Now it's working, thank you so much!

[Samhappy]

Interesting method! Could you provide the app-side file? I'm just interested in this new method.

[TIMAI2]

It would initially be much the same script as mine, but then either:

• send an email/emails to the user/s checked using GmailApp (from the google account running the script - note the quota of 100 emails a day for a personal google account)

• use a third party push notification service to send notifications to each user, with their message. There are Paid extensions on the community for OneSignal and FirebaseClopudMessaging.

[Samhappy]

sending emails are not a solution for me. Your Provided free extention is much better.

[Samhappy]

How to make each time checkbox is checked it must move to A cell next rows

[TIMAI2]

You will have the history in your other sheet. If you entered these with a timestamp, you could then sort with the script after processing...

Do not mess with the single cell sheet!