Saving a double 0 dropdown-choice

[IljaIljitsj]

I’m having trouble with the following problem: I’m currently using dropdowns in order to let users select a certain time for a database entry they make. Times are split in two different numbers: the hours and the minutes. Both can be selected through a different dropdown: the hours dropdown consists of 24 static choices (00, 01, 02 etc.) and the minutes are split up in 12 static choices (00, 05, 10, etc.). Therefore, users are able to select times in fragments of 5 minutes, and I can easily use these values for database searches later on.
My problem is the following: when a user selects the value ‘00’, this is automatically formatted to ‘0’, Then, times are displayed as 13:0 instead of 13:00. Fortunately, the time of midnight isn’t used often, but that one would be even worse (0:0). How can I change this? I’ve read that formatting the data as text (numbers only) works best, but I can’t seem to force my dropdown to format the values like this.
I would very much appreciate any suggestions!

[greg.nallie]

I’m having the same problem, the only fix I’ve found is to put quotes around one of the 0x options (“01”/“02”, etc), and the rest of the values appear with the leading 0.

Is there a cleaner way to do this?

[joseph.farinhas]

has anyone found another workaround for this besides using quotes…

[seanhoots]

You can use the Air Static Dropdown Labels plugin to address this issue.
Actually this issue was one of the main reasons I created this plugin.

Don’t worry the plugin is free.

[New Free Plugin] Air Static Dropdown labels

Just published this tiny plugin called Air Static Dropdown labels, that i think some few people might find useful. This plugin allows you to display dropdown labels different from the values when using the default bubble dropdown with the static option. For dynamic choice you can simply use the features available in the default dropdown element. If you want to have a dropdown with lables different from values, in most cases you create these as two different fields in your database and use th…

[joseph.farinhas]

thanks for this Seanhoots. i noticed however the last option on the drop down was missing. then i followed your careful instructions in regards to the input not being empty. All works now. I feel happy saving a cats life. thank you.

[joseph.farinhas]

this solved the user’s end but still need to find a way to make the double 0 appear “behind the scenes”

[joseph.farinhas]

ok i think i got a workaround. the original dropdown i had to use the “00” method. and when displaying it or using it to put into the database i used the value of the dropdown and find & replace " with blanks.

seems to be working as planned.

This is annoying though. Thanks guys for the help