-
How do I filter out one or more field values?
I see how to filer for an individual value, but not for vieiwng the results without that value. I want to see all the records that are are clock.
-
Trigger after change
I have a Products table.I would like to add a trigger after the change that:if TOTAL = 0 then AVAIBILTY: = "NO"But this code doesn't work!The AVAIBILITY field becomes NO only if I,…
-
Dynamic combobox/dropdown list
Sorry in advance if this has been solved before. I'm trying to create a table with a couple dynamic comboboxes. If option 1 is selected for combobox 1, then only options 1 to 6 will be available in…
-
Creating a new record in a linked table using code
I have 3 tables linked to create a many to many relationship. The relationships look like this: [Locations] <--- [Location Tracking] ---> [Tracking] Multiple tracking records and be related to every…
-
Extract certain variable numbers from attached file title
Hello everybody, I'm working on an archive of graphics files. I've imported preview graphics as images and extracted the title with this formula: extractx(text(Preview), "(.+)\/(.…
-
Converting min/mile
Is there a formula in Ninox that can convert a time of say "32:14" for 2 miles into Min:Sec per mile? In other words, I don't want 15.50 min/mile, rather I which to generate a text of "15:…
-
Links in forum threads
Just a heads up... If you post a link in a forum thread it will be appended to whichever subgroup you are in. If I posted a link here it would be appended to https://ninox.…
-
Getting the Year & Month between two dates
I created a convoluted formula to calculate the age of a student at the start of a course. The basic idea is 'Course Start Date' - 'Student Birthdate' I was hoping someone could give me some pointers…
-
Is it possible to make a view with a top 10 only?
Let say I have client and purchase. If I wish to make a view with the 10 biggest purchase for exemple, how should I do it? To sort the result, should I use the built in filter or do it in formula?…
-
Custom made Icons
Hi, is there any workaround to add custom made icons? thank you
-
Email field
Good evening, is it possible to add an email address as Cc or CCn in the email field? many thanks
-
Have a Page number on the Print document
Hello :), I'm working on the template for my invoices. Is there a way/ formula do add on the Print document the Page number? I'd like to have on my document:…
-
Normalising existing data
I've imported a spreadsheet to a table and now want to normalise it. In SQL I would have done a 'select distinct' on a given field to generate the list of values,…
-
Auto-increment?
Is there currently an auto-increment field of some type? If not, is there a way in code? (I found some old posts, so I don't know how relevant they are anymore,…
-
Location of data file?
Where is the database data file located locally (I'm quite sure it is stored locally)? Also, how can I tell if it is located locally or if its stored in iCloud
-
Parent - Child Record Update Example. Code Help to Complete Needed.
I hope this will be enlightening for others, in addition, to help to me. Thank you in advance. I appreciate the help I’ve received. Nonetheless, I am working in circles.…
-
Replace all the end of words "XX" by end "Y" ?
Hi Could someone tell me how could I replace all the end of words "ae" by end "é" ? Ex Ciconidae > ciconidé Aramidae> Aramidé Columbidae > Columbidé Falconidae> Falconidé Thanks
-
Is there a way to get internal information (like IP address / hardware (mac) address/ etc??
Let assume I have three iPads accessing an application via the Ninox Cloud.. A user may use any one of the iPads to log onto the application.. Is there a way to determine which iPad the user was…
-
Delete Multiple Records?
Is there a way to delete multiple records?
-
To change the style of the text (color, bold, italic..)
Hi I know how to change of the size of police of the text of the fields but can someone tell me how to change the style (color, bold, italic..) Thank you.
-
Button functions
Hi, is it possible to add a formula at a button to close all the opened table?
-
Attach file
Hi all, is there a way to print and save the pdf generated in the record sheet as an attachment? Thanks
-
Display field only, if: either of two other fields has no data?
What is the formula needed to make this work? The field names I want to check for data are titled Email 1 and Phone 1. I can make the field hidden with either 'Email 1' = null or 'Phone 1' = null,…
-
Multiple choice picks in order?
Hi all. Anyone knows how to extract a list of items from a MC list in the exact order in which those items are selected? I.E. Let's say I have a mc field where 1. apple 2. pear 3.…
-
Ninox HTTP Calls syntax
What is the right syntax? In documentation (https://ninoxdb.de/en/manual/api/http-calls) its mentionned : 1. http(method, url)2. http(method, url, body)3. http(method, url, headers, body) for then 3.…
Answer questions and share your knowledge