Forgot the inventory table! Good idea on the interactions! I'll do that now :)

Okay I've made some changes to my data model after taking another look at the Inventory template... based on that I think I might be able to figure out the formula's too

Just realized that model is missing some links: - one CRM(customer) can be linked to many orders - 1 person(people) can be linked with 1 address (in the case of shipping address contact)

Hi Julian That's what I had a vague idea of in my head. Good to know I'm on the right track. I'll update this thread with my results to benefit anyone else wanting to do the same. I am having to check if all of what we want to do can be done with netsuite though, as we are hoping to have it implemented to allow for an account system that can be used globally. edited to amend Looking at netsuite, it may suite our needs, but there's a chance it wont be approved so going forward I'm going to go ahead with Ninox as both an on-boarding process and contingency plan in case net suite doesn't happen for a while.

Hi Julian So I've been playing with Ninox and it's growing on me! I think you're right, it is the way to go. I do have some things I haven't quite figured out re the data model, but I'll ask those questions separately. For the moment I have created our CRM, and will be introducing 2 staff members to it tomorrow to ensure that it will work for our needs - then I'll add on to it from there.

Hi Julian, thanks for your reply! I started playing around with Knack yesterday, and I just signed up for a trial of Ninox today. When it comes to limited views - nearly everyone in the company will need to have access to everything, except for a select few who will only be allowed to view the BLA section (which will contain overview, individual BLA's and the production planner for it). Ninox definitely seems powerful, however due to not being able to link between databases (which, I understand, is a common theme in this industry), I fear a database could get very overwhelming very quickly. I'm leaning towards knack due to the customization ability of the web app (being able to do drop down menu's is looking quite promising, as is being able to embed - I could create an entire portal for the company from scratch essentially), but then it lacks features (like a kanban view - I like how Ninox has the different views including kanban and gantt chart) and the way connections work is a little... frustrating (I love how in airtable, I can import a CSV with a column pre-filled for connections... and if the connection isn't already in the linked field, it creates it. I had a lot of trouble with knack to work out how to import contacts and companies with the connections pre-filled). Do you have any examples of a Ninox database with a large number of tables, and how it looks? Essentially everything we want could be sub-categorised like so: CRM - Companies - Councils - Customers - Contacts - Interacts/Tasks/Notes Orders & Products - Orders - Products - Inventory Tenders - Tender list - Tender assets BLA - BLA Summary - BLA's (essentially the "invoice") - Production Planner (this is the most complicated one... we have 3 main stages, which each have several machines assigned to them, which then have daily capacities forecasted, then updated with actual each day, and it goes on... honestly I think I'll need to make a copy of the file without sensitive data to really explain it haha) (we are looking at completely overhauling the "BLA" process as there's a lot of redundant steps since its been built on over the years) Plus there could be additional things we find would be beneficial to add to the database, which would likely need to link back to the CRM, so would need to be in the same database. Our head office is a small team, with everyone's jobs linked in some way, which is why everyone would need to be able to view everything. **Also I haven't imported any data into Ninox yet. Going to do it when we get home from voting, so I'll get a better feel of it then (Also, I'm in Australia) (Also, you're amazing, thanks for your advice on this)