I tried several times to ask for help for this problem, both in the forum and through support requests but without an answer.
I have a "appointments" table with a "date_appointment" field.
I have another "outcome_appointments" table with a "event_date" field. The "event_date" field is automatically set as an integer because it is a lookup field that points to the "date_appointment" field in the "appointments" table. In addition, the "event_date" field is set as "auto-fill" because the event title is defined by another lookup field that points to the "title" field of the "appointments" table.
The "outcome_appointments" table is set to sort the records according to the lookup field "event_date" descendinghly. Unfortunately the data is sorted alphabetically and not by date (so the highest value is 31/10/2018, then there is 29/11/2018 and so on until 07/05/2019!) As you see date is in european dd/mm/yyyy format that is good for me!
I hope you can help me soon. Thank you so much.
Fabiano
Order by data if lookup field
Re: Order by data if lookup field
See the initial discussion here:
https://forums.appgini.com/phpbb/viewto ... 9898#p9898
https://forums.appgini.com/phpbb/viewto ... 9898#p9898
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools