-
How do I change email on my own profile?
Thx Jesper
-
Formula for finding sum based on a condition
Hello, Here is what I have: 1 - A number field where I put in a value 2 - a choice field where I have 3 options 3 - a formula field (in a linked table) where I would like to calculate the sum of the…
-
Is there a way to auto-increment a number field so that the numbers only happen within the subtable record of a parent record?
OK, that's probably not clear, so let me use an example of what I want to do (this is not my use case which may be to obscure, but it illustrates the point:…
-
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.…
-
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,…
-
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
-
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…
-
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".…
Answer questions and share your knowledge