Using function when importing CSV

I have a CSV file where one of the columns has values 'x' or <empty>. I would like to import the column as the Yes/No type converting 'x' to "Yes" and <empty> to "No".…

Subtotal

Is there a way to create subtotals per day. I have transactions per day and would like to have a subtotal per day on order to compare with a budget per day.

display the second or third or...

Accordint to this rules (at the bottom).....there's a way to display the second or the third ? ------------------------ avg(Invoice.Amount) -- the average, ignoring empty fieldcnt(Invoice.…

How do I format a time as AM/PM

I want to display dates as "dd/mm/yy hh:mm xx" where xx gives me AM or PM as appropriate, Can't find the answer in the manual or forum so hoping someone can help.…

Computed fields vs formula

Folks.. Here is a nifty sample to add to the Project Template.. Computed Percent Complete using: 100 * sum('Sub Project'.Task['Sub Project'.Task.Status = 3].'Sub Project'.Task.…

Close Form

Hi, is there a function that closes the active form. I would like to make a button that would close the active form (like the closeAllRecords() function, something like closeForms() maybe). Thanks

Popup - Message - _cu

Hi, I would like to create a button with a popup that shows the _cu, the _mu, the _cd and the _md of the actual record. Any idea ? Best regards,

Non visible character for lpad() padding?

Is it possible to use a non visible fill-in character for the lpad() and rpad() functions? Using " " does not wor

printAndSaveRecord

Is it possible to give an example for this new function importFile(this, printAndSaveRecord(this, "My Print Layout"), "mypdf.pdf"). Importfile works but it does not seem that printAndSaveRecord works.…

Formatting Date

How do I format the date to show the weekday, month, day, year? For example, I would like the date column to show "Wed, 06/06/2018".

Festival Inventory Check-Out, Check-In

I'm working on an inventory db for a festival. I'm tracking supplies and equipment use, check-out and check-in. I have an "Inventory" table with items and set quantities.…

Finding a record's position in concatenated string

Text / Date Functions

I need to have a field that calculates 342 days added on to ‘breeding’ date entered in a table - So if someone enters 1/1/2016 for a breeding date I need the foaling date to show:…

Database structure

Hi, I produce a database, is it possible to have a detailed recap or a detailed overview of the structure of the database comprehensive of the formulas and the fields used? Thanks in advance. Max

Is Ninox for macOS a native app or Electron?

Pretty much that says it all and I suppose it doesn't matter much, but it's been bothering me. It looks a little like it could be both!

Date Added, Date Updated

I am migrating from FileMaker. I would like to have to fields that show the date a record was created or imported and the other to show the date the record was edited or updated.

Where do I get the Ninox-API-Code?

Go to https://user.ninoxdb.de Birger

I would like to create a macro or a link to print a table report.

I have a subtotal called Activities that has cost code information in that I would like to Print View with a button.

Use of a variable following a Select statement

Using a script as follows: let myAccount := text(Account);let myCategory := text(Category);let myYear := number(text(Year));let myMonthIndex := monthIndex(text(Month));…

Function Problem: pulling in data from another table

I havs a database with records Opportunity 1:n CallsOpportunity 1:1 Current Status (note: before you ask, the 1:1 is deliberate and my prefered way of implementation) Both calls and current status…