This is how i do something similar in one of my tables:
db.define_table('OrganisationUser',
Field(.....),
format = lambda r: ("%s [%s]") % (db.auth_user(r.UserID).DisplayName,
db.Organisation(r.OrganisationID).ShortName)
)
For you maybe:
db.define_table('pm_equip',
Field(.....) .....
format = lambda r: ("%s [$s]") % (r.equipment_detail,
db.pm_location(r.location_id).location_name)
)
On Sat, 18 Jul 2020 at 15:33, T.R.Rajkumar <t.r.rajkuma...@gmail.com> wrote:
> Thank you AGRogers
> As you said the equipment record format to include the location, that
> would do for me.
> Can you please tell how to do that.
>
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/c25d0e90-0524-4a63-95f5-85fa475b2b45o%40googlegroups.com
> <https://groups.google.com/d/msgid/web2py/c25d0e90-0524-4a63-95f5-85fa475b2b45o%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/CACWMBMPpgK21YecGimOyYLQgzma%3DUAYGp_R4tKE01NEnw7VjrA%40mail.gmail.com.
