-
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?
-
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…