Form Problem?

[frostyintrepid]

Hi All

I have this puzzling problem across all my forms. Please see the following snippet taken off a form.

<td height="40"><strong>Club / School : </strong> </td>
<td>
<SELECT NAME="select">
<option value="" selected>- SELECT A CLUB / SCHOOL -</option>
<option value="ACJC">Anglo Chinese Junior College</option>
<option value="Admiralty Secondary">Admiralty Secondary School</option>
<option value="AISS">Ahmad Ibrahim Secondary School</option>

In the formtools database, I would presume Option Value is selected but it doesn't.

Anglo Chinese Junior College shows up instead of ACJC.

Appreciate some help here. Thanks!

[Ben]

Hey Frosty,

I guess I don't quite see the problem: shouldn't "Anglo Chines Junior College" show up? That's the display text for the select box option, so Form Tools will use it - not the actual value attribute of the option.

But if you want to just see the select box option values instead of the display texts, you can edit the Field Option Group for that field and update the display text to be the same as the display value.

All the best!

- Ben

[frostyintrepid]

Hi Ben

I would like actually like to have ACJC showing up in the database instead of Anglo Chines Junior College.

Will give that a try

Hey Frosty,

I guess I don't quite see the problem: shouldn't "Anglo Chines Junior College" show up? That's the display text for the select box option, so Form Tools will use it - not the actual value attribute of the option.

But if you want to just see the select box option values instead of the display texts, you can edit the Field Option Group for that field and update the display text to be the same as the display value.

All the best!

- Ben

---

Hi Ben

This is getting quite confusing for me.

Any chance for me to use the Field Value instead of Display Text?

[frostyintrepid]

Hi Ben

I am not particularly sure what went wrong but it became the same for most fields using dropdown box after upgrading to core final version 2.0

Hope you can advise me further on this issue. Thanks!

[Ben]

Hey Frosty,

Sorry...! I actually don't quite follow you. It became "the same"? Form Tools will always separate dropdown, checkbox and radio buttons into pairs: the value passed by the form, and the display texts for each value. This is just the way those form fields work.

So if you need the value and display texts to be the same, you'll need to edit each and every Field Option Group to make them the same.

Hope this helps -

Ben

[frostyintrepid]

Hi Ben

Maybe a screenshot might help clear things up a little here.

In the database, it shows the display text for each submission.

However, it is showing the field text before upgrading the core version.

In short, when I export the values in excel format, it shows up as Anglo Chinese Junior College instead of ACJC and that's exactly what I don't want to see happen.

Hey Frosty,

Sorry...! I actually don't quite follow you. It became "the same"? Form Tools will always separate dropdown, checkbox and radio buttons into pairs: the value passed by the form, and the display texts for each value. This is just the way those form fields work.

So if you need the value and display texts to be the same, you'll need to edit each and every Field Option Group to make them the same.

Hope this helps -

Ben

[Ben]

Hmmm! Curious - thanks for the screenshot!

I guess I'm a bit confused because the generated content in the Excel files should be identical before and after upgrading. The Core doesn't affect anything in the Export Manager module, so it's rather odd!

The way it's behaving right now is the way it's supposed to work, but to tweak it to show the VALUE not the display value, give this thread a read:
http://forums.formtools.org/showthread.php?tid=487

- Ben

[frostyintrepid]

Thanks Ben! It solved everything