Thread: [MRBS-general] Add new entry. Get Name and Description data from external database.
Brought to you by:
jberanek
From: Roberto P.R. <rp...@gm...> - 2012-10-22 12:57:19
|
Hi, I have a question. When I create a new entry, I would like to see into the Nane field, a drop-down list of data names of people form another external database. And when I select a person of this list, get into the description field the full data of this person. Has anyone done this implementation or similar? Thanks. Robert. |
From: Rowland C. <row...@gm...> - 2012-10-25 03:10:34
|
On 22 Oct 2012, at 20:57, Roberto P.R. wrote: > When I create a new entry, I would like to see into the Nane field, a > drop-down list of data names of people form another external database. > > And when I select a person of this list, get into the description > field the full data of this person. I'd be interested in this possibility too. I have many "users" (ie names) but none of them are allowed to manage bookings. That is done by a couple of admin folk. However, they don't always spell names and descriptions accurately or consistently and it would be great if they had a drop-down list or menu to choose from - plus of course the option to add to the list if a name doesn't already exist. in friendship Rowland | Rowland Carson ... that's Rowland with a 'w' ... | <row...@gm...> http://www.rowlandcarson.org.uk | Skype, Twitter: rowland_carson Facebook: Rowland Carson | pictures: http://picasaweb.google.com/rowlandcarson |
From: Campbell M. <cam...@gm...> - 2012-10-25 07:37:35
|
You can already have a drop down list of options for the name field in standard MRBS. Just set in your config file: $select_options['entry.name'] = array('Physics', 'Chemistry', 'Biology'); // Just put your options in the array See the comments in systemdefaults.inc.php for more details. Roberto - if you want the options to come from an external database then you'd obviously have to populate $select_options['entry.name'] dynamically yourself. Rowland - if you want users to be able to add their own text if it's not already on the list, then you have two choices, assuming you're happy to make some small modifications to the code: (a) if your admins are using modern browsers that support the HTML5 <datalist> element, then you could use that (b) or else you could use the jQuery UI autocomplete widget. It's already used on the Report page for an example of how it works Campbell > -----Original Message----- > From: Rowland Carson [mailto:row...@gm...] > Sent: 25 October 2012 04:10 > To: General purpose list (support/developers/users) > Subject: Re: [MRBS-general] Add new entry. Get Name and Description > data from external database. > > On 22 Oct 2012, at 20:57, Roberto P.R. wrote: > > > When I create a new entry, I would like to see into the Nane field, a > > drop-down list of data names of people form another external > database. > > > > And when I select a person of this list, get into the description > > field the full data of this person. > > I'd be interested in this possibility too. I have many "users" (ie > names) but none of them are allowed to manage bookings. That is done by > a couple of admin folk. However, they don't always spell names and > descriptions accurately or consistently and it would be great if they > had a drop-down list or menu to choose from - plus of course the option > to add to the list if a name doesn't already exist. > > in friendship > > Rowland > > | Rowland Carson ... that's Rowland with a 'w' ... > | <row...@gm...> http://www.rowlandcarson.org.uk > | Skype, Twitter: rowland_carson Facebook: Rowland Carson > | pictures: http://picasaweb.google.com/rowlandcarson > > > ----------------------------------------------------------------------- > ------- > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_sfd2d_oct > _______________________________________________ > mrbs-general mailing list > mrb...@li... > https://lists.sourceforge.net/lists/listinfo/mrbs-general > Want to unsubscribe: mailto:mrbs-general- > re...@li...?subject=unsubscribe |
From: Campbell M. <cam...@gm...> - 2012-10-28 09:18:28
|
I've now (SVN Rev 2534) allowed the name field to be am autocomplete datalist by specifying an array of options in $datalist_options['entry.name'] in the config file. At the same time I've changed the way that the autocomplete fields work so that they now use HTML5 <datalist> elements if supported by the browser, otherwise falling back to the jQuery UI Autocomplete widget. Campbell > -----Original Message----- > From: Campbell Morrison [mailto:cam...@gm...] > Sent: 25 October 2012 08:37 > To: 'General purpose list (support/developers/users)' > Subject: Re: [MRBS-general] Add new entry. Get Name and Description > data from external database. > > You can already have a drop down list of options for the name field in > standard MRBS. Just set in your config file: > > $select_options['entry.name'] = array('Physics', 'Chemistry', > 'Biology'); // Just put your options in the array > > See the comments in systemdefaults.inc.php for more details. > > Roberto - if you want the options to come from an external database > then you'd obviously have to populate $select_options['entry.name'] > dynamically yourself. > > Rowland - if you want users to be able to add their own text if it's > not already on the list, then you have two choices, assuming you're > happy to make some small modifications to the code: > > (a) if your admins are using modern browsers that support the HTML5 > <datalist> element, then you could use that > (b) or else you could use the jQuery UI autocomplete widget. It's > already used on the Report page for an example of how it works > > > Campbell > > > > > > > > -----Original Message----- > > From: Rowland Carson [mailto:row...@gm...] > > Sent: 25 October 2012 04:10 > > To: General purpose list (support/developers/users) > > Subject: Re: [MRBS-general] Add new entry. Get Name and Description > > data from external database. > > > > On 22 Oct 2012, at 20:57, Roberto P.R. wrote: > > > > > When I create a new entry, I would like to see into the Nane field, > a > > > drop-down list of data names of people form another external > > database. > > > > > > And when I select a person of this list, get into the description > > > field the full data of this person. > > > > I'd be interested in this possibility too. I have many "users" (ie > > names) but none of them are allowed to manage bookings. That is done > by > > a couple of admin folk. However, they don't always spell names and > > descriptions accurately or consistently and it would be great if they > > had a drop-down list or menu to choose from - plus of course the > option > > to add to the list if a name doesn't already exist. > > > > in friendship > > > > Rowland > > > > | Rowland Carson ... that's Rowland with a 'w' ... > > | <row...@gm...> > http://www.rowlandcarson.org.uk > > | Skype, Twitter: rowland_carson Facebook: Rowland Carson > > | pictures: http://picasaweb.google.com/rowlandcarson > > > > > > --------------------------------------------------------------------- > -- > > ------- > > Everyone hates slow websites. So do we. > > Make your web apps faster with AppDynamics > > Download AppDynamics Lite for free today: > > http://p.sf.net/sfu/appdyn_sfd2d_oct > > _______________________________________________ > > mrbs-general mailing list > > mrb...@li... > > https://lists.sourceforge.net/lists/listinfo/mrbs-general > > Want to unsubscribe: mailto:mrbs-general- > > re...@li...?subject=unsubscribe > > > ----------------------------------------------------------------------- > ------- > Everyone hates slow websites. So do we. > Make your web apps faster with AppDynamics > Download AppDynamics Lite for free today: > http://p.sf.net/sfu/appdyn_sfd2d_oct > _______________________________________________ > mrbs-general mailing list > mrb...@li... > https://lists.sourceforge.net/lists/listinfo/mrbs-general > Want to unsubscribe: mailto:mrbs-general- > re...@li...?subject=unsubscribe |