Is it possible to create something like Project cost management in Adalo? How is it possible to link project databases to individual expenses in the project and revenues in the project? Does it have to be a separate database? And is it possible to create a database of expenses and income automatically by creating a project?
@JuchelkaPetr Hi Petr,
my 2 cents on your questions: Is it possible to create something like Project cost management in Adalo?
It depends on the scope. If you are looking for a mobile app to collect individual project cost data, Adalo is a good choice to get started quickly. Especially if you need a branded app with download from app store (PWA also works fine).
You probably will need some kind of reporting calculations, grid/table views.
Adalos capabilities here are still limited. E.g. there is no table view component out of the box. You can build it with custom lists.
If it comes to reporting, date or time related filtering and aggregation is currently almost impossible in Adalo, or only possible with a lot of efforts invested in workarounds.
Combined with Airtable as external database you have a lot more options. Including putting Airtable views into the webview component in Adalo. Though you will need to work around some limitations of the connection between Adalo and Airtable.
With the existing feature set, I personally would go with the combination of Adalo with Airtable.
Using Adalo as Mobile frontend to collect data and Airtable for project management, administration, and reporting.
Does it have to be a separate database?
If you want to separate by user you separate the data in the data model using relations to the User collection.
If you have scenarios in mind to do this for multiple clients/companies you may want to look into copying or cloning of apps.
And is it possible to create a database of expenses and income automatically by creating a project?
In general yes. You create a data model once with all the necessary relations to expenses and users.
You can then create a new project entry and start filling the details related to the project/project id.