-
Conditional formula to calculate 'taxable' and 'non taxable' items...
Hello, I'm trying to figure out how to include two fields that calculate the sum of taxable and non-taxable items. If you look at the attached image, you'll see that there's a field for the base…
-
coding for create record
Hi, When I click the +Create Record in a referenced table, I get a new record in which the client code (a unique code) is filled in as is the link which the parent (client) table.…
-
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…
-
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…
-
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
-
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.…
-
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…
-
Error in a script to find duplicates
Hi, I tried to remove the duplicates of names in a Ninox database with this script found on the forum but I have this error : "A table has not been find Oiseaux on the line 1, column 31".…
-
N:M relation in a view
As a publisher, my catalogue has numerous Medias. Each media contains 1 or several Works (Oeuvres). This implies a N:M relationship and a pivot table (Occurences).…
-
Print: bold text
in print mode is there a way to highlight a few words in a text in bold? I tried to insert the html code in a function and I succeeded, but in creating the pdf the bold text is not highlighted. Why?
-
Relational Tables
I'm on the paid version. I'm stumped!! Have spent hours on this and not able to crack it. I've got a table called Items And a table called Tags As item can have many tags and vice versa,…
-
ALERT when value drops
Our database is being used to measure orphans in Africa. Each child is weighed every week or month, and we would need the database to immediately alert the user if the weight of a child drops, eg,…
-
Search Bar with Button
Hello, For weeks, I have been trying to create this formula, but have not had any luck (I am also not sure if this is possible. In this instance, I am working with 3 tables: Invoices, Products,…
Answer questions and share your knowledge