Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

559
64
1

Joined: 11 Feb 2021

My Posts

Latest Posts

Re: Ninox script to work with csv files
@Andrew Dickey Hi Andrew. I learned so much from your post here. I had to look a few things up especially shareFile and unshareFile which I hadn't heard of before.…
- John_Halls
- 1 hr ago
- Learn & Share
- Reported - view
Re: Click on button in Ninox to view Gmails
@Mel Charles No idea Mel, I don't use Outlook Live. To be honest I looked at Bruce's post thinking it would not be possible just with a URL, but it works surprisingly well.
- John_Halls
- 2 days ago
- Get help
- Reported - view
Re: Print to File with Invoice Number
Hi If your print layout is called Invoices, try this importFile(this, printAndSaveRecord(this, "Invoices"), "Invoice " + invoiceNumber + ".pdf") It will save a copy of your invoice to the attachments.…
- John_Halls
- 2 days ago
- Get help
- Reported - view
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
- 2 days 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
- 5 days 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
- 6 days 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
- 13 days 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
- 2 wk 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
- 2 wk 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
- 3 wk ago
- Get help
- Reported - view
Re: import an Image from WEB
@Rafael Made in Japan. Great taste Rafael.
- John_Halls
- 3 wk 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
- 4 wk 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 mth 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 mth 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 mth 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 mth ago
- 4replies
- 78
- Learn & Share
Re: Close all windows except the active one
@RoSoft_Steven I REALLY like this. Neat!
- John_Halls
- 1 mth 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 mth 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 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 mths ago
- 1
- Get help
- Reported - view

1 2 3 4 5 23

Back to top

Ninox-Documentation

Overview

View all topics