John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

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
- 8 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
- 8 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
- 8 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 9 mths ago
- Get help
- Reported - view
Re: set values in a child
@Alain Fontaine I do believe.
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: set values in a child
If the child table is called Child then in the Trigger after update of the open / closed field put this code if 'open / closed' = 2 then for a in Child do a.Choice := 1 end end
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: Trigger after update not triggered when updating by copy&paste
Hi @dennis Works as expected for me. Don't forget you have to move the focus away from the field for the trigger to take effect. Can you share your trigger?
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: Ninox APP update problem
@Nick I didn't get to FileMaker until version 8.5 Prior to that it was DBase II, FoxPro and Visual FoxPro.
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: how can I make the options in HOME not include the items that have already been selected..
@Mel Charles I knew there was one out there, spent half an hour looking for it and got nowhere. I was so pleased when @Alain Fontaine came to the rescue.
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: how can I make the options in HOME not include the items that have already been selected..
@Alain Fontaine Neat solution Alain!
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: Best practice to duplicate a record
@Vermaji From what I understand all the variables are scoped so that those declared within the do as server will only be available there, and those outside the do as server similarly.…
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: View from another database
@Fred More's the pity...
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: Using the Filter option
@Alan Cooke Think of a column that you know you want to display, eg Install Date. Add a formula field to the view (not the table) and put if SERIALIZE then 'INSTALL DATE' end And then set the filter…
- John_Halls
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Trigger After Update does not get Triggered
@Fred They may not be triggered by a trigger as this may result in an infinite loop, with field a updating field b, which in turn updates field a, etc. I tested it with a button.
- John_Halls
- 10 mths ago
- Get help
- Reported - view
Re: Trigger After Update does not get Triggered
@Vermaji No, DCF fields do get executed, I tried it out. There may be something esle not quite right
- John_Halls
- 10 mths ago
- Get help
- Reported - view

1 2 3 4 5 33

Welcome to the Ninox community

John Halls

My Posts

Re: Create new record in another table and transfer all fields across

Re: Search for words (not sequencial) in a string

Re: Trigger on create with numeric fields

Re: Trigger on create with numeric fields

Re: Trigger on create with numeric fields

Re: Using Ninox ChatGPT to create a search

Re: adding eg 7 days to a date+time field

Re: Using Ninox ChatGPT to create a search

Re: adding eg 7 days to a date+time field

Re: Using Ninox ChatGPT to create a search

Re: Using Ninox ChatGPT to create a search

Re: Using Ninox ChatGPT to create a search

Re: Delete view tabs

Re: set values in a child

Re: set values in a child

Re: set values in a child

Re: Trigger after update not triggered when updating by copy&paste

Re: Ninox APP update problem

Re: how can I make the options in HOME not include the items that have already been selected..

Re: how can I make the options in HOME not include the items that have already been selected..

Re: Best practice to duplicate a record

Re: View from another database

Re: Using the Filter option

Re: Trigger After Update does not get Triggered

Re: Trigger After Update does not get Triggered

Overview