John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Using Ninox ChatGPT to create a search
@Sotirios Zormpas Good spot, my test field was indeed of Field type HTML
- John_Halls
- 5 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
- 5 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
- 5 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
- 5 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
- 6 mths ago
- Get help
- Reported - view
Re: set values in a child
@Alain Fontaine I do believe.
- John_Halls
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 mths ago
- Get help
- Reported - view
Re: View from another database
@Fred More's the pity...
- John_Halls
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 6 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
- 7 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
- 7 mths ago
- Get help
- Reported - view
Re: Resolving a bill of materials
There are a few posts cropping up re BOMs. I still use FileMaker for this and, with no levels or recursion, it works like a dream. Let me see if I can re-create it in Ninox sometime soon Ninox does…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: Table or Sub-Table?
@Fred Hi Fred. I'd have a single table for Articles and Materials, otherwise you are going to end up with a third for WIP, with a simple BOM between the item being made and the items being used.…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
Just realised, you could swap it all round and have let allProductItems := (select 'Products Items'); for i in allProductItems do i.('Product Code' := Products.…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
Hi Your DCF used product.'Product Items' so why aren't you using that in your code? let allProducts := (select Products); for i in allProducts do let allProductItems := i.…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: The slowness of the servers is intolerable.
Yup, affecting me this time!
- John_Halls
- 7 mths ago
- Get help
- Reported - view

1 2 3 4 5 33

Welcome to the Ninox community

John Halls

My Posts

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

Re: Trigger After Update does not get Triggered

Re: Trigger After Update does not get Triggered

Re: Selecting Product Items based on Product

Re: Selecting Product Items based on Product

Re: Resolving a bill of materials

Re: Table or Sub-Table?

Re: Selecting Product Items based on Product

Re: Selecting Product Items based on Product

Re: The slowness of the servers is intolerable.

Overview