John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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 6 mths ago
- 42
- 3
- Learn and share
Re: Merry Christmas
thanks @Rafael A Merry Christmas to you too.
- John_Halls
- 6 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
- 6 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 mths ago
- 59
- 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
- 7 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
- 7 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
- 7 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
- 7 mths ago
- Learn and share
- Reported - view
Re: Example DB - dynamic choice with JSON
+1 A really clear example of how to use JSON. Thank you
- John_Halls
- 7 mths ago
- Learn and share
- Reported - view
Re: userFirstName() possible bug?
You could create your own global functions function userForename() do let a := split(userName(), " "); first(a) end; function userSurname() do let a := split(userName(), " "); last(a) end Regards John
- John_Halls
- 8 mths ago
- Get help
- Reported - view
Re: Page behaviour
Hi Fred. It's to do with the Binding setting, which makes sense. a :=this will get the record OK but in the select statement a.Scan won't know who's Scan value to take.…
- John_Halls
- 8 mths ago
- Get help
- Reported - view
Re: Page behaviour
Thanks for looking Fred. It’s not a problem. I was just intrigued. I might have a delve sometime.
- John_Halls
- 8 mths ago
- Get help
- Reported - view
Page behaviour

Hi All I have a page (as opposed to a table) where I can scan or type in a reference in a field and find the record I am looking for. The field is called Scan and it is set a to be a Global variable…
- John_Halls
- 8 mths ago
- 3replies
- 45
- Get help
- Answered
- Answered

1 2 3 4 5 33

Welcome to the Ninox community

John Halls

My Posts

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

Re: Example DB - dynamic choice with JSON

Re: userFirstName() possible bug?

Re: Page behaviour

Re: Page behaviour

Page behaviour

Overview