Numeric values not showing in database table view or Excel export

Hi everyone, When I rearrange or hide/show columns in my database before exporting to Excel (.xlsx or .csv), not all data appears correctly. Some numeric fields only show values randomly;…

Copy to Clipboard

Is there a Ninox function now? I was looking for a way to copy the content of a field and found this post from way back: html("<button onclick='copyToClipboard(""" + concat(SERIAL) + """)'>Copy to…

Hiding Icons HUD - choosing which to hide

I use this to hide ALL icons etc on forms. I have tried to show only the PRINT icon by removing 'none' in the relevant line but regardless of refreshing the page or toggling the HUD Y/N the print…

• Answered

Help with Changing Multiple If Statement to a Case Statement

I need help converting this multiple if statement to a case statement. Withdrawn and Graduated fields are yes/no. if Withdrawn = 0 and Graduated = 0 then let t := 'Enrolled Date';…

3.10 BUG feed back please.

When I try to select an option here, I get nothing offered. Can anyone confirm before I report to Support

Files on google drive

In looking for other topics on this I have not quite found what i want on the forum. So at the moment I am storing images of files (customer Order Acknowledgement/ Delivery Note etc) within 6 set…

Conditional formula to calculate 'taxable' and 'non taxable' items...

Hello, I'm trying to figure out how to include two fields that calculate the sum of taxable and non-taxable items. If you look at the attached image, you'll see that there's a field for the base…

Avoid spaces in a sum function when a variable is empty/void

Hello, the product name in my products database is a sum of 9 text and number fields, like this article + " " + Color + " " + more stuffs + " " +kg + " " lt" it works for normal use but in print view,…

• Answered

Field/formula alignment issue ver 3.8.1.0

Last night I noticed this: Note the two green fields and the Locked check box. This happened last night and occurs across the DB so is not isolated to this form.…

How to show all fields at once?

It looks like Ninox only shows the first 7 fields that you add to a table, and hides every field after. From here we have to click the view button and drag each and every field one at a time.…

Reference to items in the same table

I am still new to the field of databases so sorry if this question is badly formulated. I have a table 'Items' that lists a large number of items that can be associated to one another.…

CSV Import not working on Mac App

I used to use the cloud version of Ninox to all my databases and used to import data via a CSV file. Recently i moved from the cloud version to the Mac App.…

Paste Excel cell intor RTF field with simple HTML

Ninox does a beautiful work when pasting a cell range into an RTF field: it is stored as HTML tables for free! That's great for our purposes but... the HTML tables stored do have some rich…

• Answered

Sharing JSON object between two formula fields in the same table

Hello @Fred I have been able to make some progress in my project (Expense Manager) in the last few days, however I am stuck in a very weird problem at the moment.. I am writing to seek advise on this.…

pdf from html

Is it possible to program a button to generate a PDF from an HTML file?

Stuck with custom function...

Hello, I have a custom function to tweak a bit the contains() behaviour to use it together with a view field. My function is this: function containxORisORnull(Msource : text,Msearched : text,Moption :…

Module or another smart way to do things

Hi everyone I work pt at a customer who has several independant companies to set up kitchens. And the customer want some specific items in the independent companies's Invoices, however,…

[Bug] Formula "image" field not showing content in Cards view

I'm working in a project that uses the new do as database command to properly manage the entire application in 3 different databases. One of the databases works like kind of a DAM,…

Fields for Form use, not needed in "record"

This might be a simple answer, but on my slide-over default form for a table, is EVERY field stored with the "record"? It appears to me that formula fields probably are not "stored",…

• Answered

Multiple choice field (dynamic)

Does anyone know if I can have such a field in more than one column ? The case is that I have a table called keywords, which occur in a MCF (dynamic) field, and it works perfectly.…

• Answered

add Rich Text Fields

Hi there I have several rich text fields I want to combine with the format they have. To make it easy let's say that I have RT1, RT2 and Endresult. If I say Endresult :…

• Answered

email field

Does anyone know if I in the smart field "email" kan make and attachment, so that when clicking on this field it will bring the attachment with over to my mail system ?…

Formula field size when displaying iframe

I’m trying to display an entire webpage using a formula field in a page. The formula utilizes the html() function and an <iframe> tag. However, I’m having trouble making the field large enough to…

Creating view using dynamic choice field

I have a database of equipment. The equipment is in various locations of the building. All the locations are stored in a separate table 'Locations' with two fields: 'Main location' and 'Sub location'.…