Arrange order of field choices

Question

Hello. I have a table containing different projects with each having 12 months and a corresponding value for each month. Then I set up this lookup field Month which is a reference proxy from that table and while the order of months is "ascending", I would like this Month field to show the order from January to December regardless of the project chosen. Can you please help with this? Should I add a formula on the form?
#Tablesandfields #formulas #FormRule

------------------------------
Ma. Isabel Gumanid
------------------------------

​​​------------------------------Ma. Isabel Gumanid------------------------------

donlarson · Answer

Isabel,You need a Record Picker report that orders the data from the Parent Field.&nbsp; &nbsp; 1) Assuming that you added the records to the Months table sequentially, you just need to create a report that sorts from low to high on Record ID# so that your users will see them January to December.2) if the Record ID# is not in order, then you should add another Text field to the Months table.&nbsp; Call it Sequence or some other name which makes sense to control the order of the records.&nbsp; Then give January the value "A" and continue to December.&nbsp; &nbsp; Now your Record Picker report should be sorted on Sequence from Low to High.&nbsp;In both of these examples, only put the name of the month in the report.&nbsp; Do not include the Record ID# or the new field.Last, on your form specify that the Record Picker report is to be used.&nbsp; Here is picture specifying an Embedded report
------------------------------Don LarsonPaasporterWestlake OH------------------------------

lightning0114 · Answer

Brilliant! Thank you so much for the help.------------------------------Ma. Isabel Gumanid------------------------------

Forum Discussion

Arrange order of field choices