-
Is it possible to duplicate field options?
Hi Guys, So I work for a print management company, and I'm using Ninox (at my own expense) to manage suppliers. We have 'groups' of work that we have certain suppliers associated with,…
-
Conditional value list
Hello, I'd like to know if it is possible to set two choice field with conditional values, that means the "second" value list update itself after choosing a value in the "first" value list.…
-
Import Data
Hello, I made changes on a database. Then I want to transfer the data from my old database. I uncheck the models box. But I'm not able to check only the data. And the views are doubled.…
-
Print restriction on free copy
Hello i am currently appraising the free database and it is satisfactory but before I upgrade I would like to know if I can print thumbnail images on tables and print more that a dozen records on…
-
Import from MySQL
Hi, I am trying to import 4 tables, with relations from MySQL to Ninox using .CSV export/import. Here are my issues ..date format - After import all my dates where wrong (1974-12-30 format),…
-
Lookup And Ninox
I just purchased Ninox and am stuck on one thing. One table has weights and prices for shipping. Another table has products with weights. I want to be able to calculate the price for shipping based…
-
how do I invite a user?
How do I invite a new user?
-
Multiple choice field
Anyone know how to write the formula in a formula field to total different numbers based on the choices selected by the multiple choice field the numbers to total are in different number fields Thank…
-
Command dosen't work in mac App
hallo, if not Identificativo thenlet y := year('ID NOTA'.DATA.DATA);let m := month('ID NOTA'.DATA.DATA);let d := day('ID NOTA'.DATA.DATA);let c := cnt(select 'ID Nota' where year('ID NOTA'.DATA.…
-
Files and attachments
Hello,I have a question regarding files that I attach to the database: how can I locate them, so that I don't have to download them one by one, when I need to retrieve them?…
-
Button
Hi, is it possible to filter a view per determined field contents using a button?
-
DB Integration - website to ninoxDB?
On my website I've a mysql database and I'd like to analyse it by ninox, is there any method to interface my web site db to ninoxDB?
-
Assigning HTTP data source to an array
I am fetching from a URL with the http() function and getting this result: let vSrc := text(http("GET","http://bareawe.net/work/gp/noon/pos.txt","","")) => {"result":"$GPGGA,181908.00,3404.…
-
My ninox file is crashing and says "index.html Failed to BEGIN"
My ninox file is crashing and says "index.html Failed to BEGIN"
-
Mass Data Updates
How do you do a mass update of a referenced field? I have a column that references another table and would like to set the selected rows to a particular value from that table.
-
input
Hi I am trying to write a series of conditions where according to the figure (number between 0-24) in a field, strings would be input in a drop menu (text) field - Thanks
-
Reading values in array
Consider: let aLetters := ["a","b","c"]let vRes := myArray[1] I would expect vRes to hold the 2nd element of the array but instead, the entire contents of the array is returned.…
-
select
I have a table called vaccinations and i need to get the last date with the vaccination type "influenza" Select last(vaccinations.vdate) where vaccinations.type="influenza" but this is not working...…
-
calculating memberships in a sportsclub
Hello guys, i made a database for our club management. It's a small sportsclub for kids. No i have tables for "Members, Member groups, Training groups and Activities" In Training groups i have the…
-
Table References and Relations
Please provide a little more detail for your Person, Company, Employee example. What I specifically need is what you have to put in each table to tie them together,…
-
Can i angle the data form field titles?
Hi, can I angle the data form field titles?
-
Create new database based on existing, or clear data from database
Hi I created a sample database for a friend and put some dummy data in to demonstrate it. Now I'd like to "start again" with a clean database that I can hand over for the real data.…
-
resetting the counter
hello, thanks for helping me the other day. i am making a table where i enter my trips, and count them monthly. i am using this code let myID := number(Id);let myMonth := yearmonth(Start);…
-
Printing from forms
Hi - I have set up a music database and want to print a list of all music by a specific composer. I have a form with composer details and the music linked from the music table. This displays OK.…
-
Can I use a cursor to loop through records
I have a three column table of 50 records consisting of an ID, Latitude and Longtitude coordinates. I need to create a second table consisting of an origin ID and a destination ID that contains all…
Answer questions and share your knowledge