Order by data if lookup field

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
fgazza
Veteran Member
Posts: 205
Joined: 2019-04-30 17:37

Order by data if lookup field

Post by fgazza » 2019-05-07 11:59

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

User avatar
jsetzer
AppGini Super Hero
AppGini Super Hero
Posts: 1807
Joined: 2018-07-06 06:03
Location: Kiel, Germany
Contact:

Re: Order by data if lookup field

Post by jsetzer » 2019-05-07 12:28

Kind regards,
<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 readability

AppGini 24.10 Revision 1579 + all AppGini Helper tools

Post Reply