0

Can I control the order in which Ninox displays my tables?

Screenshot 2025-07-19 at 6.32.38AM

When I open my database, it appears Ninox orders my tables in the order in which I created them. (see attached). Is there a way for me to re-order them a bit more logically for my users?

30 replies

null
    • Fred
    • 4 days ago
    • Reported - view
     said:
    It does process the Attendance_Staging table, but only the last record is saved.

    I tested it out with just the contacts part and it created the two records (Lynn and Jeff) that are not in the contacts.

      • Fred
      • 2 days ago
      • Reported - view

       Seems like you have to do it the way you described if you don't want to script the csv import. Have you asked your provider if you can connect through API and get the data that way?

    • Fred
    • 4 days ago
    • Reported - view

    Question: What is the purpose of these lines?

    allContacts := array(allContacts, [newContact.Id]);

or

allEvents := array(allEvents, [newEvent.Id]);

    You don't use them anywhere else? So why update the arrays when they don't get used?

      • John_Halls
      • 4 days ago
      • Reported - view

       Hi Fred. Not so sure it's needed for contacts but for events, it stops a new event from being created twice, or more, during the import. Very clever, I thought. I did suggest changing it to

      allEvents := array(allEvents,[event])

      Regards John

      • szormpas
      • 4 days ago
      • Reported - view

        Hi!

      Recently, I helped Dave find a solution for importing a CSV file with the support of Fred and Steven. You can see the whole process here: https://forum.ninox.com/t/p8ykzc2/need-help-on-importing-a-csv-into-two-related-tables-scripting-help#60yklyr

      You are right. Since Dave wants to avoid duplication in both Contacts and Events, I had to add each newly created event or contact to the initial selection. After each iteration, it is available for comparison.

      I used 'newEvent.Id' to avoid any conflict because the 'select' statement returns 'nid', but the 'create' statement returns 'rid'.

      If you're interested, you can find a more advanced solution here. CSV Import Wizard 

      Best wishes

      Sotirios

      • Dave_Airel
      • 2 days ago
      • Reported - view

       you did more than “help” me, you guys basically wrote my script for me, and taught me enough along the to tackle more on my own. Much appreciated.

Login to reply

Content aside

  • 2 days agoLast active
  • 30Replies
  • 146Views
  • 5 Following