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! :-)
thanks, Fred. Will give it a shot. Definately not sstuff I already know, certainly notin working with Ninox!
Sorry... Re Example 3. PERIODS in yellow and JOIN in green
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
Our pleasure Martijn
Maybe this thread helps? https://ninox.com/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/like-countifs-in-excel-5e8cf4c35e353d53a6fa5b7e
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!
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
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
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
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
... and again. All select statements removed now and tested with maore than one Shipment record!
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
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
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
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
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
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
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
______ + {{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