How to add an input field in SQLFORM.grid??

[greenpoise]

Is this possible?? I have a products table that shows all the products. I also created an add to cart button in it problem is if I want to add 100 items I would have to press the button 100 times.  Is there a way to add a quantity text field???


Thanks

Dan

[Massimo Di Pierro]

You can put the grid in a form and you add 

SQLFORM.grid(..., link=[lambda row: INTPUT(...)])

[greenpoise]

A bit confused..I thought SQLFORM.grid was itself a form? Also, can I add more than one link per grid? Reading from the book, it creates a column so technically sounds as if I could???

[Massimo Di Pierro]

yes and not and what I said needs clarification.

grid = SQLFORM.grid(create=False,update=False) is not a form. If create=True or update=True then it contains a form when you are creating or updating a record. you must avoind a form within a form and you can do so in the view:

{{if grid.create_form or grid.update_form:}}

    {{=grid}} it is a form

{{else:}}

    <form>{{=grid}} it is not a form but you can embed it in one <input type='submit'/></form>

{{pass}}

[greenpoise]

Gotcha!   Will try thanks

[greenpoise]

Massimo,

where do I change the INPUT size (length, width)?



links = [lambda row: INPUT(_name='quantity', _class='integer', _value=1)]

[Richard Vézina]

Hello Danel,

May I see screenshot of what Massimo propose?

I mean I would be really interrested in a bulk entry capability too.

If it is already available I would know I was about to make a custom mechanism to allow user to add many result at the same time that would rely on Excel and validate_and_insert web2py method...

The problem I had was to read directly Excel file, I would need to write a lot of code with xlrd. If I can avoid that I will be happy :)

Thanks.

Richard

[greenpoise]

Richard,

I tried Massimos approach but it created one form button rather than one for each row. For my uses, it wont cut it. I need one text field plus a button on each row. I was able to accomplish this like this

links = [lambda row: INPUT(_name='qty', _value='1'), lambda row: A('+',callback=URL('cart_callback',vars=dict(id=row.id,action='add',qt=request.vars.qty)))]

Maybe I did not make myself clear but I just want to have a product grid with all the products and the qty. Sort of a storefront, so the input text is not db attached. Click on the button and add it to my cart.. Hmmm but it seems you want to have like a bulk functionality with the grid, right???

[Richard Vézina]

Yes I think I miss understood... What I would have is the capability to insert many records in one operation (one form submission). I thought that what Massimo suggest turn the SQLFORM.grid in a kind of multiples rows form or something like that. It was not actually clear what Massimo was doing what Massimo suggested. That why I ask you if you were willing to show a screenshot of the result.

Don't mind if I actually miss understand.

Cheer.

Richard

[greenpoise]

Richard,

you know what? maybe it does what you want actually because what I get is a bunch of records with a txt and one submit button at the end. So, basically a grid within a form. I will write it and run it again and send you a screenshot. 

D

[Richard Vézina]

Great!

Thanks

Richard

[Richard Vézina]

Hello Massimo,

May I use this SQLFORM.grid capability to create a bulk or batch insert feature?

I am having problem with form validation and update of record actually. I try to update a record for now :

Controller :

def grid_into_form():

    grid = SQLFORM.grid(db.tab1,

        _class="web2py_grid",

        links=[lambda row: INPUT(_name='result', _class='decimal')],

        create=True,

        editable=True,

        paginate=5)

    return dict(grid=grid)

View :

<form>{{=grid}}<input type='submit'/></form>

I get input for every records in the table. But since I use html form tag I wonder how I could use validators... I try to put the grid in a form at the controller level like this (not successfully) : 

def grid_into_form():

    grid = SQLFORM.grid(db.tab1,

        _class="web2py_grid",

        links=[lambda row: INPUT(_name='result', _class='decimal')],

        create=True,

        editable=True,

        paginate=5)

    form = FORM(grid)

    if form.accepts(request,session):

        response.flash = 'form accepted'

    elif form.errors:

        response.flash = 'form has errors'

    else:

        response.flash = 'please fill the form'

    return dict(form=form)

Also, how could I generate a grid of say 20 rows with only blank input for every fields of a given table (so kind of empty rows)?

Thanks

Richard

[Paul Ellis]

Hi,

I am trying to do the same thing as the OP. Add a quantity input field to a grid and then use Callback to work with the product_id and quantity. I just don't seem to be able to pass the quantity to the callback function.

Using this method I don't get a value from quantity.

                        links=[

                            lambda row: INPUT(_type='number', _value=0, _name='qty'),

                            lambda row: A(T('Add'),

                                          callback=URL('_add_product',args=[row.id, request.vars.qty]),

                                          _class='button btn btn-default')

                            ]

                        )

If I use args or vars doesn't matter. The point is I always get 'None' for the Quantity field.

I have tried wrapping the grid in a form and the input in a form. I am sure I am doing something simple wrong.

Here's the whole function:

@auth.requires_login()

def product_add():

    productid = request.args(0)

    grid = SQLFORM.grid(db.product.id == productid,

                        args=[productid],

                        create=False,

                        editable=False,

                        deletable=False,

                        fields=[db.product.productname,

                                db.product.purchasecost,

                                db.product.monthlycost,

                                db.product.smallimage],

                        links=[

                            lambda row: FORM(INPUT(_type='number', _value=0, _name='qty')),

                            lambda row: A(T('Add'),

                                          callback=URL('_add_product', vars=dict(productid=productid, qt=request.vars.qty)),

                                          _class='button btn btn-default')

                            ]

                        )

    

    return locals()

[Anthony]

On Friday, November 25, 2016 at 11:11:41 PM UTC-5, Paul Ellis wrote:

Hi,

I am trying to do the same thing as the OP. Add a quantity input field to a grid and then use Callback to work with the product_id and quantity. I just don't seem to be able to pass the quantity to the callback function.

Using this method I don't get a value from quantity.

                        links=[

                            lambda row: INPUT(_type='number', _value=0, _name='qty'),

                            lambda row: A(T('Add'),

                                          callback=URL('_add_product',args=[row.id, request.vars.qty]),

Obviously request.vars.qty won't work here, as request.vars is not populated until after the request arrives at the server. Instead, you would have to use Javascript to update the callback URL whenever the value of the input changes.

Anthony

[Paul Ellis]

What about if I don't use 'callback' but 'href' so it loads the whole page. I still can't get the quantity value to be passed as an arg.