The purpose is little difficult to explain, but il try.
I planned to send unique-independent onesignal notification to all my users separately.
And, I planned to achieve this for completely free of cost (without bothering about any quota limits (I don't want the quota limit issues later, so I have chosen this)).
So, I decided to use 'Tasker app + K-9-email or FairEmail' (as suggested by chatgpt). Tasker app will detect when new email is recieved with the keyword 'Apple4321'. Each keyword is for each user. NOTE: Tasker app costs around 3 usd as a one time payment.
The moment tasker app detected the keyword, it will add a new word 'send' in a .csv file near to the keyword 'Apple4321'.
Now, mit ai2 app has to do the following.
a) If the word 'send' is found near to any keyword, then choose the specific onesignal id from that .csv file and send Notification to the apps belong to that onesignal id. In this way, the notification will be sent to the targeted user.
b) After, sending the notification, delete the word 'send' and the process will continue.
All, these (tasker, mit ai2 and k9 email) will work in my mobile phone. So, guide me to achieve this.
Each keyword and onesignal id is/are assigned for each user. So, when the new incommjg email contains any keyword that belongs to any user, the Apps (above mentioned three apps) have to find the onesignal id and assign it in a global variable and send notification to the apps belong to that onesignal id. In this way, i am planning to send notification to the right users precisely.
The purpose of using these three apps instead of trying in alternative method is only because of the reason to avoid Google's quota limit issue in future. I read that Google has quota limit to do what I said in above comments for free of cost. If the quota limit is exceeded then I have to pay regularly to continue the process. So, if I try and achieve in this way, I can skip the quota limit issue, I think so.
So, help me from your side as well while I am trying from my side. Thankyou.
In this part of the project, .csv file contains list of unique keywords and associated onesignal id.
Each email that I receive from a private company will have any one of the keyword in its body. Unique Keyword = Unique user.
So in my phone, when Automation app 'Tasker' detect the keyword from email and check if the keyword is also in .csv file, if so then the word 'send' will be added in the next cell of the key word in .csv file.
Mit ai2 app will constantly watch for the word 'send' in the .csv file and once found , it will assign the associated onesignal id as global variable and send notification. After, sending notification the word 'send' will be deleted, and hence the loop/process will continue in this way.
How can I edit/update data in the .csv file that is in phone using Mit ai2 app? For example, If there is a word 'apple' in .csv file, then delete it automatically. Whenever I add the word Apple (manually) anywhere in the .csv file, it has to be deleted automatically.
How can I edit or update data in a .csv file stored on my phone using an MIT App Inventor app? For instance, if the word 'apple' exists in the .csv file, I want it to be automatically deleted. Additionally, whenever I manually add the word 'apple' anywhere in the .csv file, it should be removed automatically.
It is a bad design choice to use a file as data storage if you have to edit data frequently, because it is cumbersome to work with files
You have to read it completely, edit what you want to edit and save it again...
The question is, why don't you use a database? Depending on the requirements this can be a local sqlite database or if several people need to access it a server database
I am looking for the option that is free of cost forever. I was planning to use Google Sheet, but after I learned that it is not free after certain quota limit, I decided this.
I think, Sqlite database is also not free of cost forever.
But, if I choose .csv file to achieve this, I can make it totally for free of cost forever. So, I can offer apps for totally free of cost to people and play google ad in it. When I get revenue from ads, According to the revenue value, I will use the databases like sqlite or google sheet later.
For safety at beginning, I prefer to use .csv file. I think that the automation app 'Tasker' can save the file frequently whenever there is any update in it. I have to check it, not sure now.
I Did something similar cvs file sent to GSS and deleted after being sent. Then a new file with same name sent again and appended to the GSS. But blocks where lost, after my son was intubated due to covid, but i Will recode.....i Will see if i can find my way back. I Will let you know if i can re do it.
I managed to update .csv file using Tasker in phone (for every email notification from a specific sender), Next thing is to update that same .csv file in a different way using mitai2. In this way, I think I can skip using google sheet or other databases frequently and avoid quota limit issues.
But, since sqlite is free of cost, Il use that as well in part of the app needs.
NOTE: I used Tasker (One time payment around 3 usd), Autonotification plugin (free of cost if we watch a reward ad occasionally) and fairemail (free) for watching email notifications.
