Multi language solutions best practices

Hi again. I don't know if this is the best place for this question, but I will try... Here in Spain, about 70% of our clients sell their products and services in at least 3 languages: Spanish,…

• Answered

New 3.6 Script Editor

Is there a way of turning off the auto-complete function in the new 3.6 script editor? If I want 2x " (double-quotes) or a pair of braces () or {} then it assumes I always want a pair.…

Different numerical output...

As I new user, I thought I would share this, since I was pleased to have successfully written my first global function and moreover it did what I needed.…

Ninext : Important information

This message is addressed to all those who use the Ninext project. I regret to announce that the Ninext project will be unusable on Ninox very soon. This should happen at the beginning of February.…

Mehrfachauswahlfelder mergen

Ich habe eine Datenbank, die viele Datensätze hat, die eigentlich Duplikate sind, aber in einigen Bereichen unterschiedliche Werte haben. Ich habe nun ein Skript geschrieben,…

• Answered

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…

Clearing filters on loading a table

I use this snippet to clear the filters for a table (all). It is under a button. ui.openTableOld?null:ui.openTableOld=ui.openTable; ui.openTable = function(...arg) { ui.openTableOld(...arg); document.…

Embedded eCharts into Ninox

I have tried to embed eCharts into Ninox but have yet to succeed. For example, I put the following code inside a function field, but nothing: var _style := "* { margin: 0; padding: 0;…

• Answered

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

Button for create a new record which has a connection to a record

I have a table, where in every record, i have a connection of records from a different table showing up. (1:N) when want to get a new record, normally click "+ Neuer Datensatz" at the 1:N,…

• Answered

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…

How to pop up a dialog if a record in a table meets a criteria.

I have a table with three records each with a specific date in a field called next date. I am trying to use the trigger after open function to allow a dialog to pop up when the date in the next date…

OPENAPI

I'm trying to write the openapi-api code to import company data from the VAT number. I can't figure out how to tell which value to put in which field. I don't understand anything about API but I'm…

• Answered

Two condition nested If not working

I am trying to color a field when days overdue (delta_days) is the below however with the below code, I get either red or green, never Yellow. The second else/if should be skipped when the number for…

• Answered

Sending emails reminders automatically in Enterprise version

Hi there. I'm searching the forums but can't find an answer for my needs. We have an Enterprise account, and want/need to send a remainder to our costumers when certain event occurs (time based):…

Unlink Images from database to reduce the size

I have a database of my client session records which is now over 1 Gb in size mainly due to the images. Each session has multiple images of my handwritten notes.…

number() function stops convert strings with letters

Hello, I think that function number(), was converting strings like "XX23" to number 23... I've used it lot to convert record id to number for function record(Table,number(id)) .…

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

Help with Scripting

Hi, I am trying to add logic to a function that I created that will flip the item status from listed to sold, donated, returned, etc. I would like to put in a safety piece that will prevent this…

• Answered

Need help with a loop, do script

I made a database for listing jewelry items and forming "linesheets" and invoices that have specs, a photo of items, the wholesale and retail prices. Items for linesheets are selected from the…

• Answered