John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Webinar on Automated CSV Import & Export in Ninox on Thursday, 16 January - Open Q&A
@Terri 1 Thanks Terri
- John_Halls
- 9 mths ago
- 1
- Learn and share
- Reported - view
Re: Looking to automate record creation based on a date
There's this discussion about timed scripts which might work for you. I've not come across issues with infinite loops before.
- John_Halls
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Looking to automate record creation based on a date
Are you looking to automate this regardless of whether you are logged in or not, run it once on start-up, or at the push of a button? All are available options. Regards John
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: Webinar on Automated CSV Import & Export in Ninox on Thursday, 16 January - Open Q&A
The text says Thursday 9th January. Should this be 16th? Is the time the same? Unfortunately I would struggle to attend at 5pm GMT and wonder, are the webinars available to view afterwards?…
- John_Halls
- 9 mths ago
- Learn and share
- Reported - view
Re: Optimizing Ninox Workflow: Opening Database via URL with Parameters and QR Code Integration
I had a quick look at the URLs used by my databases and I think it's easy to parse Each has the following elements concatenated together Ninox app: app.ninox.…
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: Import not seeing all data
Hi Fred Worked for me, so not sure what was going on. Odd to see an Id of 44 in there for KPF with yours. Regards John
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: How do you display information from a record on a website?
This sounds like a candidate for a productized service. Beyond my abilities but maybe there is someone who could create this.
- John_Halls
- 10 mths ago
- 1
- Get help
- Reported - view
Re: Create a zip file of all invoices generated with printRecord()
@Sébastien Guillet Did you see in the documentation that this function has to be run server side?
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Challenges with Optimizing Multi-User Data Entry in Ninox
Form what you have said @segidas579 said: lag while filling out forms It sounds like it's not so much an issue about multi-user but a deeper issue. Are you using a lot of triggers and/or select…
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Date of the first day of the current week
This is the same as 'Start' := today() - weekday(today()); 'End' := today() - weekday(today()) + 6; Regards John
- John_Halls
- 10 mths ago
- 2
- Get help
- Reported - view
first(select Table...) vs create Table data types

A question earlier this week got me thinking about this structure let a := first(select table where field = value) if a != null then a.field1 := value1; a.…
- John_Halls
- updated 10 mths ago
- 49
- 3
- Learn and share
Re: Merry Christmas
thanks @Rafael A Merry Christmas to you too.
- John_Halls
- 10 mths ago
- Learn and share
- Reported - view
Re: JSON in dynamic fields
Hi @Fred I think the problem with let originalFruit := split(originalChoices, ", "); is that it gives the ability to have different dmc values for different records in the same table,…
- John_Halls
- 10 mths ago
- 1
- Learn and share
- Reported - view
Re: Calcul date
Hi @PHILIPPE CORBO Your code worked but occasionally gives the wrong date. This is because of this line if weekday(current) >= 1 and weekday(current) <= 5 then Which should be if weekday(current) <=…
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Calcul date
Hi @PHILIPPE CORBO would you mind if I looked at the code you have put together? There are a few techniques that we can show you that will help you when you need to write another script. Regards John
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: real time link between local DB and Cloud DB
@Leo Woer Not sure, it is checked by default. Maybe someone else can shed some light...
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: real time link between local DB and Cloud DB
Hi Leo When it comes to designing the barcode scanning have a look at the binding options for a field The field used to capture the scan should be a text field the uses Global variable in memory.…
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Select top 10 records from view
@david After the initial setup, just once, everything is on the fly. My model has a page with a relationship to the main table to hold the Top n records.…
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Select top 10 records from view
I have created a database with a table of values, plus a page called Top n. The initialise button sets a relationship for the Top n values. This only needs to be one once.…
Attachment
- John_Halls
- 10 mths ago
- 4
- Get help
- Reported - view
Re: Relations between records in the same table
@Medgyesy András I think you have a valid case for a one to one relationship here. I have written a reply here. Regards John
- John_Halls
- 11 mths ago
- Get help
- Reported - view
One to One Relationships

There was a question yesterday about creating a one to one relationship. It got me thinking about this. I think there are situations when having a one to one relationship is the correct solution,…
- John_Halls
- 11 mths ago
- 66
- 2
- Learn and share
Re: Change the color of Number text(field) depending from the value
I've been thinking bout abstracting this situation and have come up with let a := ["red", "orange", "green", "blue"]; let b := [0, 5, 10]; let j := 0; for i in b do j := j + number(Number > i) end;…
- John_Halls
- 11 mths ago
- Get help
- Reported - view
Re: Logging in to forum
@Jesper Ordrup Sorry to hear that. I have a number of apps, plus the forum running alongside each other, no problem. I can't think it is is a Ninox or forum problem. Regards John
- John_Halls
- 11 mths ago
- Learn and share
- Reported - view
Re: Display of columns in table 1:N
Hi @iliper LTD Go to the parent side of the relationship and edit the field. You can set what is shown via the Edit Columns button Regards John
- John_Halls
- 11 mths ago
- 1
- Get help
- Reported - view
Re: Example DB - dynamic choice with JSON
Just having a play. You can mix static data with dynamic data let a := [{ id: 1, caption: "Everyone" }]; let i := 1; let b := for c in select DynValues do i := i + 1; { id: i, caption: c.…
- John_Halls
- 11 mths ago
- Learn and share
- Reported - view

1 2 3 4 5 34

Welcome to the Ninox community

John Halls

My Posts

Re: Webinar on Automated CSV Import & Export in Ninox on Thursday, 16 January - Open Q&A

Re: Looking to automate record creation based on a date

Re: Looking to automate record creation based on a date

Re: Webinar on Automated CSV Import & Export in Ninox on Thursday, 16 January - Open Q&A

Re: Optimizing Ninox Workflow: Opening Database via URL with Parameters and QR Code Integration

Re: Import not seeing all data

Re: How do you display information from a record on a website?

Re: Create a zip file of all invoices generated with printRecord()

Re: Challenges with Optimizing Multi-User Data Entry in Ninox

Re: Date of the first day of the current week

Re: Merry Christmas

Re: JSON in dynamic fields

Re: Calcul date

Re: Calcul date

Re: real time link between local DB and Cloud DB

Re: real time link between local DB and Cloud DB

Re: Select top 10 records from view

Re: Select top 10 records from view

Re: Relations between records in the same table

Re: Change the color of Number text(field) depending from the value

Re: Logging in to forum

Re: Display of columns in table 1:N

Re: Example DB - dynamic choice with JSON

Overview