If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi all,
Vanilla are planning an update to the site on April 24th (next Wednesday). It is a major PHP8 update which is expected to boost performance across the site. The site will be down from 7pm and it is expected to take about an hour to complete. We appreciate your patience during the update.
Thanks all.

Forms- populating dropdown lists from database or web lists.

BeardyFunzo · 2014-07-16 14:03:52

I'm working on a project that centres around an inventory database. the two main components of the database are the list of items in the inventory and the list of people that interact with the items. I want to use online forms to help keep the database up to date. Currently I'm using google forms and a script called…

16-07-2014 3:03pm

#1

BeardyFunzo

Registered Users Posts: 254 ✭✭

Join Date: December 2009

Posts: 229

I'm working on a project that centres around an inventory database. the two main components of the database are the list of items in the inventory and the list of people that interact with the items. I want to use online forms to help keep the database up to date.

Currently I'm using google forms and a script called formranger. the script populates the dropdown lists by referencing the forms responses spreadsheet.

The speadsheet is kept up to date by importing data from a text file of names that my database uploads to the web.

my problem is that google are updating their forms and the fromranger script will likely stop working soon. I need to keep these from up to date or the whole project will likely keel over.

has anyone used something similar for their forms? Could you point me in the direction of a useful method? I'm happy to do the leg work myself, but the array of possible options is staggering and I'm pretty confused.

I've looked at the frombuilders here: http://mashable.com/2012/02/16/web-form-builders/ , none of which were much help

Wordpress, joomla and drupal don't seem to be much use and mysql seems a bit out of my depth at the moment, but I'm willing to learn.

Thanks for any help.

0