Create and Modify Tables

Hi Joe,
importing data has no limitations. Please check the CSV file first.
You find more info in the import data section.
Best regards,

Alex

Hi

is it possibile to use "global unique identifier" in the script language?
And how?

Thanks
Stefano

Hello Stefano,
I don't think it is. What is your use case?

Greetings
Birger - Ninox Support

Hi

I have three questions that I wondered if you could answer. I also have the Pro version on my iPad.

I want to know how to delete databases and tables.

How do I duplicate a table in a database, with the fields only (no data)? I have a table already, with records and I just need to duplicate the field names only.

If this is not possible, my second choice would be to create another database. Ideally I would like to have a new table in the same database, since they are part of the same database.

I am also wanting to have my records in numerical order, from the lowest to the highest. It is a field that I created, using text because the field will have both numbers and letters, so I thought it was best to use a plain text field. I also noticed that the ID number field is not in numerical order, I also deleted some records so I don't know how to reset the ID #, could this affect the other field that I want in numerical order?

I am new using NINOX, so keep this in mind when replying.

Thank you,
Mary

Hi Mary,
thanks for you comment.
Let me try and answer your questions:
/ Delete databases: On the Ninox start page long-click the name of a database. A context menu will appear. Select "Delete".
/ Delete tables: Open the database. Open the table. Select "Edit fields..." from the gear menu. At the bottom left of the popup You'll find the "delete" button.
/ Duplicate database. On the Ninox start page long-click the name of a database. A context menu will appear. Select "Duplicate database...". Tell the assistant _not_ to duplicate records... you want just the empty shell.
/ Sort: You can sort by every field visible in the table view. Click the column head and select a sorting method.
/ The ID field. This is an internal number that identifies the record. This number can not be changed. If a record is deleted the ID will not be given ot again.

Greetings
Birger - Ninox Support

HI, Im creating a set of tables that use the same basic fields (a choice with three answers) just with different text for the field titles. Is there an easy way to copy an existing field and paste it in?
Thanks
Rob

Hi Rob,

thanks for using Ninox!

Unfortunately you cannot copy fields.
We plan to implement a feature to re-use choice field lists.

Best regards

Frank

Hi Frank, Thanks for getting back to me so quickly.

Hi There, Couple more questions:
How do I copy a table within the same database (or create a duplicate database and then move tables between them)?

What function do the 'colour' and 'icon' fields have?

Thanks

Just found the duplicate table function in the under the edit fields option :-)

Is it possible to specify the order that tables are listed in Ninox.

Thanks

Hi lynnk,
tables are ordered alphabetically. One work around would be using names like 1. Products, 2. Articles.
Best
Frank

Yesterday I created a database with a table and sub-table into which I entered a few trial records. I went back in today and for some reason the app won’t accept additional records being entered. I’m in table view with the sub table visible. In or out of ‘edit table’ mode, when I click on the + sign top right of the sub-table window, I’m taken to the edit table window rather than to a blank new record field. Where am I going wrong?

Please ignore this query. I have the answer.

Hello. I can find the facility to delete a single records, but when I select a number of records and try to delete, only the first is deleted.

How can I delete a number of records at one time?

I have two fields in my record designated as mandatory. However, Ninox allows records to be created even if the fields are left blank. This is not what I would expect.

Hi, when you click on "+" (create a record). The record is existent. This has many advantages. But we are planning more features to restrict creation of new records for specific user groups.
Best regards, Alex

Hi, with right click on the table. There is the option to delete all selected records.
Best regards, Alex

Yes, you are right. We have this on the list :)

You said last year you planned a feature that would allow developers to re-use existing choice lists for questions that all have the same set of answers (and, I assume, accompanying colours and logos). Has this been implemented? If not, is there an ETA on that? Thanks!

Hi,

The colours and logos are already available. For the copying/"re-use of exesting choice fields" we beg you for a some more patience. We hope to release that with one of our upcoming versions.

Thank you very much. Kind regards, Jörg