appgini dropdown

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
omphilesithole
Posts: 26
Joined: 2015-01-12 13:01

appgini dropdown

Post by omphilesithole » 2015-04-13 13:19

hi, i have a dropdown that is pulling information from the table so i need to fix the way data is pulled am not sure what to do instead of pulling data on a sequence like 1,2,3,etc its pulls no. 1, 10, 11 ,12 then 2,3,4 i need it to pull it in this format 1,2,3,4,etc?

Please assist me!

wplim
Veteran Member
Posts: 36
Joined: 2013-01-17 22:42

Re: appgini dropdown

Post by wplim » 2015-04-13 23:37

try add leading zeros in your numbers.
e.g. 01,02,03,04,05,06,07,08,09,10, etc

mariosantoso
Posts: 3
Joined: 2015-04-08 08:38

Re: appgini dropdown

Post by mariosantoso » 2015-04-14 01:31

Hi,

Your question is not very clear but try these methods:

1. LOOKUP FIELD
If you are pulling from another table, make sure you set DEFAULT SORT BY to value where you want the sequence to appear.
ex. I have table named LOOK_TABLE with these fields...
id = primary key
name = var with this value (Toro, Mike, Anna, Bard, Charlie - entered in that sequence)
dob = date

set the DEFAULT SORT BY = name if you want to arrange the dropdown (on another table) sorted by alphabet.
When you use dropdown on another table it will shows Anna, Bard, Charlie, Mike, Toro in that order.

2. OPTIONS LIST
You must enter the list values in order manually.

I hope one of these can help you.

Post Reply