-
UNCHECKED spam on this mailing list is more than a nussance.
The UNCHECKED spam on this mailing list is more than a nussance. It is so pervasive that it severely damages the utility of this list as a platform of support for Ninox.…
-
Suggestion: Width of Popup being dependent on Table
It would be very efficient and helpful to have a system table-centric setting to return the popup (popout?) width be depending on the table. We are forever moving it back and forth.…
-
Report Writer
I emailed this to sales and they sent me a link to ICloud but no mention of the Report Writer. ( I have the MAC desktop version and found it easy to use for development of my database.…
-
Returning the last date from another Table
I'm building a beekeeping database. I have a 'Colony Table' which is the parent table. I have an 'Inspection Form' which is a child composition table to the 'Colony Table.…
-
table reference error stating "Return type mismatch for then and else expressions. at line #, column ##
I am attempting to set the link between 2 tables, but I get the above error when I attempt to set the reference Id. I have a button with the below: let Customer := record(Customers,this.…
-
Help with last Formula...
let xFrom := From;let xTo := To;let Cus := CUSTOMER;sum(Invoices['Date of Invoice' >= xFrom and 'Date of Invoice' <= xTo].Customer.133) This does not return the amount shown in the view of Total Shop…
-
How to create a button to start a new Appointment?
Hello and good day to All! I have a table called "Events" where I record interactions with customers (a simple form with selection of date, remarks, choice field to select if email sent,…
-
Date field without calender popping up
I'm using date to enter date of birt, but I don't want the calender popping up as it's too diffcult to us that and go back years.On my laptop I can avoid using the calender but on the phone the…
-
Select items or record by record
How do I get the Voornaam one by one: Script: let t := "";let firstNames := for item in Namen.Voornaam do t := t + Namen.Voornaam +", " end;t result : "GregoryAmandine, GregoryAmandine,…
-
Roles dissapearing
I created a user and added a new role "allow-delete". I then proceeded to our tables and added the role restriction. All worked fine. I then deleted the user and wanted to add the role to other users.…
-
Recursive functions in Ninox
Is creating a global script function which call's itself not allow in Ninox ? If not what is the best way to create formula's that use data out of a parent-child table structure.
-
Formula to select an exchange rate based on currency and date of payment
Hi everyone, New day, new Ninox puzzle :) I have a series of fields in a subtable recording past exchange rates for a series of currencies (we use InforEuro, so these are monthly exchange rates).…
-
Delete incomplete record
I would like delete a record if on exit I check the absence of the value of some fields. I think the right function is "delete (this)", but how to implement it for this need? Thanks
-
Problems loading database
Good morning,Does anybody else have problems loading their database this morning?/Gry
-
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?