P

Technical Help / How do you get rid of the obnoxious background color in Ninox. That purple sucks. I am still using the older version because of it. Why not make it adjustable? Please!

Hi I am also very interested in getting rid of the blue/purple color but since I am an absolute novice I would very much appreciate if either of you or someone could write exactly how this is done. Thanks in advance! Colors are important! :-)

J

Technical Help / Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox

thanks, Fred. Will give it a shot. Definately not sstuff I already know, certainly notin working with Ninox!

J

Technical Help / Help with an Excel like formula in Ninox

Sorry... Re Example 3. PERIODS in yellow and JOIN in green

J

Technical Help / Help with an Excel like formula in Ninox

Hi Moving from Excel to a database can require a bit of thought. Each sheet can look similar but require different treatment in a database. Example 1. A single table This import would require just a single TEACHER table to be created and the excel sheet imported into it. Example 2. A one to Many relationship This is best re-created with 2 tables. A TEACHER Table and a PHONE table in a one to many

J

Use cases / How to create an invoice for a collection of orders?

Our pleasure Martijn

Ninox Profile

Technical Help / Help with an Excel like formula in Ninox

Maybe this thread helps? https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/like-countifs-in-excel-5e8cf4c35e353d53a6fa5b7e

Ninox Profile

Use cases / How to create an invoice for a collection of orders?

Guys, this is amazing! I have used John's code and it works! Thank you so much, as I would have never figured this one out by myself!

E

Technical Help / Help with an Excel like formula in Ninox

Very new user here! I am transferring my Excel spreadsheet into Ninox and have hit a road block. I am creating a whole school timetable. I have multiple tables including: 'P55_Current Allocations', 'Master Grid' and 'Teacher Data'. I have 32 columns on Master Grid. The first two columns are pulled from fields that are in Teacher Data (Code & First Name). The rest are in the form of M1, M2, M3 M4 M

F

Technical Help / Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox

Hi there - I hope I can add some clarity. You say: There are three ‘parent’ tables, which could have a number of fields, only one of which as relevant. My tables in this category, which have only one field, are: Providers, field Provider; Categories; field Category; and, Services, field Service. There are two M:N tables, each of which has two fields with the same name as the fields in the relevant

J

Technical Help / Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox

I’m attempting to duplicate parts of a personal use data base that I originally created in MS Access (V2.0, I think) which I ‘migrated’ through various Access versions and then into FileMaker. I’ve moved to a Mac M1, so am looking for an affordable DBMS. My option, at the moment, seems to be Ninox, although it appears that LibreOffice is moving forward fairly quickly. The structure that I’m thinki

F

Use cases / How to create an invoice for a collection of orders?

Damn, John beat me again. Just as I figured out a way to create an invoice for each customer of the current shipment in a button: let curRec := this;let xCust := Customers;let arrCount := count(xCust);for loop2 in range(0, arrCount) do let newInvoice := (create Invoices); newInvoice.(Shipments := curRec); newInvoice.(Customers := item(xCust, loop2))end Line 1: The change here is I created a formul

J

Use cases / How to create an invoice for a collection of orders?

... and again. All select statements removed now and tested with maore than one Shipment record!

J

Use cases / How to create an invoice for a collection of orders?

Sorry, I made a mistake. I started writing it to also cosolidate all Shipment records and left a select statement in that wasn't neededTo work per Shipment record it should be Regards John

J

Use cases / How to create an invoice for a collection of orders?

Hi Martijn Using the same data structure I showed this updated code works (I have run it so I know it works). It creates an invoice per customer in the shipment record and consolidates the order lines, summing the quantity. I don't think you need a SHIPPING LIST table as well to achieve what you want. If you want me to explain how it works, let me know. I think you can adapt it to your workflow as

H

Technical Help / Illuminati in Lesotho ℰஐ۝த+27632807647த۝ஐℰ ҉how to join Illuminati in Lesotho,Liberia,Gambia,Maseru,Banjul, USA, UK, UAE, NAMIBIA

