Combining a global variable boolean field with a trigger on table-level

I have a - boolean field called "Switch" that is a Global Variable in memory - date field called "LastChange" - a table with several fields of all types Generally,…

Duration chart

Hi ! Is it possible to calculate a duration to display it on a graph? I would like to have a graph that displays the time worked each month. This calculation is based on the "Durée" field of the…

• Answered

Update multiple records

I seem to have lost the ability to update multiple records. Can anyone confirm this for me and if you still can - how?

• Answered

Remove the repeated values from CutOff

Hi all again Starting from CutOff Date I need to remove the repeated values, In the picture the case, as CutOff Date 31/March/2023, eliminate the values of Real and Cumulative Cost down from…

• Answered

Sync to new device (iPad Pro)

I've been using Ninox predominantly on my iMac. However, I occasionally use it on my laptop and even more rarely due to the size of the screen on my iPhone.…

how to eMail with attachment on the Mac version

Good morning to everyone I'm driving myself crazy trying to send an email with a pdf invoice attached to It on my Mac version of Ninox. The invoice is generated on ninox and I'm able to save It into…

Dates Overwritten with Epoch Date on Opening

I have a small personal database I am using to keep track of video game releases. Some of the games are not yet released and have no announced release date,…

• Answered

printRecord() non working with "trigger after change" on table or Yes/No field.

Hi I'm trying to use a trigger after change on a table, and as well on a yes/no field with a simple printRecord(this, "Invoice"); and is not working. Then I copy the text exactly without changes to a…

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

Field/formula alignment issue ver 3.8.1.0

Last night I noticed this: Note the two green fields and the Locked check box. This happened last night and occurs across the DB so is not isolated to this form.…

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

CHANIFY

https://www.chanify.net/ Hello, I am trying to integrate Chanify into Ninox to send notifications with links and images. Does anyone have experience with this and can help me write the code for this…

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