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: 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 mths ago
- Get help
- Reported - view
Re: set values in a child
@Alain Fontaine I do believe.
- John_Halls
- 2 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
- 2 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
- 2 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
- 3 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
- 3 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
- 3 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
- 3 mths ago
- Get help
- Reported - view
Re: View from another database
@Fred More's the pity...
- John_Halls
- 3 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
- 3 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
- 3 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
- 3 mths ago
- Get help
- Reported - view
Re: Trigger After Update does not get Triggered
@Vermaji You can include the trigger code within the code the sets ‘Contact Person’ to null. Pretty much just a copy & paste job.
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: Trigger After Update does not get Triggered
@Fred Setting a DCF field to null, using a button, triggered OK for me.
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
@Vermaji Reference field every time. Use select statements as sparingly as you can, although any decent sized system will end up having some. Regards John
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
@Vermaji I have a feeling you already have this, and if you have keep this going. Also to update the out-of-sync DCF use code like for a in (select Table) do a.DCF := a.…
- John_Halls
- 3 mths ago
- Get help
- Reported - view

1 2 3 4 5 31

Back to top

Ninox-Documentation

Overview

View all topics