AnsweredAssumed Answered

Exporting to Excel, want Value List Field to show Text, not ID

Question asked by fm12forartloans on Jul 23, 2018
Latest reply on Jul 23, 2018 by fm12forartloans

Hello FMP Community!

 

I have several fields setup as pop-ups that store the ID number yet show the text on-screen, via value lists. These fields are scripted to go to their related records on keystroke.

 

I'm now in the phase of testing reports, and I see that when I export records to Excel, the ID number in these pop-up fields shows instead of the text. I need the text to export.

 

Any ideas on what to adjust?

 

Many thanks!

Outcomes