John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: SELECT with where doesn't work where [] does
Hi @Luis Not sure, bit I think you have the two arguments for contains() the wrong way round, so, for example, the first one should be contains(text('Expense Category'),filtetrCat) Regards John
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Send Email no error, but don't work
@Rafael I looked up the alert() function in the Ninox documentation and, as I thought, this is what it says If you call this function more than once within the same script,…
- John_Halls
- 5 mths ago
- 1
- Get help
- Reported - view
Re: Send Email no error, but don't work
I tested the select statement in the console and it was as I thought, you need to change your select statement to select INVOICE where 'BALANCE DUE' > 0 and 'DUE DATE' - 7 = today() and Reminder !…
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Send Email no error, but don't work
@Rafael I noticed a slight error in the code I gave you, corrected to for i in select INVOICE where 'BALANCE DUE' > 0 and 'DUE DATE' - 7 = today() and Reminder = null do let message :…
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Send Email no error, but don't work
Hi @Rafael This has caught a few people out You now need to include the html: element, even if you are not using html. Try adding html: null, to your code.…
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: v3.15 presentation
Thanks @Rafael . I'll enjoy watching this tonight.
- John_Halls
- 5 mths ago
- Learn and share
- Reported - view
Re: Issue with true value stored in number field
@Mel Charles The only hope is round(9.405 + 0.0000000000001,2) You might need a global function function aRound(value:number,dp:number) do round(value+0.…
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Issue with true value stored in number field
@John Halls Except it doesn't! Aagh,it still equals 9.4
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Issue with true value stored in number field
@Fred Yes, you are right round(9.404,2) = 9.40 Correct round(9.405,2) = 9.40 Incorrect round(9.406,2) = 9.41 Correct @Mel Charles because round(940.5,0) = 941 I would multiply by 100, round to 0dp,…
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Output format doesn't work for me
@Rafael What would you like it to look like?
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Image disappears, replaced by spinning wheel
@rossowilliams Good spot. Well done for working that one out.
- John_Halls
- 5 mths ago
- 1
- Get help
- Reported - view
Re: Compare two fields from different tables with summing
Have a look at the updated file I have added some fields and created a button with this code in it let a := (select MyTable).my_reference_number; let b := (select ImportTable).…
Attachment
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Send Email Only Once
Hi david I haven't checked any of your code but to prevent emails always getting sent, in your button you might want let Date2 := 'Contract Renewal Date'; let Date1 := today(); let daysBetween :…
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Populating a linked record by code
Hi @Markus Jarvinen I would have a data model looking like this There is a relationship between Patients to Pharmacies so that there is one default Pharmacy for each Patient.…
- John_Halls
- 5 mths ago
- 1
- Get help
- Reported - view
Re: Send Email Only Once
Hi david. There’s nothing in your code currently to prevent it sending ann email each time. I’ll post some code later tomorrow to show you how to put this right.
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Send Email Only Once
Hi david Unfortunately a formula field can't trigger a button. You will need to press the button to execute its code. You could get the button to run the code for all your records,…
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Send Email Only Once
Hi david Where is your code? Buttons and triggers will allow you to update fields but my guess is that it's in the Contract Renewal Status formula field.…
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: has the 'styled' function stopped working?
The styled function is working, try it in a function field. Maybe there's a problem with your logic. You have nested if else ends three deep. Try moving to a switch statement.
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Webinar on Automated CSV Import & Export in Ninox on Thursday, 16 January - Open Q&A
@Terri 1 Thanks Terri
- John_Halls
- 5 mths ago
- 1
- Learn and share
- Reported - view
Re: Looking to automate record creation based on a date
There's this discussion about timed scripts which might work for you. I've not come across issues with infinite loops before.
- John_Halls
- 5 mths ago
- 1
- Get help
- Reported - view
Re: Looking to automate record creation based on a date
Are you looking to automate this regardless of whether you are logged in or not, run it once on start-up, or at the push of a button? All are available options. Regards John
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Webinar on Automated CSV Import & Export in Ninox on Thursday, 16 January - Open Q&A
The text says Thursday 9th January. Should this be 16th? Is the time the same? Unfortunately I would struggle to attend at 5pm GMT and wonder, are the webinars available to view afterwards?…
- John_Halls
- 5 mths ago
- Learn and share
- Reported - view
Re: Optimizing Ninox Workflow: Opening Database via URL with Parameters and QR Code Integration
I had a quick look at the URLs used by my databases and I think it's easy to parse Each has the following elements concatenated together Ninox app: app.ninox.…
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: Import not seeing all data
Hi Fred Worked for me, so not sure what was going on. Odd to see an Id of 44 in there for KPF with yours. Regards John
- John_Halls
- 5 mths ago
- Get help
- Reported - view
Re: How do you display information from a record on a website?
This sounds like a candidate for a productized service. Beyond my abilities but maybe there is someone who could create this.
- John_Halls
- 6 mths ago
- 1
- Get help
- Reported - view

1 2 3 4 5 33

Welcome to the Ninox community

John Halls

My Posts

Re: SELECT with where doesn't work where [] does

Re: Send Email no error, but don't work

Re: Send Email no error, but don't work

Re: Send Email no error, but don't work

Re: Send Email no error, but don't work

Re: v3.15 presentation

Re: Issue with true value stored in number field

Re: Issue with true value stored in number field

Re: Issue with true value stored in number field

Re: Output format doesn't work for me

Re: Image disappears, replaced by spinning wheel

Re: Compare two fields from different tables with summing

Re: Send Email Only Once

Re: Populating a linked record by code

Re: Send Email Only Once

Re: Send Email Only Once

Re: Send Email Only Once

Re: has the 'styled' function stopped working?

Re: Webinar on Automated CSV Import & Export in Ninox on Thursday, 16 January - Open Q&A

Re: Looking to automate record creation based on a date

Re: Looking to automate record creation based on a date

Re: Webinar on Automated CSV Import & Export in Ninox on Thursday, 16 January - Open Q&A

Re: Optimizing Ninox Workflow: Opening Database via URL with Parameters and QR Code Integration

Re: Import not seeing all data

Re: How do you display information from a record on a website?

Overview