-
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
-
NEW FORUM
Well done NINOX Team and thank you! At long last we get a new forum - lets hope it all goes well and this is the end of all the spam crap that we were being bombarded with every week.!
-
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,…
-
How do I filter out one or more field values?
I see how to filer for an individual value, but not for vieiwng the results without that value. I want to see all the records that are are clock.
-
Interesting HTML formatting
Hi all - I've been adding HTML tables to my dashboards as they make things prettier and compact. So I found when you have multiple HTML formula fields, you can't change the color of only 1 of them.…
-
About signature Questions
How to copy the images in the (signature) field of table A to the (Image) field of table B? What should the code look like, thank you for your reply.
- Answered
-
Using triggers for yes/no field
I have tried using the visual part of the Ninox formula and various forms of this text in the script writing, all to no avail. if Status = ("Closed" or "Expired") and 'Campaign Premium' > 0 then…
- Answered
-
Generate QRCode to File or Image field
Following a discussion with @CISOFT Sàrl ,I embedded Sangmin Shim's code in a Ninext function to generate a QRCode on Ninox. The QRCode generates a file on the attached files or in the Image field.…
-
Two Serious Problems... Required Fields & Trigger on new record/update
I just realized there are two serious problems that might be deal-breakers for my business. 1. Required fields don't seem too required. That is to say, I can close a record and it saves (because it…
- Answered
-
Get count of chosen values from different table
Hello, The formula below counts the number of records in the table Timetable where the choice field Jim has been chosen the value "norm" (it works). count(select Timetable where text(Jim) = "norm")…
- Answered
-
Trigger after change
I have a Products table.I would like to add a trigger after the change that:if TOTAL = 0 then AVAIBILTY: = "NO"But this code doesn't work!The AVAIBILITY field becomes NO only if I,…
-
Dynamic combobox/dropdown list
Sorry in advance if this has been solved before. I'm trying to create a table with a couple dynamic comboboxes. If option 1 is selected for combobox 1, then only options 1 to 6 will be available in…
-
Need a Constrain
Sorry to bother Fred, I need the constrain for WBS level 5, and. I sent you a mochet. Thanks
- Answered
-
Creating a new record in a linked table using code
I have 3 tables linked to create a many to many relationship. The relationships look like this: [Locations] <--- [Location Tracking] ---> [Tracking] Multiple tracking records and be related to every…