John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Button to open a PAGE
Anyone else noticed that openPage() doesn't work on the iPhone app? Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: selecting only first record meeting a criteria
Hi Would the use of unique help? I've only quickly glanced at your code. It would either go here let x := unique(select Reference where Date = xDate and Event = xEvent); or here let y :…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 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

1 8 9 10 11 12 33

Welcome to the Ninox community

John Halls

My Posts

Re: Button to open a PAGE

Re: selecting only first record meeting a criteria

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...

Overview