Reference field trigger error

Hello Ninox Brain Trust, I have an error occurring after a trigger for a reference field. Attached will be found a sample database that shows the error in the ‘INVOICE TEMPLATE’ reference field of…

• Answered

Button to Send Message and Create Entry in Log

Hi, can someone help please. I'm almost there. I have this Tab So when I click on 'Join Reminder' button it creates a Text message for sending and this works perfectly.…

• Answered

Staff schedule

How to solve the problem with staff scheduling? so that the names of all employees who are supposed to work that day and at what time they start work are automatically displayed.…

Updating records in the DB

I have several databases, and once a month, i need to transfer information from all databases to a mine database. The problem is, that the data is not updated, it is copied.…

• Answered

how increse de memiries of my package?

Double Search

I have a double search formula ( Name & Format) let me := this; let myArray := (select Albums); if Search_1 then myArray := myArray[Name = me.Search_1] end; if Search_2 then myArray :…

• Answered

Linking tables after importing from database

I have imported several tables via CSV and would like to link them afterwards. I have a unique ID (company name) which I could use as a link. How can I link tables that were already linked in another…

How do you give a Yes/No field in Chart text names instead of 1/No

I've created a Chart where there is a Yes/No field called PAID where I want to show the Data separated depending on if it is a Yes or a No. However on the Chart is shows up as a 1 or the work No so…

• Answered

Need Assistance with Creating a Search Button and Displaying Results in a Table

Hello Ninox community, I am an IT professional assisting my wife, who is a real estate agent, in utilizing the Ninox platform. We have just discovered this tools few days ago.…

Questions about code merging.

In the following database, "1" is based on "Data1" to calculate the current state; "2" is based on "Data2" to calculate the current state. I want them to merge and be displayed in "3",…

• Answered

Questions about printing invoices

In the database table "Orders", there is a "New document" button. I created a new "test" table and set a "pdf" button. I have an idea that clicking the "pdf" button will generate a "pdf" of the…

• Answered

Search and select the most similar text

Hi, I need help to search and select a supplier in a table when I select a reference in another tab. I have 3 tables: one for suppliers one that acts as a register one for imports from another…

For the question of using N:1 search

When searching for the same content in the same database, there is data returned on the MAC port, but no data is returned on the web port. how are the search keywords defined?

• Answered

Fail to Read Data

I get the above error message when I have tried to import CSV files into Ninox. Any suggestions? I am trying this in the Android version. The CSV files come from a windows based Filemaker program.…

creatTextFile in Android

Does the createTextFile function work in Ninox for Android? Thanks.

Regarding the batch write issue.

I created a button to change existing data, but when I click the button, the returned data is always the same. I have tried this many times, but I can't find a solution. I am asking for your help.…

• Answered

How to append values to an array

How do you append a value to an array? The closest I get is: var x := ["Hi", "there"];var y := ["dude"];x+y but, while it dosen't have an error in it's code, it does not return an array

HOWTO PUT A TABLE VIEW IN A PRINT LAYOUT

How can I display in the print layout the same table-view as displayed? The table-view is displayed with a different order of column and has filtered fields....

Print Layout: Sorting a subtable via a 'hidden' field?

Hi, I have a print layout with a subtable which contains three columns. I need to sort the subtable output by a field which I don't want on the actual print layout,…

Modularity 3.10 how to relink the remote table (from DEV to Prod install)

How do you backup and restore a database and its remote table (3.10 modularity) for example a DEV shop linked to a DEV customer DB , in order to install them on the productive system ?…

Verify working time

@Fred Is there a way to verify that a Staff working on two o more Documents does not Spend more than 40 hours. ?

• Answered

Tracking outbound emails

Hi, I'm evaluating for a membership database and wondering if there is any way that sent emails can be validated within the system? I.e. bounced/undelivered/opened etc? If that isn't possible,…

Linking imported tables

I would like to preserve the linkage between two tables that I am importing from Filemaker into the Android version of Ninox. This is an N:1 relationship.…

Help with a search

I'm trying to find records where a group of numbers match another set of numbers. Here is a demo of what I'm trying to do. let x := array(["545,577,831"], ["121,545,577"]); let y := [{ Loc: 115, RR:…

• Answered

send an email automatically when a date is reached

Good morning, I would like to be able to run a script that automatically sends an email on a date to a contact and my email as a copy. I have already written the script (which works) but in a formula…