John Halls's Profile | Ninox community

Badges

Latest Posts

Re: Thoughts on a DB redesign
Excellent work Fred. Looks like a big part of your success is down to recognising and setting Composition correctly. You have some nested three (or four?) deep.
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Improve my script?
Mel Charles This is because the let myP statement is within If.. then.. else. Fabio's revision corrects for this.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Improve my script?
@Mel Charles Try a semi-colon after the middle 'end' if 'Draft!' then alert("Draft Quote Only Saved ! Turn Off Draft Flag To Print Final Quote!") else QuoteImage := null;…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Improve my script?
Hi Mel How about if 'Draft!' then alert("Draft Quote Only Saved ! Turn Off Draft Flag To Print Final Quote!") else QuoteImage := null; if QImage1 = null and QImage2 = null and QImage3 = null and…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: select where statement.
No need to filter. As you say select INVENTORY will show all your inventory. If you use the relationships you have created you can join them together, so don't use select but go to the manufacturer…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
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

1 11 12 13 14 15 35

Welcome to the Ninox community

John Halls

Re: Thoughts on a DB redesign

Re: Improve my script?

Re: Improve my script?

Re: Improve my script?

Re: select where statement.

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.

Overview