Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and Share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
John Halls
John_Halls
Somerset, England
763
129
1
Joined: Thu Feb 11 10:04:26 UTC 2021
Follow
My Posts
Latest Posts
Re: Custom Buttons
@Kruna Sorry Kruna, this is beyond my scope. I hope someone else will be able to help
John Halls
John_Halls
11 mths ago
Learn and Share
Reported - view
Re: Custom Buttons
@Kruna The code above was missing a final close quote and close bracket on line 23 </html>") Regards John
John Halls
John_Halls
11 mths ago
Learn and Share
Reported - view
Re: A trip down memory lane
Hi Fred. Thank you so much for sharing. This is so interesting to look at, not that I am pretending to understand your system. Are you able to share any of the UI as well? Regards John
John Halls
John_Halls
11 mths ago
Learn and Share
Reported - view
Re: Invoice lines of old invoices
Hi Raisla67 Yes, Fred is right. Additionally, everything relating to that invoice should be held in a static format, company name, company address, stock code, stock description, stock price,…
John Halls
John_Halls
11 mths ago
Get help
Reported - view
Re: How do you give a Yes/No field in Chart text names instead of 1/No
@Matthew This is an important point regarding 'Yes / No' fields. Unless a default value of 'Yes' or 'No' is set the value will be null, not what you would expect from a 'Yes / No' field.
John Halls
John_Halls
1 yr ago
Get help
Reported - view
Re: Coding a popup dialog in a for loop if error
@Marisol Echaide said: I've been reading that loops cannot be coded to exit Hi Marisol. I feel a duty to say that loops can be coded to exit in Ninox, just not so easily in the form you are using eg…
John Halls
John_Halls
1 yr ago
Get help
Reported - view
Re: How to calculate years and months from a date to the current date?
Hi Bernd. Have a look at this post https://forum.ninox.com/t/m1hrxas#h7hrbyz Regards John
John Halls
John_Halls
1 yr ago
1
Get help
Reported - view
Re: Using triggers for yes/no field
You mght also need to change Status = "Closed" to text(status) = "Closed" or better still status = 1 (the option number of status for Closed). And do the same for Expired.…
John Halls
John_Halls
1 yr ago
Get help
Reported - view
Re: Using triggers for yes/no field
Hi Rick You need to be checking for an update in the Status and Campaign Premium fields but you have your code in Winner. Place the same code in these two fields and take it away from Winner and all…
John Halls
John_Halls
1 yr ago
Get help
Reported - view
Re: Button to open a PAGE
@Sam hi Sam. Just got it today.
John Halls
John_Halls
1 yr ago
Get help
Reported - view
Re: Button to open a PAGE
@Fred Hi Fred. I do use the cloud. The iPhone app allows me to access this on my phone. What's worse than it not recognising openPage() is that if you edit a page on the app it turns it into a table,…
John Halls
John_Halls
1 yr ago
Get help
Reported - view
Re: Code about random numbers
Hi. Use the random() function, as explained here https://docs.ninox.com/en/script/functions-overview/functions/random Be aware that generating random numbers is a really hard thing to do,…
John Halls
John_Halls
1 yr ago
Get help
Reported - view
Re: Button to open a PAGE
Anyone else noticed that openPage() doesn't work on the iPhone app? Regards John
John Halls
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
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
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
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
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
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
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
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
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
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
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
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
John_Halls
1 yr ago
Learn and Share
Reported - view
1
6
7
8
9
10
31
Ninox-Website
Overview
Learn and Share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics