By Fransie on

I have installed Drupal and have been looking through the Drupal website but I can not find one particular feature I'm very interested in: using tables as building blocks. I don't mean HTML tables, but database tables. That is, tables that you can edit, sort and filter and maybe relate to other tables. It would be nice if there was a friendly user interface for creating a table, editing data, sorting and filtering. Tables like this could be used for all kinds of purposes, like task lists, inventory lists, etc. It could be that I have overlooked something, any pointers will be much appreciated. Otherwise, wouldn't it be a nice idea to have something like this? I think it would also make a nice base(module) for other enhancements..

Regards,

Frans

Comments

iraszl’s picture

iraszl commented

You mean like an Excell spreadsheet? Nice idea!
---
http://creativebits.org

Fransie’s picture

Fransie commented

Yes, something like that. Some kind of control for the first setup of the table (specification of columns and datatypes (text, numeric, ..) or later modification of the table would be needed. The table could be displayed as a grid, just like an excel spreadsheet, yes. Only the data will not be stored in Excel format but in the MySQL database of course..

From your reaction I gather that something like this does not yet exist :-)

Frans.

sofiya’s picture

sofiya commented

I guess it does exist: Database Module.
Is that what youre looking for? :)

"If you build it, they will come." -- Field of Dreams

Fransie’s picture

Fransie commented

Maybe it is. I will give it a try, but I have some doubts if I read the description. I would like all users to be be able to add tables to the website, but not to let all users adminsiter the database. I will post my findings later..

sepeck’s picture

sepeck commented

The Database Administration module will not do what you are looking for. You should NOT give your users access to it.

I do not think what you want currently exists in the current modules repository.

-sp
---------
Test site...always start with a test site.
Drupal Best Practices Guide

-Steven Peck
---------
Test site, always start with a test site.
Drupal Best Practices Guide

Steven’s picture

Steven commented

Flexinode sort of has this. Its search output is in a table.

--
If you have a problem, please search before posting a question.

JohnG-1’s picture

JohnG-1 commented

I was wondering about using flexinode to create dynamic user spreadsheets ...

OK the data entry/edit form is straight forward enough.

I'm struggling with how to get a tabular display of all data in nodes of one type (call it 'spreadsheet' node).

I've been playing with the 'database' feature for yahoo.groups and it's pretty useful, though the functionality is very restricted.

I'm really looking for a simple accounting system within drupal, so functions like column totals would be rather helpful features!

Any thoughts or suggestions welcome.

JohnG