Posted by mtg.nampa.net on August 15, 2011 at 11:11pm
I'm new to Drupal. Sorry, if I'm in the wrong group, but I'm looking for the best direction.
I want to create a database table, edit from a single list, but display results on various pages. I've done various database programming before. Drupal has so many modules to choose from, and many do similar things.
I'm just a bit overwhelmed by the variety of directions I could proceed. I'm looking for opinions about modules suited to my needs.
Thanks in advance, MTG
Comments
Editable Grid?
Do you mean like an editable data grid?
If you're used to doing this in ASP.net and visual studio, I'm afraid it won't be nearly as easy as dropping a grid onto a form.
In Drupal, each row has to be a separate "node".
Each node is given a node id which is auto-incremented and shared amongst all nodes.
You would have to create a content type with fields representing each column. This is your table.
From here, you create a view that would aggregate all of your nodes (records) and output them to a grid or any display type that you choose.
You can make any of the fields in your view link to the edit screen or create another common field in the view called "edit" etc. that would link to the edit screen.
This may sound a little complicated at first, but once you get used to it, it only takes a short time.
Best of all, you can add all sorts of filtering and display formats (even mapping and graphing) to augment your presentation.
There are some terrific video's on this very subject at: http://nodeone.se/blogg
Thanks MrPhilbert
Actually, I figured it out before.
Did almost exactly what you suggested though. Views are great, especially the newer stuff in Drupal 7.
same question
Hello,
also new to drupal, have some database experience.
I think I have a similar question: e.g. I have a table (content type) with employees, In another table e.g. projects (content type) , I will ref. to that table. Sounds familiar... but how do I get this in Drupal.
References Modules
There are several modules to help you do this: References, Entity References, Relation etc. There are some terrific video tutorials (free) at http://dev.nodeone.se by a guy named Johan Falk. Make sure you go through the views tutorials first as it seems that just about everything in Drupal pivots off of Views.
There is another module called node reference url widget (whew, what a name!) that allows you to add a link to a node that will allow you to add related content to that node automatically: http://drupal.org/project/nodereference_url. There is a good video from Robert at Mustard Seed Media that shows how it works. The link to this video is on the module page.
MrPhilbert
many to many relationship
hi
if anyone can direct me, i would appreciate that.
i am familiarizing myself w/ drupal (version 7).
i want to create a job board.
i created the following content types:
Company
Job
here are my views:
Companies Displays: Feed, Page In database Type: Content
Jobs Displays: Feed, Page In database Type: Content
Companies Jobs Display: Block In database Type: Content
Users Display: Page In database Type: User
Users Jobs Display: Page In database Type: Content
in the Jobs i have a field that has a dropdown list so you can choose a company the job belongs to.
i want to have a user pick a job (or however many jobs he /she wants) and when i (as a user) want to look at the list of jobs i am interested in, i see them.
i would know how to do this in php and mysql (create a users job table) but i can't wrap my head around how to do it in drupal.
any guidance would be greatly appreciated.
thank you,
efs