By volvo760 on

Hi guys,
I'm trying to figure out if I can make a simple mysql database front-end using Drupal 7.

Basically, I have a shop, in wich for each client I need to take an order, fill out a basic paper form. I want to turn these forms in a simple web-app, build a content type in Drupal and fill them online, also giving me the possibility to search them using any data from any field.

What I want is, a form wich can have:

  1. simple text fields
  2. auto-incrementing number as ID
  3. date field with default value being the current date
  4. some sort of table, with columns
  5. autocomplete feature in some selected fields, with values being taken from previously entered data.
  6. print or export the form as pdf

I know there are hundreds of modules out there, but I was wondering if there is one you can recommend me for start.

Thanks!

⋅ Categories: Drupal 7.x

Comments

WorldFallz’s picture

WorldFallz commented

This is all do-able in drupal no-problem. Some modules to check out based on your requirements above (i edited your post to make it an ordered list for easier cross referencing);

  1. core drupal
  2. http://drupal.org/project/serial
  3. http://drupal.org/project/date
  4. http://drupal.org/project/views
  5. usually part of core, when not checkout https://www.drupal.org/project/autocomplete_deluxe
  6. not really sure. you can print/pdf the stored data with the 'print' module, but a pdf "form" would probably have to be generated by acrobat or some other pdf form generating method. There might be something that converts a node form to a pdf form, but I've never seen it.
volvo760’s picture

volvo760 commented

That is awesome info!

I'll start looking into them right now!

Thanks!