John Halls's Profile | Ninox community

Badges

Latest Posts

Re: Photo field is corrupted and can not be erased
Hi @joz1 Welcome! We are a friendly bunch of developers here who have all been where you are now. I too come from a FileMaker background, and now happily flit from one platform to the other.…
- John_Halls
- 4 days ago
- Get help
- Reported - view
Re: Recently started using Ninox 4
@Fred I know, it's a shame. I liked having a problem to solve.
- John_Halls
- 5 days ago
- 1
- Learn and share
- Reported - view
Re: Recently started using Ninox 4
I fear I am going to be left behind if the only Ninox 4 forum is on Discord. I had a quick look at Discord the start of the Beta release and thought 'this isn't for me'.…
- John_Halls
- 6 days ago
- 1
- Learn and share
- Reported - view
Re: Table Relationship?
So you don't have to download the file to see the code, the constrain code is not contains(a.Nearby.Restaurants, b) and the code to add the selected resaurant is let a := this; let b := Restaurants;…
- John_Halls
- 2 wk ago
- Get help
- Reported - view
Re: Table Relationship?
I have added a file that uses a bit of code. I added an extra relationship of Restaurants directly to campsites, and a button that adds this to the nearby table.…
Attachment
- John_Halls
- 2 wk ago
- Get help
- Reported - view
Re: Table Relationship?
@Mr. K. This is because, even though the Restaurant does exist, you need to create a new Restaurants Nearby record, so click the + Create Record button and then add the Restaurant to it.
- John_Halls
- 2 wk ago
- Get help
- Reported - view
Re: Table Relationship?
Hi @Mr. K. This is a many to many relationship. If you ask, can a campsite have more than one restaurant nearby and can a restaurant be close to more than one campsite and the answer is yes to both…
- John_Halls
- 2 wk ago
- Get help
- Reported - view
Re: Recently started using Ninox 4
They look very professional @Rafael well done.
- John_Halls
- 2 wk ago
- Learn and share
- Reported - view
Re: `delete select …` blocks the app
I would try the select on its own, and see if that hangs. How many records does it return? Also try a delete select on a small test table, and maybe split the command into two lines and delete a few…
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: How long will Ninox 3 remain?
@Fred Yes, I was attracted to Ninox for its high record limit (millions) and the ability to write a script that can loop through records. These two features are sadly lacking in all the other online…
- John_Halls
- 2 mths ago
- 3
- Get help
- Reported - view
Re: How long will Ninox 3 remain?
@Mel Charles @John Schaffer Exactly what I had to do, move away from coding to bring in a 3rd party application. I had my whole business running on FileMaker,…
- John_Halls
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Number of records
There isn't a way to filter directly but you can use Readable if. You will need a new table (page) to hold a field to turn the filter on and off and then in Readable if put code like this let a :…
- John_Halls
- 2 mths ago
- Learn and share
- Reported - view
Re: How long will Ninox 3 remain?
@Mel Charles And cost Mel. We have an ERP system and it costs us a disproportionate amount of money to run each year. I could run my business on Ninox, or FileMaker (it did for a while) but then I'd…
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: How long will Ninox 3 remain?
@Fred Good thing too, in my opinion. It has become developer orientated, with the idea that, most of the time developers are going to be working on their latest project. Not so.…
- John_Halls
- 4 mths ago
- Get help
- Reported - view
Re: How long will Ninox 3 remain?
@Rafael Thanks
- John_Halls
- 4 mths ago
- Get help
- Reported - view
How long will Ninox 3 remain?

I have an idea for a vertical application I would like to put together. I would far rather build this in Ninox 3 (I am finding the interface of Ninox 4 far too cluttered and it's still far from…
- John_Halls
- 4 mths ago
- 41replies
- 592
- Get help
Re: Return of ID Number
I can't see why? I can create a formula with let me := this; number(me.Id) without errors, but if you are staying on the current record all you need is Id Regards John
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Status script not working
@Fred Just did a small test. Initially cnt(JobLines.Dispatched) will return 0. As they are checked it increments up, but regardless of its state, as it has gone from null to True or False and null…
- John_Halls
- 6 mths ago
- Get help
- Reported - view
Re: Status script not working
Hi Mel The two are going to be equal. You need square brackets in the JobLines count, eg if cnt(JobLines[Dispatched]) = LineCount then "Order Completed" else if cnt(JobLines[Dispatched]) < LineCount…
- John_Halls
- 6 mths ago
- Get help
- Reported - view
Re: Problem Ninox
Pretty sure it's linked to Ninox 4. If you had a beta invite you now have to reset your password in Ninox 3, which unifies the login details for Ninox 3, and Ninox 4.…
- John_Halls
- 6 mths ago
- Get help
- Reported - view
Re: Parent and Child reUnion
@Fred I doubt it's a feature as such, so use with caution.
- John_Halls
- 6 mths ago
- Get help
- Reported - view
Re: Parent and Child reUnion
@Fred Not so. Have a look at this example. Two different tables with the same structure. The View code is let a := (select A); let b := (select B); let c := array(a, b);…
Attachment
- John_Halls
- 6 mths ago
- 2
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
Hi @Mel Charles @Fred this is just what I was alluding to with my post a couple of days ago. Took me ages to get the syntax right for shareFile and then use the result in importFile.…
- John_Halls
- 6 mths ago
- Get help
- Reported - view
Re: Emailing a set of child attachments
@Mel Charles Glad it was useful Mel.
- John_Halls
- 6 mths ago
- Learn and share
- Reported - view
Emailing a set of child attachments

I thought I'd post the code that I came up with, as I struggled to get all the syntax correct and couldn't find a decent example of how to go about it. I have a quality system and I wanted to send an…
- John_Halls
- 6 mths ago
- 2replies
- 55
- 1
- Learn and share

1 2 3 4 5 37

Welcome to the Ninox community

John Halls

Re: Photo field is corrupted and can not be erased

Re: Recently started using Ninox 4

Re: Recently started using Ninox 4

Re: Table Relationship?

Re: Table Relationship?

Re: Table Relationship?

Re: Table Relationship?

Re: Recently started using Ninox 4

Re: `delete select …` blocks the app

Re: How long will Ninox 3 remain?

Re: How long will Ninox 3 remain?

Re: Number of records

Re: How long will Ninox 3 remain?

Re: How long will Ninox 3 remain?

Re: How long will Ninox 3 remain?

How long will Ninox 3 remain?

Re: Return of ID Number

Re: Status script not working

Re: Status script not working

Re: Problem Ninox

Re: Parent and Child reUnion

Re: Parent and Child reUnion

Re: copy table record with child records to another table record also with child records

Re: Emailing a set of child attachments

Overview