Option List Exports Display Text NOT Field Value

[ghost]

FT 3.01 / Windows Localhost install

1. Create Option List & Assign Field Values and Display Text
   

2. Link Option List to to Field1/Col_1 in DB - displays as expected
   

3. Add record

4. Display record using HTML /Printer Friendly Format - Display Text is shown NOT value
   

5. Export as XML - <col_1> shows Display text
   

6. Check database in phpMyAdmin - displays correct field value from Option List
   

7. Scratch head - I am missing something obvious - Option list export value should be exported?
   Option List display text should only appear in For Tools UI (internal form page)?

Trying this with external form - data saved OK in db but when exported as XML for round trip to another system incorrect option list value is exported.

Can workaround by making display and value exactly the same but...

8. Lies down

Thanks. Apologies if I have completely lost it

T

[benkeen]

Hey @tidalfire - sorry for not responding sooner. Will get back to this tomorrow.

[benkeen]

Hey @tidalfire, so it turns out this is working as designed. :) In all cases - even export - it'll favour the display text over the actual value in the database. It was a judgement call on my behalf, but to be honest, now I can see both sides.

I originally include the display value for option lists just so you could minimize the amount of data actually stored in the database: a single char could represent a massive long string displayed to the user.

But I'll put this down as a feature request, since I gotta say, it's pretty reasonable to need the display value during export - just like with the DB. I took a look through the code to see if I could come up with a recommendation of a workaround, but there's really nothing that easy I'm afraid. :(

[ghost]

Ben, Thanks for the explanation. I get the logic behind it and that’s really helpful. It has worked for us “as is” so we can continue with it. Regards Ted From: Benjamin Keen [mailto:[email protected]] Sent: 04 May 2018 02:12 To: formtools/module-export_manager Cc: Tidalfire; Mention Subject: Re: [formtools/module-export_manager] Option List Exports Display Text NOT Field Value (#15) Hey @tidalfire <https://github.com/tidalfire> , so it turns out this is working as designed. :) In all cases - even export - it'll favour the display text over the actual value in the database. It was a judgement call on my behalf, but to be honest, now I can see both sides. I originally include the display value for option lists just so you could minimize the amount of data actually stored in the database: a single char could represent a massive long string displayed to the user. But I'll put this down as a feature request, since I gotta say, it's pretty reasonable to need the display value during export - just like with the DB. I took a look through the code to see if I could come up with a recommendation of a workaround, but there's really nothing that easy I'm afraid. :( — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#15 (comment)> , or mute the thread <https://github.com/notifications/unsubscribe-auth/AKxcjAj3DIhw6AuipM1tpEABe8M2D8Zgks5tu6rZgaJpZM4ThtVy> .Image removed by sender.