Changes

If you want your constrained field to show another value than the rowid, just set your custom field's name to the name of the remote field you want to show.

If you want your constrained field to show another value than the rowid, just set your custom field's name to the name of the remote field you want to show.

Eg: let's say you want to show the name of the users in the llx_users table, not the rowid. Just create a table with the "name" and it will automatically show the name fields instead of the rowid. And don't forget, in the PDF and ODT, you can access all the remote fields, not only name, but firstname, phone number, email, etc..

Eg: let's say you want to show the name of the users in the llx_users table, not the rowid. Just create a table with the "name" and it will automatically show the name fields instead of the rowid. And don't forget, in the PDF and ODT, you can access all the remote fields, not only name, but firstname, phone number, email, etc..

Also, you can specify to use not just one remote field but several, by concatenating the name of all the remote fields you want to show separated by underscores.

Also, you can specify to use not just one remote field but several, by concatenating the name of all the remote fields you want to show separated by underscores.

eg: name_firstname_login will show values formatted like 'Admin John admin'. Every value is separated by a space.

eg: name_firstname_login will show values formatted like 'Admin John admin'. Every value is separated by a space.

This can be particularly powerful if you want to show a list of choice with sublists.

This can be particularly powerful if you want to show a list of choice with sublists.

eg: let's say that llx_country_regions contains a list of countries and regions, like

eg: let's say that llx_country_regions contains a list of countries and regions, like

country region

country region

France  Paris

France  Paris

France  Seine-Saint-Denis

France  Seine-Saint-Denis

Canada  Quebec

Canada  Quebec

And you want the user to choose not only the country but also the region, you can just create a custom fields with the name 'country_region' and it will show a list of all countries and regions, from which the user will easily choose.

And you want the user to choose not only the country but also the region, you can just create a custom fields with the name 'country_region' and it will show a list of all countries and regions, from which the user will easily choose.