RG
-
Import date format incorrect
This has never worked in Ninox. Whenever I import a CSV file, the date is always way off. For example: "2022-02-3 05:56" will import as "Mar 3, 2022". The only way to correct this is to open the CSV…
-
Find duplicates
How could I find duplicates in a table, querying a certain field (such as customer's name)?
-
Import address block to separate fields
I would like to create a way to import a block of text into separate fields in a table. Could someone help me figure out how to do this in Ninox? I envision a form with freeform text field I can…
-
CSV Import assigns wrong date
Using Desktop edition.. When I attempt to import a CSV file, the dates are almost always incorrect by one month. For example, a column with "2021-04-20 08:42:34" as the date imports as May 20th,…
-
How to create Many to Many relationships?
What is the best way to create a many-to-many relationship in Ninox? Do I create the intermediate table to join the two tables, as with other relational DBs? Here is my scenario. We send newsletters.…
-
How to access parent record?
When I am in the form of a subtable entry, I would like to access a different subtable off the parent record. How do I access these records programmatically?
-
Database Frozen! Need help undoing coding mistake..
I mistakenly put a dialog() function in a table view. Now the program freezes as it tries to display 400+ dialog prompts (one for each record). I can't figure out how to undo this mistake because…
-
Need help with a basic view
I'm having trouble figuring out to construct views. I am used to doing this via SQL. I have a Contacts table with a Products subtable. I want to query all records where the product is of a certain…
-
How do I remove or change a table reference?
When editing a subtable directly, there is a field with option to "search" and fill in the reference to the parent table. Once that field is filled in, how do I change it to point to a different…