Home > Forum > Forms > Wrong order of technical field on report

Wrong order of technical field on report
0

Hello webcon community!

Could someone help me with problem with ordering list on report.

To beggining:
I create a technical form field which collect the date part of some date field at that form (see screen below). I do itthat by using 'change field value' action and rule 'date part (month)'.
Next i use that technical field to group forms by year and month but when users create datas from october number 10 goes to the end of list.
Is there any possibility to fix it or maybe you have some idea how to do that easier or more effective that me?

Thank you a lot for helping me.

MVP
In reply to: Stanisław Projs

screen 3
another question - is there any possibility to add more picture in one message?

Hi Stanisław,

if the technical field is a text field, I would try to add a leading 0 to the month numbers < 10. This way the sorting of the text should work. You could also try to change the type of the field to integer. At least I assume that your current field is a single line of text field because of the left orientation.

You can add multiple fields to a message by editing it, than you can upload an additional image.

Best regards,
Daniel