-
Populating a field in one table with text value from another table
So to preface this, I'm not really a "database guy" per se, I'm much more of a spreadsheet guy, and it's been a while since I've built a db. I'm mostly relying on my scripting experience in other…
-
Price books and ninox
I will work with price books. Articles can have a special discount or price per customer. If no special price or discount, I use the normal sale price from the product. How can I do this in Ninox?
-
Need formula help please.
How do I use the %s shown in the referenced table as a multiplier in the Place Payout fields? I don't want to go back to the referenced table since I need to use the %s shown in the referenced record.…
-
Is there an updated tutorial anywhere that isn't incorrect?
Greetings, Is there an updated tutorial anywhere that reflects the current software and included templates/databases? Many steps in the existing tutorial are missing/don't work, and the sudden,…
-
Can I restrict entries in a Referenced From table to one record?
I never want to use more than one record in the refernced table. How do I do that?
-
How do I move a line from one folder to another
How do I move one line from one folder to another
-
Representations of the Id
I wonder if anyone can explain to me the differences I see here Id Formula is just this.Id which shows as 0 in the list and 6 in the form. When this is copied to another table it becomes X6 Thanks…
-
Creating new link from a N:N relationship
Hi all - My Results table has a link to Riders and Horses. I have another table (Ownership) that also has a link to Riders and Horses. Currently in Results I select a Rider and Horse for each record.…
-
Undo the action of a button with another button
Hi I create a button to remove the duplicates of a column And I should like to go back. Is there a way to create a button able to undo the action of the first one ? Thanks
-
Impossible duplicate a base
Hi, I can't duplicate a table. I clik on "duplicate this table" in the window opened by clicking on the gear tool I select a field. And the new table is empty… Where is the mistake ? Thank you
-
Navigation from location
Perhaps I'm missing something but if I click on a previously entered location I can't find route?
-
Create Table reference issue with Ninox 3.3.3
Hi, I’m facing an issue when I try to add a table reference to an existing table. I can add the reference to the table (create table reference) but then I can not open the added reference field nor…
-
Can one delete the action created by a button activating a function?
Hi, I push on a button I created for activing a function and I should like to go back before. Is it possible ? How can I do that ? Thanks
-
Visible Columns vs Available Columns
Hello, I am having trouble with my visible and available columns, after i click the filter icon in my database. Yesterday I moved all of my items from the 'available column' to the 'visible colum.…
-
Need to make Appointments showing in different colors in the calendar
Hello and good evening to all! I created a table with an "appointment" field for 02 different offices.Since calendar will show all appointments for both offices,…
-
Diagramme mit Y Werten aus Auswahlfeld
Hallo zusammen. Mein Problem konnte ich auch nach mehreren Stunden Suche und Probieren nicht lösen und habe dazu auch im manuel und dem Forum nichts passendes gefunden,…
-
Modify a function
Hi, I tried that function. let myV := Ordre; if cnt(select 'Ajouts familles-Tableau 1'where Ordre = myV) > 1 then "Duplicate" else null end It works but when there are duplicates all the duplicates…
-
Duplicate database for a new project from a windows computer
Hi, I am trying to duplicate a database to use as the basis for a new project, but cannot see the duplicate database button. Any ways I can do this? Any help why I am not seeing the button? Thanks,…
-
Database duplicate
How can I duplicate the structure of a database with no data included?
-
Getting Started - example please!
Hi, I'm just getting started and could do with a worked example. For example, how do I calculate the number of days between date1 and date2? The manual gives me days(date1,…
-
Impossible to change the name of a table
Hi I can’t change the name of a table I click on the wrench I open the table on clicking on the gear tool In the upper left corner I change the name of the table I click on save The name is always…
-
A text function that does not work…
Hi I try to extract the word "Ara" from a list of compound words where it is contained : Blue Ara Ara macaw Red Ara … I found that in the Ninox notice :…
-
How do you know when your software (MAC) is updated?
Hello, I used to see (rarely) something saying my app was updated (or being updated), but how do I check? There is no about or version number in the app (MAC version).…
-
Longitude, latitude
I would like location to take the longitude, latitude into a seperate field (coordinates) I've tried adding a formula fiels but can't figure out the formula,…
-
How to create Many to Many relationships?
What is the best way to create a many-to-many relationship in Ninox? Do I create the intermediate table to join the two tables, as with other relational DBs? Here is my scenario. We send newsletters.…