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: Merry Christmas
thanks @Rafael A Merry Christmas to you too.
- John_Halls
- 3 days 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
- 5 days 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 days 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
- 13 days 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
- 2 wk 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
- 2 wk 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
- 2 wk 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
- 2 wk 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
- 3 wk 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
- 3 wk ago
- 34
- 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
- 3 wk 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
- 3 wk 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
- 3 wk 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- 3replies
- 33
- Get help
- Answered
- Answered
Re: Sort concatenated values in table view not working
Any attempt to order by in the formula of the view is ignored. The sort is determined by the setting of the columns in the view. You will need to show the Order and set this column. Regards John
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Using Ninox ChatGPT to create a search
Not a problem @Alan Cooke It might be tricky to catch every use-case but try this NOTES := replace(raw(NOTES), SEARCH, "<mark>" + SEARCH + "</mark>") NOTES := replace(raw(NOTES), lower(SEARCH),…
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: Create new record in another table and transfer all fields across
Hi @Suzie Konszky You are nearly there. I'd save the 'SIGN IN' table to a variable first and then use that in the subsequent transfers let signIn := this; let newRecord := (create 'TRANSFER LOG');…
- John_Halls
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Search for words (not sequencial) in a string
Hi @Carlos Martinho This bit of code searches the multiple words b in the text a and returns yes or no if all the words in b are in a. Bear in mind it is case sensitive.…
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: Trigger on create with numeric fields
@Mario Cuzzi How you proceed depends on your reason for copying the data. Should the record in 'Flujo de Caja' always have the same data as Facturado, any changes in one updates the other.…
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: Trigger on create with numeric fields
Hi @Mario Cuzzi Can I suggest that original code let a := Fecha; let b := Cliente; let c := 'Linea'; let d := Monto; let p := (create 'Flujo de Caja'); p.('Fencha Flujo' := a); p.…
- John_Halls
- 2 mths ago
- 2
- Get help
- Reported - view

1 2 3 4 5 31

Back to top

Ninox-Documentation

Overview

View all topics