Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

603
72
1

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

My Posts

Latest Posts

Re: NEWBIE - CONFIGURING ONE-TO-ONE AND AUTO UPDATING
@Randy There isn't a 1:1 relationship available to Ninox natively. Use a 1:many with the many side being the optional additional fields. You could write a script to prevent additional records from…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
@Taylor Hanson Hi Taylor. We were all there once and you are doing the best thing of all, having a go at building something. You will find a wealth of support here.…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: Conditional formula to calculate 'taxable' and 'non taxable' items...
Hi Taylor Reading your post and seeing red flags like 15 lines, and Type 2, I wonder if your setup is correct and that is why you are now struggling. Can you upload a copy of your database for us to…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: Need Script for calculating workdays between 1st record, 2nd record, so on.
@Dave Irving Hi Dave The above code will run in the Console so you can see what results you are getting. Try a simple let x := (select Leads); let y := for loop1 in x do item(loop1.…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: import an Image from WEB
@Rafael Made in Japan. Great taste Rafael.
- John_Halls
- 7 mths ago
- Learn & Share
- Reported - view
Re: Syntax for filtering Dates older than from today
@Dave Irving Hi Dave. The Chronos Fred mentions is the relationship field rather than the table. It will only show related records older than 5 working days. Regards John
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: Issue with Formula for Clearing Data in Ninox
Hi I'm not sure you need this bit of code at all // Clear data from 'FILL/CREDIT' table for record in c.'FILL/CREDIT' do deleteRecord(record); end Duplicating a record does not duplicate the related…
- John_Halls
- 7 mths ago
- 1
- Get help
- Reported - view
Re: Double Search
Hi Rafael Try changing Line 7 to this myArray := myArray[contains(Format,me.Search_2)] Regards John
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: Extract Record from a Table meeting some criteria
We like a one liner, this might work last((select Album) order by count(Release)).Album Regards John
- John_Halls
- 8 mths ago
- 1
- Get help
- Reported - view
do as... massive speed improvement

Hi All Has anyone seen the documentation about speed improvements in Ninox? https://docs.ninox.com/en/use-cases/tips-and-tricks-for-fast-databases I tested their use of do as...…
- John_Halls
- 8 mths ago
- 4replies
- 115
- 1
- Learn & Share
Re: Close all windows except the active one
@RoSoft_Steven I REALLY like this. Neat!
- John_Halls
- 8 mths ago
- Get help
- Reported - view
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
- 8 mths 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
- 8 mths 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
- 8 mths ago
- Learn & 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
- 8 mths 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
- 8 mths 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
- 8 mths ago
- Learn & 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
- 9 mths 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
- 9 mths 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
- 9 mths ago
- Get help
- Reported - view
Re: Rant: More Server Issues
@Fred Any joy?
- John_Halls
- 9 mths ago
- Learn & 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
- 9 mths 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
- 9 mths 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
- 9 mths 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
- 9 mths ago
- Get help
- Reported - view

1 2 3 4 5 25

Back to top

Ninox-Documentation

Overview

View all topics