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.…

copy and paste table between databases

copy and paste table between databases

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

Copying a record using button or Ninox icon

Interesting discovery and I wonder if a solution could be found. If one uses the Ninox icon to copy a record any attachment (maybe apply to comments too) is NOT copied across the the duplicate record.…

Keep documents in field on every new record

Good day, I apologize first, but I am a new on this. I have a database and I need some of the information in specific record to always show up when I create or duplicate a record.…

How to open MS Words to generate custom Letter + Envelope (.docx) ?

Hi, Despite the classic ninox template print rendering, can a scripted button open a selected template (i.e. multiple choices) with MS Words with customed fields from the records, so I can modify it ?…

Function parameters - which types are possible

I've found this old post https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/types-of-parameters-for-a-private-function-5c0962c08d9fa6683abafc7d And not really any docs on the topic.…

Appointment function

I wonder why this Formula shows incorrect data. appointment('From Date' + 'From Time', 'To Date' + 'To Time') What am I doing wrong?

15 Minute webinar

Who can give a link to a 15 minute webinar? old link write that it is not available Regards

• Answered

Organize the result count system

Hello, I need help to organize the result count system In table «GM TABLE» in the Tab «tables» we create table with name (1, 2, 3 ...), prescribing the number of a certain number of chips on the…