This topic is locked

Export doesn't show lookup values, shows id's

5/7/2025 11:25:37 AM
PHPRunner General questions
A
asawyer13 authorDevClub member

Is there a way to get the lookup values to be exported instead of the ID's.

For example, in the database the department is a number, but has a lookup to the department name. It shows properly on the list page but when exporting it shows the id and not the name.

C
copper21 5/7/2025

What is your "Display Field" settings in the lookup wizard?

If it is set to your ID field, then it will show up as your ID field.

You can use "different settings for different pages" Click on the "export" tab and set your "Display Field" to what you want to show when you export.