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: Click on button in Ninox to view Gmails
In your button put this let searchString := "https://mail.google.com/mail/u/0/#search/"; let email := replace(Email, "@", "%40"); openURL(searchString + email) Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Help me LOOP please.
It's a tell tail sign that when you have fields called 'Risk List1','Risk List2', 'Risk List3' that you are using fields rather than records. Once you have your database normalised (split up into…
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: double click in a cell puzzle.
Hi Alan. I have noticed that double-clicking cells on the left-hand side gives you more time than those on the right (because the form slides out from the right).…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: import an Image from WEB
@Rafael Made in Japan. Great taste Rafael.
- John_Halls
- 1 yr ago
- Learn and 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- 4replies
- 154
- 1
- Learn and share
Re: Close all windows except the active one
@RoSoft_Steven I REALLY like this. Neat!
- John_Halls
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Rant: More Server Issues
@Fred Any joy?
- John_Halls
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view

1 7 8 9 10 11 31

Back to top

Ninox-Documentation

Overview

View all topics