oh my good, the "holy grail" just what I've always been looking for, fantastic Saif, a great new project.
It's been released
Do you mean a rental tracker?I have this idea of making an app in B4A using Google Drive.
It is for Apartment (Housing building) collection and expenses, with due list, defaulters, high expenses etc.
The app has two settings for 'Accountant' and 'Members'
In Accountant setting the inputs are done in B4A app and saved in sqlite and csv/json is generated and saved in GDrive as a zip file.
In Member setting the csv/json zip file is downloaded from GDrive and presented all reports, views etc. with search facility.
No two way communication of data here. Members can send WhatsApp or make call to Accountant or other members. Only Accountant can update the database.
Now the zip file in GDrive needs to be shared (public / or each members email) and that shared link added in each member app setting. This can be done manually by Accountant and link shared.
In this pandemic time most people income has reduced and maintaining a server cost is very difficult, at least in India. (One of my friend of another Forum had to ask for help the cost of server). So I was thinking more on the line of using GDrive as free server, where the data flow in one directional and small.
Note : only Android B4A here as many members do not have computers.
Not in that sense. Let me give some background.Do you mean a rental tracker?
A few years ago I created a very basic My Tenant app. That time I am not good in B4A, PHP and JSON. I updated it once and it has been abandoned till now. I don’t use GDrive but MySQL database in a shared hosting.
Manage the server yourself and give them an app to read data and one for the yearly manager for his/her duties.Keeping or maintaining a server is like overkill for them both from point of view of data and knowledge.
Each member pays an yearly fee (eventually as part of their apartments expences) and the manager in charge pays you (so you need just one invoice).
So, I am trying to help members with coming up a simple and free solution, if possible.In this pandemic time most people income has reduced and maintaining a server cost is very difficult, at least in India. (One of my friend of another Forum had to ask for help the cost of server). So I was thinking more on the line of using GDrive as free server, where the data flow in one directional and small.
Yes!! Something like PhpMaker, PhpRunner or ScriptCase. These are examplesof what Jose is describing.Hi @sfsameer . I've seen your team is doing now web apps with B4J, and that's great.
Maybe you can try to make some web maker database driven. (like some php generator apps), althouht I think it's a very ambitious project... but... I've seen most of your projects are.
I will try to explain it...
- You have a B4J app, where you enter your database parameters, and the app reads all the tables in your database.
- Then you choose for every table what want to do: add, delete, insert... or not to show it.
- You can set some relations between tables
- You chose some kind of theme or color scheme...
- Then automatically generate a CRUD web for that database
- More advanced features could be choose a users table to make login, table permissions based in users, etc...
It's amazing the things you're doing with B4X¡¡¡
even i'm interested., hope you consider,we already developed it long time ago and we already have a plan to release the source code next week
don't worry we will send you the source for FREE
The app is made in :
1- B4A project
2- Asp.net back-end
3- Microsoft SQL Database
4- Sqlite Dtabase
5- Asp.net Web Service