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…

button for Duplicate a record and its links to a sub table

Hello Community! I needs some help to create a button in my table Navire. Each record of Navire has multiple links to another table Options (1:N) This allow to create a navire with its own options.…

• Answered

Coding a popup dialog in a for loop if error

I've been reading that loops cannot be coded to exit. But I'm trying to figure out if there could be a way by adding an if statement somewhere in the code.…

• Answered

Compute months between to dates

Hi, How can I compute the number of months between two dates ? Thanks.

How to calculate years and months from a date to the current date?

Hi everyone. I have a date field when employees join the company. Now I want to have a field which shows the Years and Months since they started working with us.…

Questions about full copying of the forms

I am trying to copy a complete table, but the Duplicate table in Edit fields can only copy part of the table. The code parameters such as Show data as, Display field only, if,…

What does this mean?

I have no idea what this alert is trying to tell me. Far less how to fix it. Can anyone give me a clue?! Thank you

• Answered