BEAUTIFY is not meant for this purpose. Instead, you can try a readonly 
form (which is what the grid uses to view the details of each record):

{{=SQLFORM(db.auth_user, record=record, readonly=True)}}

You can control the display via the "represent" attribute of each field as 
well as the "formstyle" argument to SQLFORM.

If you need a radically different layout, you might instead just have to 
create a custom HTML layout for the display in the template. In that case, 
if you still want to take advantage of the "represent" attributes of each 
field, to get the fully rendered values of each field in the record, you 
can do:

record = db(db.auth_user.id == id).select().render(0)

Anthony

On Friday, July 24, 2015 at 4:52:25 PM UTC-4, Rahul Nahata wrote:
>
> I am trying to create an online directory which requires me to display a 
> persons details from a modified auth_user table in a seperate page ( with 
> id as an argument to the page). 
>
> I am facing problems while formatting the display of the sql record with 
> help of BEAUTIFY function applied to the row. As in the Field names are 
> displayed as first_name, addressl1, contactnum, etc. whilst I want them to 
> be First Name, Address Line 1, Contact Number, etc. Also I do have a column 
> for profile picture that I would like to display in a box format.
>
> Any solutions to customize the formatting of display of the SQL Record? 
> Please help!
>

-- 
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 [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to