Storing data for every month

[nextgen]

I need to add one record for every month.

 

For example, the user will choose from drop down list like:

 

Nov 2016

Dec 2016

Jan 2017

Feb 2017

 

(sorted according to month)

 

How can I achieve this? and what's the best field type to store it?

[jaymo67]

You would need to use a text field but this will make the value list sort alphabetically, placing all months next to each other regardless of year. Better to use two fields and two popup menus. I wouldn't use a table since there are only 12 months and this will never change. Same with years as you can likely enter enough years into a custom value list to handle the current year and well into the future.