Re: [web2py] Re: Altering reference table format in SQLFORM

2020-08-11 Thread AGRogers
I just tried the format option change to the table to see if it worked for me... but it didn't. Thanks Villas for the 'requires' tip. I am sure i will need that knowledge at some point.. On Wed, 12 Aug 2020 at 01:30, David Orme wrote: > Thanks! I had played with the represent attribute, with no

[web2py] Re: Altering reference table format in SQLFORM

2020-08-11 Thread David Orme
Thanks! I had played with the represent attribute, with no success, but using that first option within the controller works. Changing the validator seems a bit over the top just to change the format, but it works! On Tuesday, 11 August 2020 16:07:36 UTC+1, villas wrote: > > Off the top of my

[web2py] Re: Altering reference table format in SQLFORM

2020-08-11 Thread villas
Off the top of my head, maybe these ideas would put you on a better track... :) 1. The reference field has a default validator, try changing it to something like this: db.assignments.marker.requires = IS_IN_DB(db, 'markers.id', '%(last_name)s, %(first_name)s (%(email)s)') 2. Check out the