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:…

Formula column in List view question

Hello! I got tables Appointments, Treatments, Products. Each Appointment can have one or more Treatment. In each treatment i can use one or more product.…

sum formula

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' ,…

Update the content of a referenced field using the Update Multiple Records... command?

I want to update the content of a referenced field in my table. I select a group of records, invoke the Update Multiple Records... command, but the referenced field is not available to be updated.…

Colour - choice fields

Hi. Does anybody know if it's possible to change the colour in a choice (switch) field?

Is it possible to use a web form (like a Google Form) so that responses automatically populate a Ninox table?

I want to set up a membership database where members enroll themselves. I would like to use a webform, probably a Google Form, to allow members to enter their information and when they click 'submit',…

Assign multiple interested customers to one item?

I have an item table and a customer table. I want to create a link that shows customers interested in a individual item. How do I do this? I seem to be able to only assign one customer using a linked…

is there a solution how to code the analog of the excel EDATE function in ninox?

let curr_date:=date(2019,1,31) if I use the following formula for the next_date which is a month later: next_date = date (year(curr_date), month(curr_date)+1,…