All I really need is simple CRUD, and search. I know I can do this with Flexinode.
Problem is: editing is difficult with flexinode, and I need to do a fair amount of editing. I hate having to go back and forth to a different page everytime I want to edit something. Also, how to edit the particular record is not immediately obvious, and other people have to use the database.
Ideally, I would like to be able to edit records in place, like with a spreadsheet. If not that, then a simple form on the same page. The simple form on the same page, is what I have now: a scrollable grid on top, and a place to edit the fields on the bottom. I click on a record, and the fields populate, I can then chose to edit, delete, or whatever. There is also a search field on top. What I have now is implemented in PHP. Can this be done with Drupal?
Comments
I'm working on something
I'm working on something similar, and right now am doing it as a custom module (though this may be more pain than gain). For your purposes, I think you could do the following with less code than a full module:
1) put PHP code in a page to generate a table of entries (using theme('table') and theme('pager')- see #2)
2) Include in the table a link to edit each node (populate the destination query string so you'll be returned to your list after editing- see, for example the code in node module that generated the admin/node page), and a link to delete each node (if desired).
3) search field on top could just be a a block with the site-wide search form. I don't think there is an easy way to search within the table unless you do it via the path, etc.
Making the table, etc could also be done (I'm sure) with the Views module or via other methods- I just have never used it yet.
You can look at my in-development code (For Drupal 5) currently in my sandbox.
---
Work: BioRAFT
>>Making the table, etc
>>Making the table, etc could also be done (I'm sure) with the Views module or via other methods- I just have never used it yet.<<
I don't think Views would allow for easy editing.
module
See also the Inventory Management module:
http://drupal.org/project/inventorymangement
---
Work: BioRAFT