John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Delete a record and related records in other tables
This is a feature of Ninox and is achieved by setting Composition to Yes on the link to other tables. Deleting a parent will then also delete any children,…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Is it possible to copy/separate tables?
Hi Allstar Fred is right here. Also, you can create user roles and then scope what records that user is allowed to see, and give them editing rights or not.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Trigger after open problem
@Fred Thanks Fred. Yes it does if it directly replaces the existing value like this let a := select Test; a.Text := "s" but produces odd results when interacting with the existing value.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Trigger after open problem
Fred Hi Fred. I didn't think you could assign a value via a select statement without looping through the elements, or using first, last. It does work but it can generate some odd results.…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Database History
Hi Daniel I wouldn't be deleting my records. I have an archive flag that I set for archived records which I can filter out to show only current records.…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Server Not Responding Rant
@Fred Sorry to hear that Fred.
- John_Halls
- 1 yr ago
- Learn and share
- Reported - view
Re: Automatic adaptation of views
Hi Didier I am fairly certain there is a 6 line limit. With this in mind I developed a way of seeing the child records in a list view here https://forum.ninox.…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Issue with the 'select ... where...' function
You don't need 'Equipe impliquee' twice. Just have let directeurices := count(select 'Equipe impliquee' where 'Type de fonction' = 1) Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Matching Phone Area Codes to Region
Using a Select statement in a formula field can be problematic. It needs a reason to trigger and so won't be updated in your existing records.
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: count lines of text
Try this let a := YourTextField; let b := " "; let c := split(a,b); count(c) It is putting each line of text into an array (ignoring empty lines) which you can then count. Regards John
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Load (Transfer) Data
Hi Rafael Can you post screen shots of the field structure of the two tables. I want to see what the relationship is between the two. Thanks John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Load (Transfer) Data
Hi Rafael You are doing everything right, but you are not creating the link, Try something like this do as server let xPry := first(select 'Control Issues'); let xFld0 := xPry.Date; let xFld1 := xPry.…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Combining a global variable boolean field with a trigger on table-level
Hi Ruben I've been playing around with this and it looks like Global Fields work as expected in formula fields, and in Buttons, but not in Triggers, which seems like a bug to me.…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: maximum user roles
Hi Robbie I built something a year or so ago, just for interest, which had customers and suppliers, with sales orders and purchase orders, but the perspective changed depending on who was the…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Combining a global variable boolean field with a trigger on table-level
Hi Ruben Your Global Field needs to be set at the start of your session, otherwise it will be blank. Either do this via a script or set the default value to Yes or No as required. Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: formula greater and less
Don't for get to make one them equal to 2000, 4000 or 7000. An exact match of these values won't evaluate to anything.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Formula fields show no data in table view
I see that the second line of your code says if sum(Prestaties.Laden) >= 0.25 and sum(Prestaties.Lossen) >= 0.25 then and I wonder if it should say if 'Laden werf 1' >= 0.25 and 'Lossen werf 1' >= 0.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Make graph based on specific records
Hi You could add a Yes/No field to your table to indicate if this is to be included in your graph. It could be just a field that you set at the time of taking the reading,…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Formula fields show no data in table view
Hi Can you share with us the formula that you are using? Does it include a select command by any chance, as these don't update automatically? Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Hide Multiple fields at once
@Kent Signorini Hi Kent When you go to 'Edit fields' the tabs are listed along with the fields. Click on the one you want to hide, then under 'More options' is where you will find 'Display fields…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: How to show all fields at once?
@Jack said: However, our business operations and use of databases are not typical. I am intrigued. Can you tell me more?
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: How to show all fields at once?
Hi Jack I'm with Fred on this and nearly wrote as such as soon as you posted. You can't expect to be able to take in all 100 fields at a time. I wonder, with 100 fields,…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Count number of fields containing zero
Hi Chris Whenever you have fields like this, it's a sign that the set-up is incorrect. Your multiple fields should be records in a sub-table. Once re-configured tasks like the one you are asking for…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Summary table of multiple tables
Hi Jack I would look at your sub-tables and consider if they can all be put into one sub-table. It sounds like they can from your description. Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: automatic numbering using any number column.
Hi Chris Is this a number or a text field? Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view

1 10 11 12 13 14 33

Welcome to the Ninox community

John Halls

My Posts

Re: Delete a record and related records in other tables

Re: Is it possible to copy/separate tables?

Re: Trigger after open problem

Re: Trigger after open problem

Re: Database History

Re: Server Not Responding Rant

Re: Automatic adaptation of views

Re: Issue with the 'select ... where...' function

Re: Matching Phone Area Codes to Region

Re: count lines of text

Re: Load (Transfer) Data

Re: Load (Transfer) Data

Re: Combining a global variable boolean field with a trigger on table-level

Re: maximum user roles

Re: Combining a global variable boolean field with a trigger on table-level

Re: formula greater and less

Re: Formula fields show no data in table view

Re: Make graph based on specific records

Re: Formula fields show no data in table view

Re: Hide Multiple fields at once

Re: How to show all fields at once?

Re: How to show all fields at once?

Re: Count number of fields containing zero

Re: Summary table of multiple tables

Re: automatic numbering using any number column.

Overview