John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Join without empty lines
@Sébastien Guillet Use this at the end of your code let a := [RappelImportant, ActiviteAconfirmer, ContratAsigner, CarteCadeauAenvoyer, CarteParrainAenvoyer, PHV]; join(a[!=""],…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Override result in formula field
Hi Davie Rather than using a formula field use a number field and a script in a trigger to populate it. You will be able to amend the field as you wish afterwards.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Print filtered by date and assigned employee records from the table
@Alina Morgovsky Did you get your view to print out correctly? My understanding is that views don't print well and it's better to link the records you need to a parent and print using that…
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Calculating hours from Appointment
@Davie I would use the Switch - Case structure, as shown here https://forum.ninox.com/t/q6hdmzw/switch-case-statement-in-ninox Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: How to pop up a dialog if a record in a table meets a criteria.
Try this let z := (select 'Reminders' where 'Next Date' = today()); if cnt(z) > 0 then let i := join(z.Reminder, " "); let result := dialog("A reminder is due today.…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: storing system variables
Hi Louis Yes please! Always interested to see what other developers have come up with. Regards John
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
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

1 11 12 13 14 15 34

Welcome to the Ninox community

John Halls

My Posts

Re: Join without empty lines

Re: Override result in formula field

Re: Print filtered by date and assigned employee records from the table

Re: Calculating hours from Appointment

Re: How to pop up a dialog if a record in a table meets a criteria.

Re: storing system variables

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

Overview