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

Prohibit Deletion

I Heve a task that will prohibit deleting tables and records, APP mac. Found how to hide the delete icon in the bar html(" <style>" + if not HUD then ".i-setting-print{display:none;}" end + " .…

• Answered

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

Does the 'page' feaure work on tablet devices?

I have created a 'page' in a database using the 3.10.x versions of Ninox on both an ipad and an Android tablet. However, the page 'elements' (views, relationships, etc.) seem to be non-functional.…

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

Alert not working

I have a formula that looks for duplicate records and if it finds one or more than it should bring back an alert. Not working anymore. Any suggestions? let xLast := 'Last Name'; let xFirst :…

• Answered