-
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"?
-
Call REST
The result of the function is the response of server?
-
How to massively link all invoices to their customer?
I have imported a customer table with 300 records and an invoice table with 500 records. Both tables have the customer no. How to massively link all invoices to their customer?…
-
Datamodel
Hi Sorry, but I am confused I quickly created a number of tables/database (which show as different items on home page) When I open a database I sometimes see a 'spanner',…
-
set the Search function
Is there a way to not make a field appear in the search function?
-
jesuha.serge@gmail.com
Hello, I write a process where A, B and C are variable with text. Then i have : 'text' := A + B + C Is it possible to insert a code to have a ligne empty between A, B and C, like 'text' :…
-
jesuha;serge@gmail.com
Hello, how can i copy a field from one table (Mes soins.soins) and paste it to a field of an other table (Pateints.fiche) witch is not in relation ? I'd like to make it with button
-
Help! Is there a way to change the concatenate from a comma to a hard return?
I have a trigger to copy all the items from a sub-table ('Item Desc" into a multiline field ('LongDescription'), LongDescription := concat(Items.'Item Desc.…