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: Comments???
@gvibex Don't forget to put a semi-colon at the end of line 1, then it will work.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Switch Case Statement: combine multiple cases with same code
@bflack I don't think it was developed with this in mind, it's just those clever chaps on the forum that are able to leverage additional functionality (you know who you are!).
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Switch Case Statement: combine multiple cases with same code
@Kruna No need to look at the rest of that thread, just the use of switch true do. My code above will give you what you want. You will also have to use Source = 2 etc for the other case statements.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Switch Case Statement: combine multiple cases with same code
@Kruna Following this thread, the conversation in the next link between Fred and Jacques means you can use the switch true structure thus switch true do case Source = 1 or Source = 4:…
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Switch Case Statement: combine multiple cases with same code
Hi bflack, I've not tried this so just off the top of my head could you put the code in a user-defined function and call that for the two cases. Also, maybe try swapping case 1 and case 4 for case 1…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 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
- 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
- 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
- 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
- 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
- 2 yrs ago
- Get help
- Reported - view

1 8 9 10 11 12 31

Back to top

Ninox-Documentation

Overview

View all topics