Copy Yes/No function value

The table has a button that creates a copy of some records from the table for the next day. Part of the formula looks like this let c := (create 'TABLE'); let t := this; c.(DATE := t.…

• Answered

Dynamic Choice Field Assistance

I am having some trouble with a dynamic field: let ths := this; let thisUserDepartment := ths.Department.Id; let thisUserTitle := ths.'Job Title'.Id; (select 'WFM Permissions' where numbers('Eligible…

• Answered

Field border colours missing

This has been happening for a while - I don't know what changed, but on MacOs I have lost all the field border colours, making it very difficult to see what's on a pop-up, or forms on a field.…

Proper Case code sample

It seems Ninox does not have a proper case function. That is to say only the first letter of a sentence to be forced to Upper. The best I could come up with is: DESCRIPTION :…

auto populate email field

Hi guys Is there a way to automatically populate an email field with the mailadres from a person from a linked table? In this scenario I don't want to use the Formula-field because this formula field…

Structural Problem - How to choose multiple items to add to an Invoice?

I have Appointments. Each Appointment has multiple Invoice Items (since Appointments are only ever invoiced once, they double as the invoice). Available Items to add as Invoice Items come from a…

Paperclip TAB for attachments - crazy idea

Seems to me the Attachment Tab is indeed a rather special TAB. So just for fun I tried to drag a formula onto the Paperclip Tab. It created a formula on a new TAB automatically.…

Copy contents of reference link to another field.

Hello. The "Select" field you see in the screenshot is a "Link to" reference. My intention is that whatever is selected, should be copied over to the "Description" field (text field).…

• Answered

Server slowdowns !?

Am I the only one with big server slowdowns this morning ?

Determine if linked record's Multiple Choice contains value from this record's Choice field

This record has a Choice field with two values: Cat, Dog and this record (obviously) can only be one or the other. This record has a linked Colouring table where each record has a Colour (text) and a…

Sub table To a tab

I have a sub table on a 'contacts' page which shows me a list of booked appointments for that contact. I want to move this sub-table to a tab - is this possible?

Current Storage Capacity

Hello and congratulations on this FANTASTIC, USER FRIENDLY database. I checked one of my records this morning and realise that it was missing its attachments.…

• Answered

Justification - top/bottom, right/left, center/center

I am still thrashing about in the underbrush sometimes. I've got a small database to organize plant information (seeds, cuttings, when to plant, etc). I'm using a local version of Ninox--I'd tell…

Hide Multiple fields at once

Hi, I know we can hide individual fields by going to Display field only, if & entering "null". I have say 10 fields that I want to hide. For that to happen,…

• Answered

Minimum value 'number'

if not 'Number 1' then 'Number 1' := 'Number 4'; Formula gives value for 'number 4', after that I have the opportunity to change it if necessary. But I can't give it a value 0,…

• Answered

Multiple forms for a table?

It seems like any given table can have multiple forms created for it, however, when I do that I don't see any fields on the form. Changing the Edit columns... makes no difference.…

Check if 7 fields have been filled

Hi! In a table there are 7 fields to fill and 1 button. The button serves to create a record in a linked table, on this I have no problems. I would like the button script first to verify that all 7…

• Answered

Line feed/Carriage return in an Alert

Is this possible? Rather than The quick brown fox jumped ove the lazy dog One could format as The quick brown fox jumped over the Lazy dog TIA

In Out Button

Ш need to create a table where the in/Out of goods will be marked. Access to the table will be closed and the record can be done through the button. There will be two In and Out formula for In button:…

How to merge columns together while merging unique cells & offsetting same cells

Hello Ninox community, I'm new to Ninox, a crm that I honestly never heard of before until half a month ago. I've primarily worked on salesforceDC and homebrew crms, so any help is appreciated.…

Trigger when a new record is created

Hi! In a table I inserted this trigger on new data set (trigger on creation): alert("NEW RECORD alert") but it doesn’t work. I also inserted a trigger on editing a record:…

Timer for delete record

there is a table where a lot of records are collected during the day. After 10 days, they are no longer relevant, and i need to delete them if there is no comment and claim from the buyer.…

• Answered

Share information between two tables

Hello I have a formula that copies information from another table when the table name is same let t := this; first((select AllTables)['Table Name' = t.'Table Name'].…

• Answered

Import csv files with related tables.

How's it going. I need a procedure to import csv files with related tables. There is something hidden somewhere.

• Answered