Is there a way to set Created By system field

I am moving from OnPrem to the Cloud version, and I want to add permissions however I have a ton of previously created records that are now in the Cloud DB.…

Is it possible to delete all PDF file attachments on any given record without having to delete them one at a time?

I have many files with PDF attachments that I no longer need and want to go thru my database and delete those files. What’s the best way to do this? I thought something like this might do the trick…

Load (Transfer) Data

There are any way to Load (transfer) data for one table, to a Reference 1:N on other table, with a Button.

• Answered

Compile multiple documents into a single pdf

Hi, Is it possible to compile multiple pdfs into one? I have an invoice which is created then saved in my database then, I also have an appendix which is also saved when I generate my invoice.…

• Answered

Get table info from a dynamic select field

Hi ! I would like to know if it is possible to retrieve data from a table from a dynamic selection field. I have a table named "Produits et services" where I store information about my services sold.…

• Answered

Overlapping Forms - Mac/Ipad/Iphone

I've been using Ninox (v3.8.7) to only track medical billing (i.e. one database, one table for each year) since 2016. Synch and use between my trusty old late 2012 mac mini (Catalina 10.15.…

attach an attachment directly when sending an email

Hello, is it possible to attach an attachment directly when sending an email? Thanks. Alain

Display data from a view on a pdf

Hi, I would like to know how to display information from a table view (Edit Fields, Fields, Layout Field -> View) on a word file (.docx) that serves as my template for PDF printing.…

Compare fields of 2 tables to get result

Hi, I have a "Carte-cadeaux" table in which I have the following fields: - "Code de la carte-cadeau" in text format - "Solde restant" in number format From another table named "Paiements" I have a…

• Answered

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

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

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