Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

756
123
1

Joined: Thu Feb 11 10:04:26 UTC 2021

My Posts

Latest Posts

Re: Resolving a bill of materials
There are a few posts cropping up re BOMs. I still use FileMaker for this and, with no levels or recursion, it works like a dream. Let me see if I can re-create it in Ninox sometime soon Ninox does…
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: Table or Sub-Table?
@Fred Hi Fred. I'd have a single table for Articles and Materials, otherwise you are going to end up with a third for WIP, with a simple BOM between the item being made and the items being used.…
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
Just realised, you could swap it all round and have let allProductItems := (select 'Products Items'); for i in allProductItems do i.('Product Code' := Products.…
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
Hi Your DCF used product.'Product Items' so why aren't you using that in your code? let allProducts := (select Products); for i in allProducts do let allProductItems := i.…
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: The slowness of the servers is intolerable.
Yup, affecting me this time!
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: The slowness of the servers is intolerable.
It’s going to be quiet on the forum for a few days!
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Data Modelling

I know it was written a few years ago now, but this book has become my go-to for all things data modelling. The Data Model Resource Book, Vol. 1: A Library of Universal Data Models for All…
- John_Halls
- 3 mths ago
- 1reply
- 43
- Learn and share
Re: Table or Sub-Table?
@Fred Ah, yes. Fred is absolutely correct here. When I said I try and use as few tables as possible, I didn't mean I have Employee1, Employee2 fields in my tables (not that I'm admitting to).…
- John_Halls
- 3 mths ago
- 1
- Get help
- Reported - view
Re: Table or Sub-Table?
Let’s start with Trades. Can you explain what they are? Thanks
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: Table or Sub-Table?
Hi @Michael Cornelissen I would be asking a simple set of questions that determine the relationships. Can a Contact have more than 1 invoice? Yes Can an invoice relate to more than one Contact?…
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: Button with script to populate table
Hi @Alain Fontaine working as it should, thank you. I think it might have been a column formula that threw it, as you said. Maybe I was trying too hard to beat @Fred to an answer and rushed it!
- John_Halls
- 3 mths ago
- 1
- Get help
- Reported - view
Re: Button with script to populate table
@Alain Fontaine I was trying it prior to setting any columns. It doesn’t show any records. Had me flummoxed.
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: Button with script to populate table
@Alain Fontaine I tried this and couldn’t get the view to work. Not sure what I was doing wrong.
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: Button with script to populate table
6. List of Students... is not a table but a view that uses the existing structure. So create a view in the 4. Assignments table with this formula '5. Classes with Assignments'.'2. Classes'.'3.…
Attachment
- John_Halls
- 3 mths ago
- 1
- Get help
- Reported - view
Re: Ninox 3.13 available
@Rafael Yes, it is affecting me
- John_Halls
- 3 mths ago
- Learn and share
- Reported - view
Re: Ninox 3.13 available
@Vermaji This might not be to do with the new version. Go to the child table, set Composition to No, unlink the record and link it to the correct parent and then set Composition back to Yes
- John_Halls
- 4 mths ago
- Learn and share
- Reported - view
Re: Ninox 3.13 available
@Paul Chappell Not just you. Me too.
- John_Halls
- 4 mths ago
- Learn and share
- Reported - view
Re: Relative record numbers in a table
Hi all. Be aware that a select statement in a formula needs a reason to trigger, usually when a non-formula field changes in value, but it's always a risky strategy.…
- John_Halls
- 4 mths ago
- Get help
- Reported - view
Re: Relative record numbers in a table
Hi @brentjl1 Is this what you are looking for? https://docs.ninox.com/en/tutorial/basics/row-numbers-and-ids They call this the "always visible row number" not to be confused with the record id.…
- John_Halls
- 4 mths ago
- Get help
- Reported - view
Re: Please check this email script
Hi @Alan Cooke Sending the same email from another Ninox member worked. The email came into my inbox!
- John_Halls
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Please check this email script
Your variable CR should look like this let CR := " "; Regards John
- John_Halls
- 4 mths ago
- Get help
- Reported - view
Re: Please check this email script
Hi @Alan Cooke Have you checked your spam folder. On testing sending to myself mine are going into spam yet those sent to another email address of mine were received OK.
- John_Halls
- 4 mths ago
- Get help
- Reported - view
Re: Complex criteria for Select
@Chris Mullett We store the current record, this, to a variable because the current record is not available to reference within a select statement, but variables are.
- John_Halls
- 4 mths ago
- Get help
- Reported - view
Re: Complex criteria for Select
As you have some "Show All" options you may need to build your where clause as a text string and evaluate it, such as let x := text(Filter by Status); let y := text(Filter by Camera); let z :…
- John_Halls
- 4 mths ago
- 1
- Get help
- Reported - view
Re: Stopped working for me
Hi @Rafael There a few things here Why do you open the record, and then assign new values to it? I would do it the other way round Why do you open the record twice? Why do you have sleep(1000)?…
- John_Halls
- 4 mths ago
- Get help
- Reported - view

1 2 3 4 5 31

Back to top

Ninox-Documentation

Overview

View all topics