-
View not showing top line on update
I have a view in my form that's tied to the choice a user makes for Client (a --> linked table). When the user picks a new Client, the view (of their Pets) updates but many times (most times) the top…
-
How to Calculate Cumulative Sum
I have this info on my Table COST_W, I have the Week, the Cost by Week, but I need a Formula for calculate the Cumulative Sum. On the Table EV_Management is where I charge the Cost by Activitie and…
- Answered
-
emailing list of contacts not changing the firstname in list
I have done a script to send an email to all valid contacts to update the prices. It all works fine except that I have an issue in that the contact first name is only picking up the name of the…
-
Issues re-ordering tables in side-bar
Hello, I would like to re-order the tables in the sidebar, but it doesn't seem to be working properly. Some tables can be moved into the desired location,…
-
Cannot open databases since last update
Hello, yesterday my computer installed the latest Ninox update (3.2.6). Since that moment, I cannot open 2 of my 3 databases anymore. I can open the app and see the main menu,…
-
Are the numbers of fields limited ?
Hi I have an imported base with a lot of fields. I find them all in the form but it seems that in the table you can't exceed 23 fields. Is this normal ? Can one fix it ? Thank you
-
Subtable - ordering system
I'm trying to create parts ordering system for my shop. Is it posible to automatily open new subtable record When i'm adding new part number to subtable of single order.…
-
Templates and Manual
Hello,I really like Ninox, but I find it a little annoying, as others have said in the past, to want to develop my applications in this DB and I can not because I do not have a good manual or some…
-
Formula for age calculation
Hello I need to roughly calculate age of persons : (ThisYear : is there a fonction about that or do I have to put '2019' in text?) - ('TheBirthField') What is the formula for this ?…
-
calculate time elapsed between two concomitant records
Hi, I would like to know how to calculate time elapsed between to concomitant records; for example a record have a field named date_time and I would like to know the time elapsed between record 1 and…
-
Optimize this Code is to large
let s1 := if Status = 1 then 1 else 0 end; let s2 := if Status = 2 then 2 else 0 end; let s3 := if Status = 3 then 3 else 0 end; if s1 then let reply := dialog(" 🟢 Audit To History",…
- Answered
-
Load (Transfer) Data
There are any way to Load (transfer) data for one table, to a Reference 1:N on other table, with a Button.
- Answered
-
Renaming part of title attachment
I need to assign the rename function to the button "Manuell Nr zuweisen". By clicking on it, an alert field should come out in which you are asked to enter the number you want with a blank field to…
- Answered
-
Need to show only the Deliverables that will be issue in the next 7 Days.
Need to show only the Deliverables that will be issue in the next 7 Days, from the DataDate. I need the script that give me information, the information must be taken from the dates FechaP1 to Fecha…
- Answered
-
Structural Problem - How to choose multiple items to add to an Invoice?
I have Appointments. Each Appointment has multiple Invoice Items (since Appointments are only ever invoiced once, they double as the invoice). Available Items to add as Invoice Items come from a…
-
Expiration date in colour
Hello. I am at loss. Been trying many configurations but can't get the fields work. I have a table with one field called expiration date. I would like the field expiration date to be displayed in RED…
-
How can I set up two fields, one showing date/time record was created, one showing date/time of last modification?
No clue as to what is required here
-
Complex Select statement for View
Summary of what I need to do: I have a table called Actions within which I am trying to create a view of all actions which are compatible with the current action.…
- Answered
-
Creating many to many relationship between two tables
I am trying to create a many to many relationship between two tables. The database I am working on has two tables one is movies and the other is actors.…
-
How do i get my numbers $ to format right?
I can not get my imported in number - totals to format to show right. I have changed the formatting to every setting in their and none work to fix it. This is how they come in from my CSV files.…
- Answered
-
Dynamic Choice Field reference in a function
Hi all, I want to make a function out of a formula I often use in my Database. The function involves the following fields: FieldA: text FieldB: text FieldC: date FieldD: choice FieldE:…
- Answered
-
Trying to "hide" records in main table
I am trying to "hide" records in my main table (Orders) by having them move to sub table (Received) when the field (Received by)= 1, 2, or 3. I am not sure how to write the code correctly to get it…
-
How do I input a csv table list into a multiple choice values table? I have a 100 choices and I don't want to type them all out.
I have a 100 choices and I don't want to type them all out.
-
How can I generate bar codes from my ninox database ?
Hello, My company is using Ninox. We have a database which contains all our references. I'd like to know how can I generate a bar code for each reference and how can I scan it ?…
-
Look Up tables
Hi I am new to Ninox. I do building surveys and really like the ease of carrying out a site survey and getting the information onto the system.But I have a question to see if I can get more detail…
Answer questions and share your knowledge