John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Avoid spaces in a sum function when a variable is empty/void
A better solution is let a := [article,Color,more stuff,kg,lt]; let b:= a[let c := this; length(c) > 1]; let d := join(b," ") Regards John
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Avoid spaces in a sum function when a variable is empty/void
Hi Lorenzo If you create an array of the field values you can then use concat to create a string, and replace to remove the commas. let a := [article,Color,more stuff,kg,lt]; let b := concat(a);…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: scheduled task
I made this a while ago, which has worked well for me https://forum.ninox.com/t/x2hbzyb/timed-scripts Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Rant: More Server Issues
@Fred Any joy?
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Comments???
@gvibex You are quite right. In a formula you can't have the comment as the last line as this is the line that will be returned as the result. It should work fine in a button or trigger though.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Comments???
@gvibex Don't forget to put a semi-colon at the end of line 1, then it will work.
- John_Halls
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: Server Not Responding Rant
@Fred Sorry to hear that Fred.
- John_Halls
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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

1 10 11 12 13 14 33

Welcome to the Ninox community

John Halls

My Posts

Re: Avoid spaces in a sum function when a variable is empty/void

Re: Avoid spaces in a sum function when a variable is empty/void

Re: scheduled task

Re: Rant: More Server Issues

Re: Comments???

Re: Comments???

Re: Switch Case Statement: combine multiple cases with same code

Re: Switch Case Statement: combine multiple cases with same code

Re: Switch Case Statement: combine multiple cases with same code

Re: Switch Case Statement: combine multiple cases with same code

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

Overview