John Halls's Profile | Ninox community

Badges

Latest Posts

Re: Please teach me how to use this global function :-)
Alan Cooke Hi Alan. It replaces the last three lines of your original code This end; html end Becomes this end; html(html) end Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Formula help
This line let x = first(select Master where 'Master Release Number' = xMasterID); should read let x := first(select Master where 'Master Release Number' = xMasterID); Hope that helps Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Print Dashboard
I think your question has been answered but I said I would post something, so in addition to the above... Create an additional relationship for each of the tables you wish to print.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Print Dashboard
Hi - Unfortunately views don't print, but relationships do so you could set up a button that links the contents of each view to the parent. Let me know if you need help doing this. Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Thoughts on a DB redesign
@Mel Charles Spaghetti Junction and the Aston Expressway, I remember it well!
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Thoughts on a DB redesign
@Fred I come from a FileMaker background. The look of the relationship diagram there is totally in the developer's hands but even so, I have seen far, far worse than any of the above examples.…
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Sum service amounts from three tables based on dates
Hi Shawna Have a look at your three tables, services, products and off-site events, and see if they should be amalgamated into one table with an extra field to indicate what type they are.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Trigger on open database
Hi Mel I have a couple of scripts that don't like 'do as server'. No idea why not. So have you tried taking this out, or would it all take too long? Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Create Record Button in a Table > Create R. to a Subtable
@Fred It's an odd quirk that arrays start at 0 so the i has to go from 0 to c-1 and then item(n, 0) will find the first item in the array Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Problem with this formula
@Daniel Berrow text() will give the text value of the choice field so it should be sum((select Expenses where Categories = 8).'Amount Spent') or sum((select Expenses where text(Categories) = "Gas").…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
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
- 2 yrs ago
- Learn and 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 yrs 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 yrs 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 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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 yrs 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 yrs 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
- 2 yrs ago
- Get help
- Reported - view
Re: import an Image from WEB
@Rafael Made in Japan. Great taste Rafael.
- John_Halls
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- 1
- Get help
- Reported - view

1 12 13 14 15 16 36

Welcome to the Ninox community

John Halls

Re: Please teach me how to use this global function :-)

Re: Formula help

Re: Print Dashboard

Re: Print Dashboard

Re: Thoughts on a DB redesign

Re: Thoughts on a DB redesign

Re: Sum service amounts from three tables based on dates

Re: Trigger on open database

Re: Create Record Button in a Table > Create R. to a Subtable

Re: Problem with this formula

Re: Ninox script to work with csv files

Re: Click on button in Ninox to view Gmails

Re: Print to File with Invoice Number

Re: Click on button in Ninox to view Gmails

Re: Help me LOOP please.

Re: double click in a cell puzzle.

Re: NEWBIE - CONFIGURING ONE-TO-ONE AND AUTO UPDATING

Re: Conditional formula to calculate 'taxable' and 'non taxable' items...

Re: Conditional formula to calculate 'taxable' and 'non taxable' items...

Re: Need Script for calculating workdays between 1st record, 2nd record, so on.

Re: import an Image from WEB

Re: Syntax for filtering Dates older than from today

Re: Issue with Formula for Clearing Data in Ninox

Re: Double Search

Re: Extract Record from a Table meeting some criteria

Overview