By 'prototype' I believe he means the record which you wish to use as a
'template'.
1. Find your 'template' record which will be used for setting the default
values of the fields in the new record.
2. Set the field.default accordingly.
3. Do not pass a record to SQLFORM. If you do, it will update that
record. It is presumed that you will wish to create a new record.
Hope that helps to clarify ValK's response.
All the best.
On Sunday, 13 December 2015 17:53:36 UTC, Anthony Smith wrote:
>
> Hi Val,
>
> Thanks for your reply, but unable to find any about get prototype record
> in the book.
>
> Do you have an examples
>
> Thanks
>
> Anthony
>
> On Saturday, 12 December 2015 06:03:26 UTC+11, Val K wrote:
>>
>> 1. get prototype record
>> 2. overwrite field.default with corresponding prototype value
>> 3. don't pass record to SQLFORM
>>
>> On Monday, December 7, 2015 at 7:15:46 AM UTC+3, Anthony Smith wrote:
>>>
>>> Hi All,
>>>
>>> I have a products table:
>>> db.define_table('product',
>>> Field('product_name'),
>>> Field('active_ingredient'),
>>> Field('batch_no'),
>>> Field('expiry_date','date'),
>>> Field('product_type',
>>> requires=IS_IN_SET(PRODUCTTYPES),default= PRODUCTTYPES[0]),
>>> Field('withholding_period','integer'),
>>> Field('ESI_withholding','integer'),
>>> Field('qty','integer'),
>>> Field('date_purchased','date', default = request.now),
>>> Field('purchased_from',
>>> requires=IS_IN_DB(db,'company.company_name','%(company_name)s')),
>>> (auth.signature),
>>> format='%(product_name)s %(batch_no)s')
>>>
>>> I can edit the product with the following controller:
>>> def edit_product():
>>> product_id = request.args(0,cast=int)
>>> product = db.product(product_id) or error()
>>> if not product.created_by==me:
>>> product.created_by.writable = True
>>> else:
>>> product.created_by.writable = False
>>> form = SQLFORM(db.product,product,
>>> showid=False,
>>>
>>> deletable=(product.created_by==me)).process(onsuccess=auth.archive)
>>> if form.accepted:
>>> session.flash="Edit Successful"
>>> redirect(URL('products'))
>>> return locals()
>>>
>>> At times I need to add new products but only some of the fields change
>>> E.G. batch_no, expiry_date, and supplier.
>>> In short if need to add similar item that I already have in the products
>>> table
>>>
>>>
>>> thanks
>>>
>>> Anthony
>>>
>>>
>>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
