Like this?
your event handler for the GotText event, which is called fetchMessage must have the same arguments as the GotText event
You provided a screenshot of your GotText event... Are you aware, that your GotText event will not run in the background, it is the fetchMessage event handler instead
Taifun
1 Like
When I use Click button for checking it's working but with background stil issue
Here is by using button click:
I've small issue:
I would NOT Iike to show as a notification if it's new added item.
I would like to get notification only when I change from spreadsheet value "pending" to "active". This part working for me.
BUT when I'm adding new item its adding to my spreadsheet and it's showing all old "active" status as a notification. I would NOT Iike to show as a notification if it's new added item. Please help.
please note all new added items it's as a default "pending"
Here is my code:
What about introducing a new status, for example 'semd notification '? Then read only the rows which have status 'send notification ', display the notification and after that update the corresponding row in the spreadsheet and set it to 'active'?
Taifun
@Taifun thank you for your response.Approciate your efforts and time.
Actually my code it worked before I don't know maybe I made some change anyway.
Actually when I'm sending item from my app to google sheeet H columb row status "Pending" by default it's filling. at that time i'm getting notification all "Active" (which is not correct.)
Regarding when I just change from google sheet status "Pending" to "Active" I'm getting notification (which is correct).
If it's possible please help me to solve in a simple way. For me everytime building Apk for checking getting very difficult. ;(((
As far as I can see you need a new status to be able to find out, when a notification needs to be sent and after that change the status to something else
Taifun
you think it's impossible to ignore all notification if status "pending" ?
I just want ignore(don't want to see) all notifications if status "Pending" that's all.
I guess here must be used if function
What about changing your select query and reading only those rows, from the spreadsheet which have status active?
... AND H = 'Active'
Taifun
I tried in that case I'm recieving all active status notification ;((
Yes, my understanding was, that this is what you want
Taifun
No, no sorry my English.
Actually I need to receive notification if from Google sheet Changed pending status for Active. Please note Old active no need to show as a notification.
But in this case when I start app I’m receiving all active status. Which i not changed anything
I should receive only if I changed pending to active status. Let’s assume I’ve 100 rows from these 100 rows 90 already active as a old, and 10 are pending so if I change from these 10 pending , 2 active these 2 active must show as a notification .
So conclusion: I should receive notification only if I’ll change from pending to active specific changed rows
Only show notification each time if will happen new changes from pending to active otherwise NO need to show all notification active each time.
That's why I suggested to
If you do not want that, you have to keep a list in your app of rows you already sent notifications to find out, which ones are the new ones
Taifun
@Taifun thank you so much for you help.
I did some manipulation and it's working.
Here when I'm sending first I'm storing status
Then I'm doing this manipulation
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.