Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Storing data for every month


nextgen
 Share

Recommended Posts

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?

Link to comment
Share on other sites

  • Gold Members

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.

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use