Illuminati in Lesotho ℰஐ۝த+27632807647த۝ஐℰ ҉how to join Illuminati in Lesotho,Liberia,Gambia,Maseru,Banjul REAL ILLUMINATI AGENTS CONTACTS +27632807647 ILLUMINATI MEMBERS, ILLUMINATI CHURCHES, ILLUMINATI OFFICES HEADQUARTERSIlluminati website to join +27632807647, how to join true Illuminati online, how to join the Original Illuminati for money, how to join Illuminati for wealth, benefits of joini

H

Technical Help / Call and Follow Priest Naseef To Join Illuminati Kingdom +27632807647 lesotho http://naseefbahwan7.blogspot.com and Email: naseefbahwan7@gmail.com in Durban for Money +27632807647 ,Fame And Power in South Africa, namibia, botswana

Call and Follow Priest Naseef To Join Illuminati Kingdom +27632807647 and Send on Website: http://naseefbahwan7.blogspot.com and Email: naseefbahwan7@gmail.com in Durban for Money +27632807647 ,Fame And Power in South Africa, Join illuminati in, Call and Follow Priest Elvis To Join Illuminati Kingdom +27632807647 and Send on Website: http://naseefbahwan7.blogspot.com and Email: info@joinbillionair

H

Technical Help / How To Join Illuminati Secret Society For Money %@#!&~~) +27632807647 In South Africa, Ghana, namibia, botswana, swaziland, uk, usa, uae

HOW TO JOIN ILLUMINATI SECRET SOCIETY FOR MONEY %@#!&~~) +27632807647 IN SOUTH AFRICA, GHANA JORDAN, Kuwait, Turkey, Belgium, Saudi Arabia, Australia, Malaysia,a Johannesburg, Lebanon, Zambia, USA, Kenya , California, Dallas, England, German, Spain, Jamaica, St, Lucia, Brasil, Germany, Austria, Vancouver, Denmark, Hong Kong, China ,, Pretoria, Durban, Australia, Zimbabwe, Wales, France, Harare, Ca

H

Technical Help / ‘‘ ’’ join illuminati in accra, kumasi, tamale, takoradi, a+27632807647 - Sandton namibia, botswana, swaziland, uk, usa, uae

Chief PRIEST. Naseef ( ). His Eminence King of all Temples anointed and embraced me to be one of the few chosen special chief priests in the whole world. His eminence King of all temples entrusted me and gave me full Authority and Powers to Recruit and join all willing individuals to join our powerful secret society of great wealth and happiness. His eminence king of all temples granted me permiss

H

Technical Help / > Kuwait , zambia, +27632807647, Join Illuminati Netherlands, illuminati in Iceland, illuminati in Dubai +27632807647, illuminati in Mauritius,uk, uae, usa

Join illuminati in Lesotho +27632807647, illuminati Members in Lesotho, illuminati in UAE, Dubai, Antigua +27632807647 Join illuminati in South Sudan +27632807647, Gabon, Chad, Join Illuminati in , , Illuminati in Libya, Andorra, Join illuminati in Spain, France, Paris, Join Illuminati in Kosovo, illuminati in Italy,Germany Call+27632807647, illuminati in Oman +27632807647, illuminati , Illuminati

H

Technical Help / ______+{{UGANDA]] HOW TO JOIN 666 ILLUMINATI SECRET RICH SOCIETY 100% FOR MONEY +27632807647 Australia, Canada,uk, uae, usa

______ + {{UGANDA]] HOW TO JOIN 666 ILLUMINATI SECRET RICH SOCIETY 100% FOR MONEY +27632807647 Australia, Canada, Dubai, Germany,, Kuwait, BILLIONAIRES CLUB HOW TO JOIN 666 ILLUMINATI .. >>> SECRET SOCIETY FOR8 ?? IN USA, UK, Canada, Spain, Italy, China, Hong Kong Free state, Botswana, South Africa Zambia, Swaziland, Canada, Guyana, Germany, Spain, Poland, Switzerland, Romania, Bulgaria, Denmark N