-
SQL to sum the sessions for only the current month
Hi, I have this code behind a button and when I click it I want it to populate a table with various information (which is partially working) let me := this;for i in select Pupil dolet myInvoice :…
-
Limit view to sessions scheduled for next month
Hi all, I have this form which is a reference to another form - all I want to do is for it to show the sessions scheduled for next month, I know I need to use the month function but I'm not too sure…
-
I am making changes but Ninox isn't asking to save them
I am making changes to a formula field but, after clicking the OK buttons, Ninox isn't asking for the changes to be saved and the amended formla is being ignored.…
-
Export images file
How can I export a file with also the editable link of images?
-
Show-Hide tab
Hey all!What's the code to hide a tab if the view inside it contains no data?In my case it's about a tournament event where i sometimes have plays in Group A-D and sometimes only A-C (depending on…
-
Formula: Payment terms and due date
Hello :), I'm trying to establish the payment terms of my clients into my invoice in order to have the due date calculated automatically. Could someone explained the kind of fields and formula I…
-
When to enabled "Index" on a field in a table?
Is there any rough guide or rule of thumb for when it is helpful to enable the "index" for a field in a table? My database includes a lot of calculations with select statements,…
-
sum
i have choice field in invoice item that there is "Ordered" and "Pending" and Cancel". when my customer confirmed one item or some items order then i choice "Ordered".…
-
Create a button to automatically change a calendar date
I have named a button "annual subscription paid". What this button should do when pushed, is automatically roll the date of the annual subscription expiry to the following year.…
-
Aggiornamenti
Innanzitutto Complimenti per il lavoro che state svolgendo. Volevo però chiedere se e quando riceveremo un nuovo aggiornamento del database con le modifiche richieste in passato .…
-
Merge two Archives
i have put the a ninox file into dropbox to sync my two computers, laptop and stationary. i did some extensive changes on both of the computers before realising,…
-
Question: Looking up VAT data from another table by code and returning the vat value to another field on a form
I have a table called VATCodes (first field has ‘Sage like’ VAT codes ie T1,T0 etc, the second field has corresponding VAT % rates ie 20.00%). Form/Table 2 (test), references the VATCodes table,…
-
Adding Travel time
How can I add travel time like an hour to my meetings and other tasks?
-
Is It Possible To Access A Ninox Database From A WD NAS Drive?
Hello I have a Western Digital NAS Drive and was wondering if it was possible under the settings cog in the top right of the program and under Select Server,…
-
Como colocar no link para que ele direcione para a pagina da web?
Exemplo em anexo. Ou seja eu clico encima do link e ele não é direcionado para a pagina. O que esta ocorrendo? Lucidio lucidiojf@gmail.com
-
Ninox cloud storage capacity
Hi looks like Ninox could meet the requirements of my organization. The only thing that I am wondering is that the 2Gb storage per user seems small specially if it is necessary to create many records…
-
Printing data from a table
I want to print each row in my table (not in a table format, in my own format). I can create a formula where it displays the first rows information or the last rows inforation of the table.…
-
Problema con orario appuntamento
Salve sto riscontrando problemi con gli orari appuntamento. In effetti se digito in un campo "orario" una determinata ora, nel campo appuntamento avanza di un ora. Ovvero digito 8.30 e scrive 9.30
-
Images effacées ?
Bonjour, sur certains documents j'avais inséré des logos et PDF. Lors de l'ouverture des documents les logos et autres PDF n'apparaissent plus ? pouvez vous m'aider à les retrouver. merci
-
Updating a related record when using API
I have an API call that brings in the updated information on employees based on location. I have an employee table and a jobs table. The jobs table is related to the employee table as an employee is…
-
Replacing data in an existing database error
I am not able to import a csv file into an existing database (using UTF-8) and replace existing data without it giving me the following error (Could not read file. Please choose another encoding).…
-
Readable if and writable if, how to use these fields
I have two tables that I've made only visible to "admin" but I would like to let one other member of the team have access without giving her admin status,…
-
Convert decimal into fraction
Hello, I am looking to create a formula that will convert 'Number' from a decimal value to a fraction value. For example: 0.5 to 1/2, 0.75 to 3/4
-
Time chart
I'm missing a chart option based on a time field.
-
Copy/paste or importing a date into a date field
When in Table mode on Ninox Cloud and in a Date field, and I manually copy a date from one record to another record (e.g., "2019-11-30") in the same Date field, and paste the value,…
Answer questions and share your knowledge