-
Use "select ... where ..." or "select ... [...]"?
Proposition: It is preferred to use "select mytable where criteria" over "select mytable[criteria]". I only recently saw in the forum the use of a square bracket criteria expression on a select…
-
Read-only remote access to database by anonymous users?
I'm currently using a free trial of the cloud-based Ninox. From the point of view of creating and managing the data base, it seems perfect as a small library-style catalog for materials (e.g.…
-
Import makes duplicates ?
Hi When I want to import datas from csv format into a Ninox base and I look to the table wich displays the modifications that are going to be made, I notice that in this table are still datas that…
-
Connected viewed records with a view - One Customer
I have copied a Connected view formula from Webinar 2021 112-Print view element in dashboard which is brilliant, thank you to the person who added that.…
-
Sum a customer sale in a view
I would like to sum all Sales for a customer in a view table shown in a formula field. l have let xBeg:= 'Beg Date' let xEnd:= 'End Date' sum((select Invoices) ['Date of Invoice'>= xBeg and 'Date of…
-
Sales Tax Issue
I looked through the forum and I was unable to find an answer that works for me. In Pennsylvania, sales tax is only collected on select items. I'm trying to create a formula that returns the sales…
-
New functionality in the calendar
It is posible to add tooltip in calendar view and grag and drop funkcjonality?
-
Dynamic single choice
Hi everyone, i have little problem. I use a dynamic single choice field, its a new. Very nice! But when i try to print this field it return me the index and note the text value.…
-
Export pictures from Ninox
Hi When I exported a Ninox base where there are few pictures as fields to Numbers in csv format the pictures are displayed as, by instance : "A376/images.jpeg" and not as pictures.…
-
Limit field value based on another field
Wasn't sure how to use this. I have a table that contains data for medical payments, and a number of other tables containing data on Categories, Providers, Service, etcetra.…
-
How do you change the time in week mode for the calendar to AM/PM from military time?
How do you change the time in week mode for the calendar to AM/PM from military time?
-
Styled Color in Calendar
Hi to all. I'm trying to get calendar text to show as colors based on their status in a dropdown. This is the string that I want to show: Status + " |" + Customers.…
-
Nested Dynamic Lists
I'm trying to add the ability to attach a category and sub-category to a record. These lists of values need to be dynamic, so I am making use of the Choice (dynamic) field type.…
-
To change a word of a field with a formula ?
Hi Can someone tell me the way to change a word of a field with a formula ? ie change the word "limicole" by "petit échassier limicole". In fact, add "petit échassier" in front of "limicole".…
-
Dynamic choice which trigger numeric value change?
Does anyone know how to have a numeric value pulled as a result of a dynamic choice please? I have a dynamic choice field called 'Stock Parts CABLING' which pulls a list of parts from a table called…
-
Text field containing all data from other table
Hello, i am looking for a way to display ALL data that is within another table. I have a sub-table (from another table, not linked to the one where the dashboard is) that looks like this:…
-
Can I add icons?
I use Ninox to manage my income and expenses for tax. This means categorising the expenses as travel, production costs etc. using a picklist. As this is quite a long list I use icons in the list to…
-
user id
i would like to have the field user id filled automatically, from the user....i think is a stupid thing
-
Another way than import datas ?
Hi, I should like to import some datas from the app Numbers to a Ninox base. I export the sheet in csv and try to recover it in Ninox. But I can't succed to do that with the import function in my…
-
Automatic email sent on a specific date. Is that something possible to do with Ninox?
Hello, I have created a date field to record the birthday date of my client. I would like to set up on Ninox a way to automatically send an email on their birthday's date.…
-
Dependant Table Actions
Scenario: we are managing email templates for different clients. Table A Contains - Email Type - a list of the types of email templates that exist Table B Contains - Customers - a list of the…
-
How to change the sixe om table view on ipad?
Can anyone help me?
-
Query Help for a VIEW. Unexpected behavior.
I have a PLAN HEADER and PLAN DETAIL parent-child structure. I have it setup so that I use a slider when ON shows ALL PLAN DETAIL line items, and when OFF,…
-
Returning field ids instead of field names when getting a single record using the REST API
When getting multiple records with the API, it is possible to send a query parameter of ids=1 to return the field id instead of the field name. Does this funcationality exist for the get a single…