Hi, 
Not really as new to this and working my way through it slowly, but best I 
keep on searching 

cheers

Anthony

On Tuesday, 15 December 2015 05:19:30 UTC+11, villas wrote:
>
> 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.

Reply via email to