Benefits of Using a Table Report for a LookUp Field

The 'Report Identifier' section in the LookUp Field configuration now allows you to select a Table Report for the Lookup. Previously only the default List Report could be used and this change brings with it many benefits. Using a Table Report for a LookUp should therefore be considered best practice - gains over using a List Report include:

• Infinite Table Reports can be created to perfectly suit any given Lookup field, all whilst being hidden from view. (See tip below)
• Once the magnifying glass is clicked, the actual LookUp pane has superior aesthetics that mimic the Table Report. This pane also retains the scroll bar function at the bottom to make browsing through all the available data easier.
• The pane still gives the ability to Filter and Search through the data with the added benefit of the Search no longer being case-sensitive either.

Tip - You should ensure that the Table Report contains the full library of Records with no Base Filters applied as the LookUp can only search through the Records available to the Report - You can also have Lookup specific Table Reports hidden from general view within an App by toggling 'Is Hidden' in AppStudio.

See creation of a Lookup here and Table Report here.

LookUp Pane with a Table Report Configured: