Database
jack-s
So that you can hold different kinds of data.
.
Inspiration: Notion
Log In
p
patrickw
Currently when I make a new block the data in that block is isolated from the data in another block.
But what would be great if the data from all blocks lands in the same database. And then I can make blocks that query that data across blocks while preserving the permissions.
This would allow creating a block that has all tasks across projects, a calendar across projects, a Gantt chat across projects.
And when data is updated there it's updated in the original block and also everywhere where it's referenced....ie like a database
Narek Zograbian
patrickw: This seems like you're asking for something like a Relation field. Did I understand you correctly?
p
patrickw
Narek Zograbian I love the idea of a relation field and yet I wasn't asking about it. What I was asking about is that the following...
- i have ProjectA, ProjectB, ProjectUnion
ProjectA has a table with Task1 and Task2
ProjectB has a table with Task3 and Task4
Now I want in ProjectUnion to query both tables in my table and with that see Task1-Task4...
This opens up so much more possibility then have every project be a data silo.
Each table would have a "source" column from where the table is from and Ie ProjectUnion could group by that field...
Having a relation field between different tables would open up even more possibilities...
And I get that all tables have different columns and also same columns...
ProjectUnion has both the same columns and displays data from both in there and the separate columns and only displays data from one in there
p
patrickw
Narek Zograbian does it make sense to you?
Narek Zograbian
patrickw Ah, I see what you mean. Basically you want a table that can collect/source data from multiple tables in Taskade.
Did I get that right?
p
patrickw
Narek yes and I want it to be a first class citizen in the architecture. away from isolated data so that it's all stored together and each table is really just a view on the combined data...
With that in place an agent could also make database queries if permitted, or I could add a query to a chat with an agent so the agent can respond or update data.
It could really be a database in the backend with snapshots, versions, diffs etc
r
ryantaskade
Merged in a post:
AITable.ai - Build your own spreadsheet-style databases for better project management and CRMs
amiralbatal
Create ChatGPT-powered chatbots and AI agents trained on company data for customer support, sales, and internal operations
Build spreadsheet databases to manage projects and keep track of customer relationships
Narek Zograbian
Hey there! If we allowed for customizing the action view with your own custom column, would that fulfill this request?
Or are you looking for a standalone database?
jack-s
How would such a solution work?
I guess the database is something else?
infosync
Narek Zograbian: I think that would be a great start. Each custom column could have a defined data type or capability. For example, a data type can be standard like characters, integers, etc., or something like a selectable list. Other features could include importing and exporting data, and using AI within cells or in bulk across rows.
Narek Zograbian
infosync: Exactly! That's pretty much the way it would be. You'd set the "data type" and then simply fill out the list. It would work similarly to how Notion handles tables and databases.
marco.ceruti
This single feature is what makes Notion the best at what it does. The fact that you can customize a category of content inside your dashboard is invaluable. I would love to have something like this in Taskade, it would make my life much much easier.
It's also mandatory for large and enterprise companies, since it let them work in a more structured way
r
ryantaskade
Merged in a post:
relational database
Ip Man
Similar to how notion has their relational databases plus the ease of use and design of taskade would be a good combo.
jack-s
Possibility to present the database in the form of a table.
p
patrickw
jack-s is that notion?