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

Dynamic reports with JSON formula - loop

Dear all, Bonjour, Je travaille actuellement sur un rapport dynamique qui a besoin d'afficher un enregistrement à imprimer, ainsi que des sous enregistrements.…

Problem with dynamic report

Hello to the community, Hello everyone, I have a problem with dynamic reports. I created a word document with the tags but my mac application crashes every time I try to test printing.…

• Answered

openTable() with sort order.

Hi, using openTable() is it possible to open a table specifying sort order? In other words: openTable() - in descending order on the record ID field -. Idea being to open a form view starting with…

• Answered

iOS calendar entry duplication

Whenever I update a date entry in my Ninox database, my calendar entries on my iPhone are duplicated. That is, if I have a calendar entry from the database for, say,…

Getting pdf file from the API response

Hello API experts! I would appreciate your help saving/opening a PDF file, which is the response to an API call. This is the code of the API endpoint call inside a button: let url := "https://testeps.…

• Answered

Account flows

In the Accounts table, I have a view called Flows with the following script. It gives the correct dataset but would like to filter out from that dataset the selected account ledger line items (that…

• Answered

Lead Scoring Assistance

I need some help creating a formula to build Lead Scoring. I have created a formular field in all Lead Records called Engagement Score. I want it to build a score based on their status value with…

• Answered

Constraints issue

In Proj-Buildings I select the BUILDING NAME taken from BUILDINGS. The constraint here: a.PROJECTS.CLIENT.NAME = b.ORGANISATION.NAME Limits the Buildings list to those for the client/organisation.…

• Answered

What is "Handle file as" in Image field properties

Hello! In this "Handle file as" selector there are options like: Size Small, Medium, Large, Original size. What do they do really? I thought that selector compresses the uploaded image or keeps its…

Create a Date showing Day of Week, Month, Day of week

I have a simple date input where I choose a date. I would like it to show the day of the Day of the week, Month and day of month. For example: Friday, December 15, 2023 Instead of the default "Dec 15,…

Export .csv to excel not work

https://youtu.be/Eo6WUmG86fE The Scrip on formula is: let me := this; --- GENERAR COMBINACION FILTRO ---; let myCon := ""; myCon := myCon + if Alpha then "X" else "_" end; myCon :…

• Answered

Build a Report Advice

Ok, I want to create a Form within my Ninox CRM that will allow a user to select pre-defined reports, click a button, and then than upon click it will create a new record for that corresponding…

Is there a known problem with dynamic printing?

In the last couple of days, all my attempts to dynamic print failed. Even if I try to print a blank page, I continually get an error message! Does anyone else face the same problem?

• Answered

Convert XML API call response into JSON object.

Hi, after a successful call to a public API, the response that I get is of the following form:…

• Answered