If your app has a create-controller (I believe it has), you can just add to it some code like this:
def your_create_controller(): templ_rec_id = request.args(0) # means request like 'http://.../your_create_controller/123' 123 - id of existing record # notice that 'http://.../your_create_controller' will work as usual! if templ_rec_id: # pre-populate form rec = db.product(templ_rec_id) if rec: for f in your_fields_list: # [db.product.product_name, db.product.product_type', ...] f.default = rec[f.name] # that's all! On Wednesday, December 16, 2015 at 10:00:35 AM UTC+3, Anthony Smith wrote: > > 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.
