Bubble Form

johnw

Alan,
I have a database which displays driver and vehicle number, however, it show the text. How can I perform the following with my editor.

1. on a list of rows, enable a user to change the one or more rows of driver and vehicle number, using a drop down which is from a query. Once they submit a form, it changes all of the driver and vehicle number by passing individual id for both driver and vehicle.
2. enable user to click on the driver or vehicle and use a bubble editor which will show as a drop down , instead of text value, and to be able to update using ajax.
3. increase the size of the bubble screen size.

I guess I'm having a hard time trying to make it a drop down which the list if generated from a query.

Thanks in advance.

allan

It sounds like you might want to use a join? (That example doesn't use a bubble edit btw, but you could use an select field type in a bubble).

Is the data point you want to edit for the host table referenced via a left join?

Allan

johnw

Yes... the ID. Allan, thanks in advance because I'm still trying to learn Datatable.

johnw

Allan,

So my client wants to view all of the records using a datatable. Then I have two columns that is a drop down: driver and vehicle name. So they want to be able to use the drop down which lists the driver and the vehicle, and be able to select them. To save they want a submit button which will save all the rows in which they assigned driver or vehicle . So what is the best method of achieving this?

allan

Such drag and drop is not a feature provided by DataTables. You would need to look into using a drag and drop library, for example Draggable by jQuery UI or just use the HTML5 native drag and drop features. Either way, I'm afraid that is outside the scope of DataTables.

Allan

johnw

Allan,
Maybe I didn't explain it well. Here is what I'm looking for
https://editor.datatables.net/examples/inline-editing/join.html
where instead of location, I have two columns with drop down (column 1: driver; column 2: vehicle). Now the user will make all of the changes to the either driver or vehicle using a drop down. So I want to be able to update all the changes that was made.

I'm using ColdFusion, but I'm not sure how to get the users.site (in my case one for location and vehicle) drop down since it was written in PHP. Thanks.

allan

Sorry I misunderstood!

It is perfectly possible to have two different fields in a single bubble - this example shows that. Although it uses text fields, that would also work with select inputs.

Allan