-
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.…
-
How to modify the link of a record?
I made a mistake by linking one record to the wrong category and wanted to correct it, but the menu item U remains always dimmed (not selectable). My categories are "Essen", "Esswaren",…
-
Invitations
Hi, is it possible to invite a Ninox user from a different organization as my teammate?
-
Columns
Hello, Is there a way to add to the table columns from a linked table? For example I keep all my customers in one table and all my invoices in the other,…
-
If function connected to two choice menus
I have two choice lists, one is the status of order for single item and the second is status of the whole order list. Is IT posible to make that when status of all single items Are Market as…
Answer questions and share your knowledge