Create a custom form in Drupal CMS for editors I need to create a form for our Drupal Editors. The form must allow them to add records to database.

I see next steps to do:


I add action in place I want.
User clicks on action and modal form appears (that's I do not know how to do in Drupal way).
User submits form and record is added to database.
If possible refresh current page so user can see new record.


Could somebody please point me in the right direction?

So far I'm looking on: CTools Auto-modal and CTools Auto-modal Admin Interface. However I'm not sure if that is right direction.
Maybe just use a regular content type, add whatever fields you'd need, and let your Drupal editors edit regular nodes.

As a variation, use the ECK module so that you have custom entities (instead of nodes). And then let Drupal take care of storing the data in an appropriate table in the database. With such approach you get all sorts of extra facilities (integrations with other modules), out-of-the-Drupal-box ... Views, Rules, Group, Flag, you name it.

Another approach could be like I described in my answer to "How to implement a multi step approval with webforms/entityforms based on form components?".