-
Suggestions
Add a drawing field that would be similar as the signature field, being able to name it, would use the full screen. Also agree with people asking for search within table, search on content as well.…
-
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
-
Table labels
Hi, when I have many tables, it would be nice to have something to organize table menu, for example labels.
-
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.…
-
Select
Hi, can I filter data with a double select function? Thank you