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.
