How to Get Triggers to Work when Importing Records?

So, I have quite a few triggers set up, which is great when you are manually entering data and records. However, how do I get them to work automatically when importing records?…

How to style a numeric fields?

Good morning! I've had issues with the styled() function these days and after having read several articles in the forum: it seems that the stlyed() function converts the variable to text.…

JSON: add a block based on a given condition

Hello. I am creating an XML file and would like to start with a JSON because it offers greater readability and ease of maintenance. In the structure of the JSON how can I decide to add blocks…

• Answered

Posting data to api service - Bearer vs Basic (authorization/authentication)

I am trying to post data to a service. It works perfectly with Postman, however, I am still trying to figure out the proper syntax to do the same within a Ninox button script.…

Using a Dynamic multiple choice field to filter a dynamic choice list

I'm searching the forum but there is no correct answer to my question (or maybe is nested in a very crowded forum). I have a Dynamic multiple choice field (Country) with a list of countries.…

Use a formula to create a new field from existing fields

So obvious I can't work it out even after I RTFM. I have a number of fields containing info which I want to join into another new field from where I can copy and paste to an email.…

• Answered

Printing with iPad Ninox: doesn't access all fonts

I've set up forms with a Mac desktop version of Ninox --specifically using Arial Narrow. When using IOS Ninox, I can't access the same font, needed to fit the text within the form.…

Stopping the Ninox search

Is there a way to stop the Ninox search function once it has started and taking to long.

How to Sort Localisation fields properly ?

Hi, How can I sort my localisation fields in a proper order Zip Code > Street Name > Street Number , please ? Currently, it runs following the Google Map french order :…

Comments???

no solution to place comments in formula? any idea?

creating linked records from table A to tables B and C question

Is it possible to do the following: From table A (button) script the created of a new record in Table B (easy), then create a record in Table C that is linked to Table C Table B is an "office hours"…

• Answered

Hiding the '+' for views

This is the element: <div class="i-32-16 i-light-grey i-plus FastClickContainer_root" role="button" data-testid="elements-before"><div class="FastClickContainer_rippleContainer"></div></div> Is there…

Filtering the table view

Often seem to have problems with this. Particularly if the column in question has 'Conditional Formatting'. I am currently trying to filter a table and NOTHING is working.…

Copy "text" field contents into "Choice" field?

Hi all. (Real newbie question) Searched, found two answers which I don't understand, so here goes: I already have a database, populated with records. I'd like to take the contents of a "Text" field…

• Answered

forbid multi line copy paste in views ?

I just recently discovered that if you have a multiline text stored in the copy paste buffer, then accidentally paste his text in a view, it will change as many lines as there are lines in the…

Switch Case Statement: combine multiple cases with same code

I have a switch/case statement where I would like to combine "case 1:" and "case 4:" since both use the same if/then code (rather than duplicate the code in a separate "case 4:…

• Answered

is there a way to count number of item within a selection field?

I have a selection field and I wish to use to number of item inside to check if all those item are used in the table. For example: selection field = red, blue and green table entry:…

Formula field not displayed in table view

Hi guys, I've entered a valid Formula in Ninox that displays the result in the Form view. However, this result (only one) is not displayed in the Table view.…

Is it possible to disable sum symbol ∑ in Table view

I am using the free version of Ninox with the iCloud syncing functionality. I have a table with equipment and each piece of equipment has a price. When I have the price column activated with the…

Formula need

@Fred I need a fórmula on 'Spend Hours' field that adds the sum for each 'Activity Name' for Disciline cumulative, on 'History Hours' table here the name is 'Activity:…

accumulation

how can i make the same text do cumulative sum

Problem N:1 Activity_Name

@Fred On Staff Hour table, I create Activity_Name (N:1 'Staff Hours' To Activitires) for select the Activity. With the Add Register button add the info to ' History Hours' but no find the way to…

• Answered

Delete a record and related records in other tables

I have a table named « Accounts » which is the main table where I add all my customers. From the Accounts table, I created a Yes/No field which has the mission of deleting the selected account…

Is it possible to copy/separate tables?

I'm still rather new to Ninox. I have one master table. I want to make multiple tables from the one table. For example: In my Master table I want to take all number 1's (which is one of my fields)…

Database Search

I am building a database for veterans listed on the memorial wall in my county. I am the only one who will build or edit the database. However, I do want the public to be able to search the database…