Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

746
116
1

Joined: 11 Feb 2021

My Posts

Latest Posts

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
- yesterday
- 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
- yesterday
- Learn & 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
- 2 days 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
- 10 days ago
- Learn & Share
- Reported - view
Re: Example DB - dynamic choice with JSON
+1 A really clear example of how to use JSON. Thank you
- John_Halls
- 10 days ago
- Learn & 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
- 3 wk 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
- 4 wk 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
- 4 wk 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
- 4 wk ago
- 3replies
- 32
- 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- 2
- Get help
- Reported - view
Re: Trigger on create with numeric fields
There are a couple of missing semi-colons in your code let c := Monto let d := Fecha regards John
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Using Ninox ChatGPT to create a search
@Alan Cooke There's some meaty discussions on counting occurrences of text in a string on the forum but this seems to work, finding the length of the field and then replacing the search text with ""…
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@Fred Hi Fred, worked for me. datetime(number, number, number) gives the date plus 00:00:00, and then I just added the time element to this.
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Using Ninox ChatGPT to create a search
@Alan Cooke Reset to no highlights works with my code below plus an empty search field NOTES := replace(raw(NOTES), "<mark>", ""); NOTES := replace(raw(NOTES), "</mark>", ""); NOTES :…
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: adding eg 7 days to a date+time field
@Kruna Try datetime(year('Date + Time'), month('Date + Time'), day('Date + Time') + 7) + time('Date + Time')
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Using Ninox ChatGPT to create a search
@Sotirios Zormpas Good spot, my test field was indeed of Field type HTML
- John_Halls
- 1 mth ago
- 1
- Get help
- Reported - view
Re: Using Ninox ChatGPT to create a search
In my small test of the above solution my text became more and more yellow as I performed successive searches. Can I suggest a way to undo any previous searches prior to a new search NOTES :…
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Using Ninox ChatGPT to create a search
Hi @Alan Cooke The error you are getting is to do with the fact that replace() does not work with rich text. You need to wrap the RTF field with raw(). Also, there is no need to assign any variables,…
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Delete view tabs
Hi Pascal. A belated welcome to the Forum. I still use FileMaker as well as Ninox. If you have any problems moving from one platform to the other please feel free to ask. Regards John
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: set values in a child
@Alain Fontaine Works with select commands too. I didn't know this. How did it pass me by?
- John_Halls
- 2 mths ago
- Get help
- Reported - view

1 2 3 4 5 30

Back to top

Ninox-Documentation

Overview

View all topics