Mac Version: Are dates limited by OS X Date?

A date typed in as 1 Jan 1950 appeared to be returned as 31 Dec 1969. This suggests that OS X is limiting older dates, is that correct. In general OS X doesn't work well with dates before 1972,…

linking tables only using a numeric field

When linking tables if the "One" table only has a numeric field when it appears in the "Many" table it shows up as "un-named". However, if I add a text field/s they will show up in the listing on the…

Cant edit my Database anymore / cant save

I am trying to edit a table in Admin mode, after i made the changes I press save and than then loading icon shows up. After some minutes there comes an error message. (Server did not answered.…

How to change multiple dates to one year later?

Hello, I have a table that is essentially a large 'to-do list' with many fixed dates that need to be replicated every year. Ideally what i'd like to be able to do is click a button when the task is…

How to Format a Field?

Seems like a simple questions I know, but As a neophyte I figured out changing the date format in the table, however, the same field in a form shows up in the original date format and its not…

Locking records

Hi. I have a table A with many formulas, linked other another tables; B, C and D. Values in B, C and D will change, but I want to lock the records (values) that I have created in A so that these…

View form only

Apologies if I'm missing something obvious here but I've created some tables and forms to go with them. Until I logged in today I could view the forms without the table but today I can't seem to view…

Export Record, Import Record?

Is there a way to do this? I want to split one table into two tables. I duplicated the table, exported the table, imported the table, but the only data transferred was that shown in the table view,…

Link to view

Hi. I have three tables; Table A (top level), Table B (reference from A and additional data), Table C (reference from B with more detaled data). Data from C is summarised in B,…

Creando un registro en una tabla que tiene enlaces con otras tablas

Hola. Alguien puede ayudarme por favor, tengo dias buscando pero no comprendo bien el inglés. Estoy creando un registro desde un botón pero cuando tengo que asignar un valor que pertenece a una tabla…

Importing structure

can I import a database structure from the cloud to a desk top version of the app

Space colour

Hi I have inserted some spaces on my form but they are a different colour to the background - how do I make them the same colour?

Besoin aide ouvrir et imputer

Bonjour je voudrais ouvir une page internet et imputer des champs de remplissage de ce site avec de champs ninox merci de votre aide

How to print (or copy) a unique record instead of printing the entire database in tabular form

New to Ninox! What is the best way to print (or copy) a unique, single record instead of printing my entire database as a table. I know I can export the database as a CSV file and then open Excel,…

Hi, I'm fairly new the this app. I'm trying to sort one column by another. Having read the manual, I would have thought this would work. Any ideas?

Can you copy/duplicate a field?

I'm creating a db that will have multiple identical fields. The field name will be unique but the purpose of the field will remain the same. ie. tv1 - brand tv2 brand tv1 screensize, t2 screens size.…

which formula to sum

I have two choices fields which are filled with numbers, i would like in a formula fields to sum the two fields according to the number i choose, which formula should i use ? I tried : sum('choice' ,…

Format date & hour

Hello. is it possible to add the day of the week to Date and time? Mercredi 17 juin 2020. 10:08 thanks

Incremental numbering continuing from a set number

I need to start incrementing unique numbers that carry on from a set of numbers I have already been using. So for example the last number I will use on my old system will be 02399,…

Image Attachement ImportFile

I import a file from an URL and save it as an attachment of a data record : importfile(this, "myPathToFileAndFileName") Work like a charm. My step 2 is to show the file in a image field.…

Is there a file attached? Display in a table.

Hi, Is there a way of displaying in a table whether or not there is a file attached to particular records in a yes/no format. I suspect there is (but don't know how to do it) because in the form view…

It seems to be impossible to include a “View”-field in the print lay-out? Is that true?

Dear Ninox Ninja’s, It seems to be impossible to include a “View”-field in the print lay-out? Is that true? If so, any way to circumvent this issue? Here are some details:…