-
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?
-
Field type changing
Is there solution changing the field type later?
-
My ninox file is crashing and says "index.html Failed to BEGIN"
My ninox file is crashing and says "index.html Failed to BEGIN"
-
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.…
-
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.…
-
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
-
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...…
-
Help creating Invoice Numbers
I am wanting to set up a unique invoice number that is made up of two elements and I dont know if this can be done. I am wanting to auto number clients simply each client is a new number but then…
-
Button
Hi, is it possible to filter a view per determined field contents using a button?
-
Can i angle the data form field titles?
Hi, can I angle the data form field titles?
-
Transfer a Ninox DB
If I develop a DB for someone else, can it be transferred to them, provided they also buy the app?
-
My table got deleted
Help!
-
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…
-
date format
How may I change the date display. If I digit: 25/10/1949, I get: 25 genn 2010, Why?
-
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…
-
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.…
-
How can I calculate age at the time of an event in years?
I have the fields for Date of even and date of birth (DOB). I would like to calculate the age using these and display it in years. When i use the formula Date-DOB then the time elapsed displays in…
-
Time formatting
I'm trying to use the Format function on time values, but the results are adding 7 hours. For example: format(time(4.13,0), "hh:mm:ss") should result in 04:07:48, instead I get 11:07:48.…
-
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);…
-
must you buy a subscription
Must i buy subscription
-
How do I set a password to protect my database?
I would like to set a password which must be entered prior to being able to access my database. How do I do this? Thanks.
-
Photo
Hi, I have a table with several records, each record has some pictures uploaded by the 'add file' tab present in the "table with form" view. Actually I add an email field at the table,…
-
Counting trips
Hello ninox team, i am working on a table where i put my trips, i want to count my trips within the month, the counter must reset at next month. For april, if i have 4 trips i want them named 1..…
-
HTML formatting
In a formula field, for example, if I put only one code with html format the "bold" style works good. html("<b>HOME</b>") When I add a new word it doesn't work good.…
Answer questions and share your knowledge