Receive Notifications from Google Sheets When Checkbox is Checked

[Samhappy]

Is it possible without that? I'm new.

[TIMAI2]

Here is a draggable block of the procedure

Click on it once/twice, the drag it onto your blocks editor. You will find the socket block in your procedures palette.

Also, I did not mention that you need to compile your app for all this to work.

[Samhappy]

GSMessageiToo_blank (1).aia (172.7 KB)

I tried, but I'm not getting a notification

[Samhappy]

Here is my gogole sheet

Users

[TIMAI2]

You are setting the wrong gid. You want to fetch the toItoo data: gid=1484678650

May be better to remove all the column and rows from that sheet as well, so that all you have is cell A1.

I did not test for multiple notifications to the same user, you may want to remove any of these first.

You also do not set the uuid, so you would only receive messages for uuid 101.

[Samhappy]

still not work!

[Samhappy]

Right, I'm using UUID 101 for testing now, but it's not working for me.

[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!