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

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

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