Order a Reference Table
Ninox Profile

Is there a way to order a reference selection table by anything other than the ID.  I use ninox to create attendance records and the attendance recorde has a reference to the list of students.  When I click on the student item in the attendance form the student table that was referenced appears for me to select a student.  I was able to create a constraint such that only active students appear, but I can't seem to find a way to order the students by their name instead of the default ID.  

Ninox Profile

If in a view.. You can use an "Order by" clause..   If using the default table .. you can manually sort it once and it will stick. 

manuallyOrder

Reply