-
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.…
-
Suggestion - Add more functions
Can you work on adding more of the standard spreadsheet functions. The MIN and MAX functions that allow the 2nd, 3rd, .... so minimum and maximums to be calculated, would be a great start.…
-
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…
-
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.…
-
How to replace the comma by a break line when you print a multiple choice?
Hi, Maybe I missed something but I did not find the information in the manual: how to replace the comma by a break line when you print a multiple choice? Regards, Laurent.
-
Select
Hi, can I filter data with a double select function? Thank you
-
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.
-
Views
Hi, I would like to know how to show timeline in calendar? For exemple: I have contract from 1.07.2016 till 31.10.2017, and the second from 1.08.2016 till 31.07.…
-
How do you copy or move a record?
I need to move some records from one table into a different table, but I cannot find a way to do this. In most database programs, you can cut some records from one table, then paste them into another.…
-
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,…
-
How do you link fields on different tables?
s from two different tables? For example if you had last name on one table and want to link it to last name on the other 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.…
-
How can I choose another printer?
I have two printers connected to my laptop. I like to make a choice witch printer I like to use. Beacause one of them I a label printer. Can I make a script in console and wath fomular I need?
-
ID View
Hi, is it possible to view only the ID sum that are > then # 1? Thanks
-
How can I sort the items?
I have a table with customer items. I want to sort these by date or order number (both good)But if I choose sorting a-z or vice versa. It is not sorted.…
-
void or null
Hi. I looked in the manual, but I didn't find anything about it. In Ninox code what is the difference using syntax "void" compared to "null"?