Daniel Vela | 21 Feb 22:43

[FormBuilder] Newbie, question about formbuilder

I am new to formbuilder but what I have used I have found very usefull, thanks.  Now here is my problem, a have a table with data:

table1
==========================
=column 1  |  column2 |  column3 =
==========================
= row1       |  data1      | data12     =
= row2       |  data2      | data22     =
= row3       |  data3      | data32     =
= row4       |  data4      | data42     =
==========================

I want my form to go thru all the rows in table 1 and populate the forms like below on one screen:

                  _____
Field Name  | row1|
                  ______
Option         | data1|
                  _______
Fields         | data12|

                  _____
Field Name  | row2|
                  ______
Option         | data2|
                  _______
Fields         | data22|

                  _____
Field Name  | row3|
                  ______
Option         | data3|
                  _______
Fields         | data32|

Then I want to be able to modify any of the form boxes and be able to submit it.  Is this possible?  Is there an example I can study?

Thanks

Daniel Vela

_______________________________________________
FBusers mailing list
FBusers <at> formbuilder.org
http://www.formbuilder.org/mailman/listinfo/fbusers
Dan Axtell | 21 Feb 23:15

Re: [FormBuilder] Newbie, question about formbuilder

Personally, I think a giant form where you can edit any cell strikes me as a 
confusing interface, and problematic as the table gets big.  Why not use 
Javascript to launch a pop-up form (created by FormBuilder) when you click on 
a row, that passes the row values into the form as URL parameters?
_______________________________________________
FBusers mailing list
FBusers <at> formbuilder.org
http://www.formbuilder.org/mailman/listinfo/fbusers

Nate Wiger | 22 Feb 03:21

Re: [FormBuilder] Newbie, question about formbuilder

On 2/21/07, Dan Axtell <daniel.axtell <at> snet.net> wrote:
> Personally, I think a giant form where you can edit any cell strikes me as a
> confusing interface, and problematic as the table gets big.  Why not use
> Javascript to launch a pop-up form (created by FormBuilder) when you click on
> a row, that passes the row values into the form as URL parameters?

Sometimes this can be a good interface, if you're working with data
that emulates a spreadsheet. I've done this, but to be honest,
FormBuilder won't help you here.

You'll need to build a standard HTML table (take a look at
HTML::QuickTable) and then by far the easiest way I've found is to use
jQuery (jquery.com) and the inPlaceEditor plugin here:

   http://davehauenstein.com/code/?a=inplace

If you attach it to each of your rows, and give everything a UNIQUE id
that you can parse, you can do a trick like this:

   id="table_rowid"

For example:

   <td id="cities_100923" class="editable"> ...

   $('.editable).inPlaceEditor({ url: 'update.pl' });

Then you'll have to write some stub AJAX updating server-side script
too. Here's a snip ($sql is an SQL::Abstract object):

   my($table, $id) = split /[_]+/, $cgi->param('element_id')
   my($stmt, @bind) = $sql->update($table, {value =>
$cgi->param('update_value')}, {id => $id});
   $dbh->do($stmt, undef, @bind);
   print $cgi->param('update_value');

-Nate
_______________________________________________
FBusers mailing list
FBusers <at> formbuilder.org
http://www.formbuilder.org/mailman/listinfo/fbusers

Daniel Vela | 4 Mar 09:38

Re: [FormBuilder] Newbie, question about formbuilder

Dan Axtell <daniel.axtell <at> snet.net> writes:

> 
> Personally, I think a giant form where you can edit any cell strikes me as a 
> confusing interface, and problematic as the table gets big.  Why not use 
> Javascript to launch a pop-up form (created by FormBuilder) when you click on 
> a row, that passes the row values into the form as URL parameters?
> _______________________________________________
> FBusers mailing list
> FBusers <at> formbuilder.org
> http://www.formbuilder.org/mailman/listinfo/fbusers
> 
> 

Dan, 

Thanks for your response.  You are right that the table would be large (I expect
somewhere in the range of about 130 rows), but I want to be able to make several
changes at once, without having to pop-up form each time, I want to make several
changes at once and then submit.  formbuilder is great at creating a form, but
what I would like it to do is go thru and create several forms on a page.  Then
I can have my users change several sections at once and then make one request.

Thanks Again, Daniel Vela

_______________________________________________
FBusers mailing list
FBusers <at> formbuilder.org
http://www.formbuilder.org/mailman/listinfo/fbusers


Gmane