Determining if children exist

In various places I have used the construct:- if 'children table ref field' then do something end In fact I sometimes hide an empty reference field to the child table by putting the reference field…

Is it possible to run the script in a button from another script?

There are five buttons in a form. Each compiles a portion of a report. I would like to have a sixth button with a "generate full report" script that activates the script in each of the other five…

Returning files that have a certain name

Hi! I have files attached to a record. concat(files(this)) returns all attached file names. I’m looking for a function that only returns files that start with the string "ABC" Can you help me, please?…

• Answered

Select a field in a record in a linked table on Trigger new data set

Hi! I have 2 linked tables: TAB-A and TAB-B In TAB-B I have a number field named "nr" In TAB-A I have a number field called "tax" In TAB-A I have this formula in Trigger in new data set: let dtsel :…

• Answered

Automatic Importation of records via HTTP Call "GET"

Here's a public link to a CSV list of exchange rate history USD/EUR from Sabadell Bank (Spain): http://bsmarkets.webfg.com/webservices/cotizaciones/acciones/indexWebservicesHistoricoCSV.…

Wrong font when exporting pdf

Hello! I would like to use the font Avenir for my PDF. I can see it in the preview in the correct way, but the font turns into Helvetica when I'm printing the pdf. What can I do? Thanks, Anita

Integration from Calendly into Ninox

Hi, I am trying to set up intergration from calendly via zapier to my appointments table in Ninox. The time stamps provided by Calendly appear like so: “Event Start Time 2020-12-01T08:30:00+00:…

Block a field if ?

I need a script that allows me to block the loading of HOURS (Horas Hombre) if the Document (Documeto) its DateR5 is 100%.

• Answered

How to share active database with another user?

Hi, I'm wanting to share a database with another user in my family. So far I've been totally confused on how this can be done. My info: I'm using a free Ninox program app on my iPad and iPhone.…

multiple conditions is Display if:

I have a formula (echos an image) that I want only to display when a series of yes/no fields are false. That is to say when any one of the yes/no fields is true the image (the formula) does not…

• Answered

Ability to make field layout in form "static"

I've been building a number of forms for a new database and my experience mostly comes from using MS Access. When I add fields to a form, they automatically shift their locations depending on what…

Show Fonts (and Styles) in Rich Text not working

This used to work and suddenly stopped. Symptom/Problem In a Rich Text Field, invoke (eg with right click) the "Font" menu item, and select "Show Fonts" or "Styles". Nothing happens...…

Iterate over DC

How can I iterate over a dynamic choice similar to the dynamic multiple choice with numbers(dmc) . My use case is that I would like to auto-select the DC record if there is only one possible choice.

How to Use Constraints

Hi all, Been struggling to understand how to utilise the Constraint field when i have 2 tables linked together. Table 1 is Staff details which contains everything about a certain staff member,…

Sum related field with specific criteria issue

I have a table called Projects with a reference to a table called Proposals, and there can be multiple Proposals per Project. Within Proposals I have two fields;…

Sort / Order by based on total count

That is even hard to explain. So I do use a dynamic choice box do suggest possible values based on already existing values from that column. I can sort them alphabetically but I would love it if,…

• Answered

Convert "Credit Term" to Date plus credit term

Hello. I have 2 fields. CREDIT TERM (number field) DUE (date field) If I add 30 (or any other value) into the CREDIT TERM field, I want the DUE field to auto-update to 30 days from today.…

• Answered

Picture and URL

Code for displaying picture in his field, by a trigger, via URL. Thank you.

Birthday function in tab

when clients are registered, I write down the date of birth. How do I make it so that when a birthday comes up, it will be seen in a different color in the client list. Regards

• Answered

Searching Multiple Choice Dynamic Fields

I am using the Multiple Choice Dynamic Field and it is working great from a selection standpoint. However I want to be able to list, search or filter based upon records that have certain choices…

Clear out Dynamic Multiple Choices

As I've been learning Multiple Choices (Dynamic) I've made a variety of changes, and not that I've settled on the proper approach the target record seems to have recorded the previous choices and now…