-
Help in making queries
Hello i have a db (many thanks to @Fred ) and now i need to make some queries. In a table where i have a list of "transaction", (sum of products sold and product returned) i want,…
-
script to find if student enrolled last year
Hi, I'm not finding the logic to write a script that would check if in a given school year (Sept-Aug) the Parent table , a student currently enrolled - the child table,…
-
Where place the alert ?
let me := this; if 'Plan_1 Editable' < 'Data|Date' and > 'Plan_2 Editable' then "" else "OK" end; while weekday(me.'Plan_1 Editable') > 4 or cnt(select Holidays where Date = me.…
- Answered
-
Table cels Background color
Good morning, I would like to create a rule so that the background is green when the indication is 'NO' and green when the indication is 'YES'. I saw that NINOX provides this for sub-tables,…
- Answered
-
use case of create fonction
Sometimes I need a function that searches for a record, creates it if it doesn't exist, and updates it. Here is a simplified example of such a function : But the compiler returns an error :…
-
Unique / Concat giving different results
Hi all. I have a table showing Orders, in which I have Items that are linked to Products, which each have their own Product Categories (in a multiple choice field).…
- Answered
-
HR, CRM and Process Management Apps for Ninox
I thought that people could be interested in a suite of 3 Ninox apps I have created (and have been in use with customers for some time) - and which are available for purchase on my website:…
-
Indirectly link N:1 records
Hello ! I have a table named "Comptes", a table named "Activitiés" and a last one named "Bilans de vitalité". When I create a new record in the "Activités" table,…
- Answered
-
Parse a specific section of a YouTube URL
How would one parse out this section of a YouTube URL Complete URL = https://www.youtube.com/watch?v=BbqlkY0ArfM I want just this portion: v=BbqlkY0ArfM This can then be used to watch a video from…
-
link choice
Hello everyone. I'm stuck for something stupid, but I can't find the solution. If someone could help me? Thanks in advance. Here is my little problem. I created a "Devise" sub-table with different…
- Answered
-
Determine Net New customers via Select Statement for Dashboard
I would like a formula field that will represent the number of clients we have in a month that are first time customers. We are an event company. This will be via a field on a dashboard I'm creating.…
-
Formula ID count also deleted records
Good morning everyone, I have a formula field with ID in it. This shows me the record number. My problem is that I have noticed that this formula also counts me the record ID's that have been deleted.…
- Answered
-
Limit the number of rows visible in a table view
Hello ! I have a table view on my dashboard that sorts customers by amount spent. I would like it to display only the 5 customers who made the biggest expenses.…
- Answered
-
Breakdown chart by city with filters
Hello ! I currently use a graph allowing me to know where my customers are located. For the Chassieu city, I only have one client and it is not sufficiently representative to display it in the graph.…
- Answered
-
Trying to automatically link record from one table to open record in another table using a button
First off, I have already been made aware that line 4 is going to do nothing and line 1 probably needs to be changed, that said here is my scenario. When I create a transaction I automatically apply…
-
MAJOR problem (v3.7.14 Mac)
Made some changes yesterday for first time in a few months. Made some minor structural modifications and went through a fair bit of data, updating to suit the changes (a new field or 2).…
-
how to project this db
Hello need to manage my small business. Every day X products goes out from my store to my clients, and Y products return (my client has not sold them all).…
-
What ? Mean this error
What this means ?? I have some workspace now I only open Database only on one, I can't open DB on the others workspace. There are limitation on workspace ?.
-
Change the field type afterward
Hello.I have a field in "number" format. After some time I use my dB I need this field to be converted to a "text" field. Is there a way or procedure to implement to change its property by not…
-
Convert days to months and years
Hi, I am using the days(date1,date2) function which gives me a result in days. In some results I have a high number like 550 days which is 18 months or 1 year and 6 months.…
- Answered
-
Calculate the most recent date of an activity
Hello, I would like to know if it is possible to have a formula field that allows me to display the date of the most recent activity of a contact (the date of the most recent appointment and not the…
- Answered
-
Automatically change a select field based on a date from another field
Hello, I allow myself to seek the help of the community to know if it is possible to modify a field after a defined time. I use Ninox as a CRM (customer management) I have a subtable for activities…
- Answered
-
Formula turns into letter references
Hello, I am wondering if anyone else has experienced this. I am adjusting some of the structure of my app, and therefore have removed some fields and added new ones.…
-
Data not saving
Good evening. I am loosing data without knowing. It is simply not saving new entries. At first I questioned myself but it happened a number of time and I can now repeat the problem on demand.…
