Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By litebulb1 on
Im looking for a module that would allow me to create a custom table and then allow me to edit view query the table. If you know anything like this please let me know. thanks.
Comments
A couple of choices depending on your goals
A couple of choices depending on your goals. From what you said I would recommend the Content Construction Kit (CCK) module (aka content module) and the views module. CCK allows you to construct custom content types while views allows you to build queries.
You may also want to check out the webform and webform report modules.
I am actually looking for a
I am actually looking for a module that would use a separate sql database to store the information. The module would have some drop down options for searching, editing, view etc. I think it would be some sort of GUI to go on top of the sql database.
does anybody know what I'm
does anybody know what I'm talking about when I refer to a front GUI database module?
Im looking for a module that I can keep track of all my clients with. The database needs to hold all the obvious information like name address phone but after that it needs to be very flexable. For example if I purchase a computer for a client I would like to add several fields to that particular clients record. Like I would like to add purchase date, CPU speed, serial number...
Does anybody know of a module that would be able to do this for me?
Once again I suggest checking out the CCK module
I think the Content Construct Kit (CCK) module would serve you well just not in the way you are approaching the problem. With it you can construct at least a couple content types, one to hold client information (name, phone, address, etc) and another that holds transactions/purchases (could even be more than one content type). These content types could then have a field that references clients. Add in views to generate lists/reports and I think you are good to go.
I'm looking for something
I'm looking for something similar. I think the webforms module has potential, but would maybe need customising. I don't really understand CCK enough to see how you can use it for queries in the way you (and I) want.
Views qworks on nodes
Views qworks on nodes and CCK types are nodes so views lets you put together list of nodes (as teaser or full node), lists or tables of fields you choose. You can apply filters (for example so it only shows your node type) and much much more. By best advance is take it for a test drive.