maximum user roles

Hello, Just new on Ninox and liking it so far! I was wondering how to do the following: We have a table 'inventory' where the complete inventory of our headquarters is located (industrial kitchen).…

• Answered

What is the Database file name & path for the Mac version

I'd like to create a script to backup the Ninox database file instead of having to do the "Save As" approach. However I can't find where the file is stored and does anyone know?

• Answered

hide rows

Hello everyone. I created a new tab and I would like to display only part of the information. So I applied a "formula", but unfortunately the lines corresponding to my filter are not erased.…

• Answered

Fields that appear in Master Calendar view

I have Date fields with Show in Calendar = Yes, and I am trying to figure out which fields or more to the point, how to control which fields show up since the calendar item has limited space.…

Using a Dynamic Choice and filter for records.

Hi, I raised this on Tuesday Ninox Webinar and sorted it out using the conventional related table look up method but I am trying to use, for the first time, a dynamic choice field.…

• Answered

Calc Dynamic problems

@Fred Hi Fred, 1- I have a problem in the Show_Week_Hours, the selection of Choice_Weeks is not ordered correctly. 2- Now is for one year there are possible a script for works on weeks for years.…

• Answered

OpenTable with tableID

Is it possible to open a table using the tableID instead of the table name?

Default max length of Text field

HI, I know i can specify a min and max length for the text data type. But if I don't set a max length, what is the default max length of text I can store in that field? Thanks

customize tables appearance

hello i have a db which is basically buit, in term of graphic/appearance is there any possibility to customize table..i mean shape, colors..and similar things? thanks

Re-Creating invoices from the Line table

Hi All, I would appreciate some suggestions on how I could re-create invoices from a table of lines. Preferably creating one invoice at a time from the Line table.…

• Answered

BOMs Managment (2) "Production table"

Hello everyone I would like to create a manufacturing cycle (basically a mixture of purchases and sales). (C) The first step was to define whether an article was a parent or not (via a "Billed…

• Answered

Block of Time on Calendar

I am looking to create a block of dates on the calendar. I have a start date and finish date and i also want the days in-between to be used for the same project. Is this possible

• Answered

BOMs Management

Hello everyone. I started in Bills of Materials Management (BOM). To do this, I therefore created a sub-table allowing me to link content (Lists of constituent Products) to an article (Parent…

• Answered

Help in making queries

Hello i have a db (many thanks to @Fred ) and now i need to make some queries. In a table where i have a list of "transaction", (sum of products sold and product returned) i want,…

script to find if student enrolled last year

Hi, I'm not finding the logic to write a script that would check if in a given school year (Sept-Aug) the Parent table , a student currently enrolled - the child table,…

Where place the alert ?

let me := this; if 'Plan_1 Editable' < 'Data|Date' and > 'Plan_2 Editable' then "" else "OK" end; while weekday(me.'Plan_1 Editable') > 4 or cnt(select Holidays where Date = me.…

• Answered

Table cels Background color

Good morning, I would like to create a rule so that the background is green when the indication is 'NO' and green when the indication is 'YES'. I saw that NINOX provides this for sub-tables,…

• Answered

Unique / Concat giving different results

Hi all. I have a table showing Orders, in which I have Items that are linked to Products, which each have their own Product Categories (in a multiple choice field).…

• Answered

Indirectly link N:1 records

Hello ! I have a table named "Comptes", a table named "Activitiés" and a last one named "Bilans de vitalité". When I create a new record in the "Activités" table,…

• Answered

Parse a specific section of a YouTube URL

How would one parse out this section of a YouTube URL Complete URL = https://www.youtube.com/watch?v=BbqlkY0ArfM I want just this portion: v=BbqlkY0ArfM This can then be used to watch a video from…

link choice

Hello everyone. I'm stuck for something stupid, but I can't find the solution. If someone could help me? Thanks in advance. Here is my little problem. I created a "Devise" sub-table with different…

• Answered

Determine Net New customers via Select Statement for Dashboard

I would like a formula field that will represent the number of clients we have in a month that are first time customers. We are an event company. This will be via a field on a dashboard I'm creating.…

Formula ID count also deleted records

Good morning everyone, I have a formula field with ID in it. This shows me the record number. My problem is that I have noticed that this formula also counts me the record ID's that have been deleted.…

• Answered

Limit the number of rows visible in a table view

Hello ! I have a table view on my dashboard that sorts customers by amount spent. I would like it to display only the 5 customers who made the biggest expenses.…

• Answered

Breakdown chart by city with filters

Hello ! I currently use a graph allowing me to know where my customers are located. For the Chassieu city, I only have one client and it is not sufficiently representative to display it in the graph.…

• Answered