Read only table

I would like to make a table accept data, but once entered it can't be altered, Any ideas?

• Answered

Import csv Error URI

I have Problem to import from csv, there are some procedere. I export my table Documentos to csv and try to open in a new identical Database where Documentos is empty. URI error

Expression to place non-printing ascii codes into text

The first 16 values of ascii/unicode are non-printable. e.g. 01, is null, 12 is form feed, 10 is line feed, 13 is carriage return, etc. I don't find any function in the language for ascii codes.…

Auto Import into Table

Is there a way in Ninox to auto import a CSV or plain text document into a specific Ninox table? Perhaps a PowerShell script of some sort.

Ninox for Mac vs Ninox Cloud

Hi, Do I need to subscribe if I only want to use Ninox on my mac?

• Answered

Is there a way to transfer multiple fields from one table to another?

I created a table with a long series of fields but I only realized now that some of these fields would work better if I put them in another table by linking it to the first one.…

Use Formula field to display subset of a linked table??

I have a table called "events". I then have a sub-table called "Expenses"(1:N). I want to create a formula field that only displays records from the Expenses table that have a specific type(one of…

Building table relationship 1:N

I have two tables I imported from a previous database. They were linked by an ID number. How do I recreate the relationship between these tables on the imported ID number fields?…

How do i track payments and update the new balance due?

We sell each customer one item and most of them make payments on it till it is paid off. We take in a CSV for each job that gives the DB the full total.…

• Answered

Formula don't work but no errors

I have this Formula but don't work, the HITOS is a Multiple choice Dynamics with 5 Options. I Try with HITOS = number(5) but not work if FechaF5 <= DataDate and FechaF4 !…

• Answered

How do i get my numbers $ to format right?

I can not get my imported in number - totals to format to show right. I have changed the formatting to every setting in their and none work to fix it. This is how they come in from my CSV files.…

• Answered

Neither of the two formulas work

I try these two formulas but not work some ideas. select 'DOCUMENTOS' let xFld1 := 'Avance Plan'; let xFld2 := 'Avance Real'; let i := (create AVANCES_PROY); i.('Avance Plan' := xFld1); i.…

• Answered

Related table field reference

ok....I know that by the time I will read the answer I will feel very dumb, but...sometimes you have to learn things the hard way I created a N:1 relationship between TABLE1 and TABLE2 and now in…

Fx Field to Display Date or Text Depending on If Statement

Hi, In the standard view (all) for record entries, I would like a column that displays either a date that was recorded as a field or text if that date field was not completed. So far I have..…

• Answered

Date of Birth? manually entry

hi, i have to set DOB but I found that on apple app, we I touch date field always display calendar to add a date, that is too annoying when you must set for example 1953 as year of birth,…

Date function

[Previous experience with MS Access & FileMaker; semi-new Ninox user. Using local Ninox app, on a MacBook Pro running MacOS Monterey v12.3.] [I'd add the version of Ninox I'm using,…

Private Function to Check Empty Fields on Button Click

Hi, Is it possible to create a function and pass it an array of fields to check if any of them are empty? My example is that I want to send a send a task to outlook using integromat,…

How do i connect a table?

I am using a templae (015_invoices different) and trying to make a version of it for my use. I do not see how i can connect the table right. Here is a screen shot of the working template fields you…