Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
John Halls
John_Halls
Somerset, England
597
69
1
Joined: Thu Feb 11 10:04:26 UTC 2021
Follow
My Posts
Latest Posts
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
John_Halls
9 mths ago
Get help
Reported - view
Re: Server Not Responding Rant
@Fred Sorry to hear that Fred.
John Halls
John_Halls
9 mths ago
Learn & 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
John_Halls
10 mths 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
John_Halls
10 mths 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
John_Halls
10 mths 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
John_Halls
10 mths 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
John_Halls
11 mths 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
John_Halls
11 mths 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
John_Halls
11 mths 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
John_Halls
11 mths 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
John_Halls
1 yr 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
John_Halls
1 yr 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
John_Halls
1 yr 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
John_Halls
1 yr 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
John_Halls
1 yr 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
John_Halls
1 yr 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
John_Halls
1 yr 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
John_Halls
1 yr 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
John_Halls
1 yr 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
John_Halls
1 yr 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
John_Halls
1 yr ago
Get help
Reported - view
Re: Choice field: There can be only one!
Where you have a 1:n relationship for all the sub-table entries, I would have a second relationship but the other way round n:1, just for the active record.…
John Halls
John_Halls
1 yr ago
Get help
Reported - view
Re: Sub-Tables - Add existing record
Hi Paul I had a feeling that 'Add existing record' didn't show if composition is set to Yes, because in theory there shouldn't be any orphan child records to add.…
John Halls
John_Halls
1 yr ago
Get help
Reported - view
Re: Update Reference field from Text Field
According to your data model screenshot, Customer should be Customers let t := this; Customer := first(select Customers['Company Name' = t.'Serviced Customer']) Regards John
John Halls
John_Halls
1 yr ago
1
Get help
Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
@Jacques TUR You have surpassed yourself here. Massive congratulations on this.
John Halls
John_Halls
1 yr ago
Learn & Share
Reported - view
1
2
3
4
5
24
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics