Need Help with view table.

@Fred I have the this formula and works excellent, I can search by Name and Dates at the same time. (Two search), but I will like the view table appears without information when I open the search…

Date language

Hello everyone, I came across the following issue: I'm using NINOX in english but the data I put in is in Greek. How could I set the date to be displayed in Greek too???

• Answered

Private Server

Hello again, I noticed on the main screen of NINOX, clicking on the right gear would bring up a menu, which includes the option to "Connect to server...".…

• Answered

Storage usage overflow

Hey everyone, I have the following problem: I checked the Usage Overview on NINOX and found out that in the starage used I have 4.3GB of 2GB used!!!!!!!!!!! What issues may I have on this situation???…

Calendar event details

Is there a way to customise the details shown on calendar events? How can I set specific fields to be shown for every record?

• Answered

Why can't I duplicate a table with all its data?

I am aware of the "Duplicate table..." button in the "Edit Fields" panel, but that function does not actually duplicate a table, it duplicates a table structure.…

Fields shown in calendar

Hey everyone, I started using widely the calendar and realised that only the "Date" field has a setting to "Show in calendar", but I'm using the field "Date+Time" and this one DOESN'T have a similar…

• Answered

Hide calendar?

Is there any way, perhaps using some CSS magic, to hide the Calendar button in the sidebar?

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