-
Issue with a formula
Hi I have an issue with a formula wich extract the first word of a coumpound word : substr(Nom, 0, index(Nom, " ")) That works perfectly but not with one name.…
-
Sort Dynamic Choices
Hi, Is there a way to sort the new Dynamic Choices, they currently appear in order of ID but struggling to order them by a field within the record alphabetically / numerically Thanks
-
Activate / Local or cloud database
Hi, I am new to the Ninox area. I have 2 questions: 1. Is Ninox always opened via a browser or can Ninox also be installed on the PC. 2. In 2 courses on the internet, when creating a database,…
-
Help in setting up an accountability system
Hi all, We are trying tset up an internal "accountability system" for our Ninox, and I might use some technical help to figure out what's the best way to implement it.…
-
Hi, How do I check if the current Year has changed?( I want to reset a counter on the first record of the new year)
let i := last((select Projects).'P#'); let lDate := last((select Projects).'Created on'); if i = null or year(today()) > year(lDate) then i := 1000; 'P#' := i + 1 else 'P#' := i + 1 end
-
Email sender
I have created a button to automatically send an email.However, I have the problem that the sender I am using is not the email I use in the Ninox account.Is there any way to use this mail?
-
Progressive sum
I have a table with the 12 months of the year (12 records).Inside I have a numeric field 'field A'.Is it possible in each month to have a 'field B' field with the progressive sum of the 'field A'…
-
Wordpress and Ninox
I want to import (or make) my Ninox Dbase searchable on my WordPress page? Is this possible? I looked at Zapier and not sure if Ninox is searchable or just to add records?…
-
URL link to table
Hello everyone, I had heard Ninox was working on an update that would include direct URL links to specific record. Is it true, and if so, how to create these links, please.…
-
Help, my code is half-working...what's wrong?
Hello everyone, I have a table for recording shipping relating to orders. A dropdown is used to choose the 'Courier Type', and I need the choice to make 2 changes: 1.…
-
What happens when you double click on table in left menu bar?
Done this a few times accidentally in the new version and it becomes unresponsive. What is happening ?
-
A new virgin new view in the table
Hi When one create a new view in a table the columns of the field on the left window countains already a lot of fields (Visible columns) Is there way to create an empty left window of visible columns…
-
Update a file names
Hi, I have 2 Ninox databases with name lists, one has 357 names and the other 235. How to update the one with 235 ? Thanks
-
Create a routine/loop
Hello to allI would need to create a button that creates a routine / loop.I mean when I press the button it should take all records of a table 'X' which contain 'field A' = true and make them all…
-
Geocoding: Get the street name from Google API
Hi!I already manage to get a response from the google API. { "results" : [ { "address_components" : [ { "long_name" : "299", "short_name" : "299", "types" : [ "street_number" ] }, { "long_name" :…
-
Dynamic choice sorting
Dynamic choice sorting
-
_cd Formula field incorrect time when formated
_cd shows 10/04/2021 9:21 AM unformated _cd shows 10/04/2021 09:04:19 formated for seconds formula entered: format('Created on', "DD/MM/YYYY HH:MM:SS") I would have expected the same time with…
-
What way should I print and save using a different file name from code.
To avoid using attachments as it appears these can not be deleted automatically. Tony Ryder
-
Hi, My name is Hassan I Live in Mogadisho Somali , I would like to ask your honorable admin, if I delate a name or a list How can I restore that name or lsit without enrolling again
Hi, My name is Hassan I Live in Mogadisho Somali , I would like to ask your honorable admin, if I delate a name or a list How can I restore that name or lsit without enrolling again
-
Extract names from compound names
Hi, Here is a function to get Ara from a list of compound names woth Ara inside : let xBegin := substring(Nom,0,4) let xLen := length(Nom) if xBegin = "Ara " then substring(Nom,4,…
-
Logical syntax for multiple "if" choice
Hello everyone, I'm trying to set up a logical formula that checks for two conditions instead of one, but I'm not sure how to do it. Let me explain: Instead of writing "if X then Y else Z" I would…
-
Returning values from a child table based on field value.
I'm trying to build a database to help me manage my honey bee colonies. I have a table titled 'Inspection Form' which is a child table to 'Colony Information'.…
-
Duplicate fields! Please let us duplicate fields!!!
Hi there. I've spent like 4,5 hours to create 300+ choice fields, which I would have done in 10 min if NX had the possibility to duplicate fields... Please add that in NX! G
-
Resizing cards in Cards view
Hi there, I am working on a photographic inventory, and I am wondering if there is a way to resize the cards under the cards view to suit my needs, as the pictures appear very small.…
-
Why can I move certain tables around but others seem frozen in place?
I am trying to organize my tables specific to their titles. When I hit the administration button the option to grab the tables and move them appears but when I try to move certain tables around,…