want to use a button to check if the content of A in table 1 is the same as the content in the associated table 2….

I have two tables (1&2), I want to use a button to check if the content of A in table 1 is the same as the content in the associated table 2, and the number is also the same (the content of A may be…

• Answered

How to reset a database?

Hi all. Using the Mac desktop app. After "tuning" a database, testing it with test data, etc. what is a good way to reset it to a virgin state, resetting, among other things, all record Ids, etc...…

Invoice lines of old invoices

Hi, I have an invoice with invoice lines related to products. My problem is that if I update the price of a service, it changes also the prices on every invoice created in the past.…

Dynamic Dropdown sorting

Is there a way to sort the contents of a dynamic dropdown?

Where are my "Cloud" databases???

Hi all. Using the Mac desktop app, version 3.4.8 I have several databases which were coded as "in the cloud". However, when I look at my iCloud Drive, I don't see them. Where could they be???

• Answered

Send emails with attachments with Gmail via Make

Hello, I send emails from Ninox with my Gmail mailbox using Make.com (Integromat) but it is impossible for me to send attachments. This is what my code looks like:…

get span of selected text

Is there a "dirty" way to use javascript to get the position of a selected text? I have a textbox (or a formula generated text, if that helps) and a user needs to select a text where I would need to…

index with regex

I'm trying to find a way to get the index (i.e. start position in a string) for a regex pattern. I can use text, replacex, extractx for various operations but not for getting the index,…

• Answered

Field txt to date(dd/mm/yyyy)

There are any script to convert a field txt to a date format (dd/mm/yyyy)

• Answered

time(time field) problem

I'm in NY, EST. I have a time field "TF" that says: 2:30 PM so time field TF contains 2:30 PM if x := TF then I get x= 9:30 am if x := time(TF) then alert(x) from a button shows 4:30 AM ultimately,…

• Answered

Error message before sending an email with attachments

Hello, I created a button allowing me to add documents downloaded from a client, directly into the image fields of a recording that I want to send by email, I got the error message:…

Change the sequence of the tabstops

How do I change the sequence of the tabstops within a table for adding new datafiles. That means jumping from one field into the next

How use popupRecord() and openRecord() ?

I try to create a button to open (may be in a popup) to go to an other record but I don’t know how use this fonction. Someone can help me please ? Thank’s in advance. Gwendal (Sorry for mistakes.…

Change Status on Multichoice Dynamic

I am trying to get the 'Status MC' change to 90% when I update the date in 'Real 4' but if I delete the date it goes back to 70% 'Status MC'. I try this but don't work.…

• Answered

making PDF with rich text

Please can you tell me where it goes wrong? I looked in the manual, the forum… It’s about printing rich text I make a field with rich text: html("<h1>To</h1><p>Filip Schumacher</p>") In the form it…

Parse Dynamic Multiple Choice into JSON object

I have a DMC field that takes these values (dynamic value): let all_entities := (select elements); let my_event := this; let my_elements := ((select elements where 'parent entry'.…

• Answered

Dynamic choice applications

table1 is the data location of the material type/material plan/material number table2 is the table for selecting materials how to display "NO" in table2 on VIEW (such as image 2) Thanks

Conditional Formula Request

I need some assistance to create formulas that returns values based on two Choice Fields in my stats table. The choice fields are 'Cohort Year' and 'Cohort Term'.…

Conditional email content

Hi every one and Happy new year ! In a database, I have several check boxes and I want to send an email in witch appears only the title list of all the boxes that i've checked.…

• Answered

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