John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Inconsistency with 'Readable If' and 'Writable If'
Hi @S Moore This is the oddest thing. I have tried so many permutations of your function. I have scrunched it down from function permCheck(group_id_val : number,record_location_id : number,…
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: Field from newest (sub)record
@Fred Neat!
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: Hide multiple elements at once
@Vermaji I would add a formula field where you can code the conditions that show or hide the fields. Then use this field in the Display field only if... of the fields you need to control. Regards John
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: Hide multiple elements at once
I have a "Hidden" tab on all my forms. Here I put all the fields I don't need to see and hide the tab with isAdminMode() That way I only see this tab, and it's fields,…
- John_Halls
- 9 mths ago
- 1
- Get help
- Reported - view
Re: SELECT with where doesn't work where [] does
@Luis Ah, maybe I am on the web. @Fred will be able to test in the same environment as you. Good luck!
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: SELECT with where doesn't work where [] does
@Luis As far as I have tested both formats work fine. Regards John
- John_Halls
- 9 mths ago
- Get help
- Reported - view
Re: How to use order by with constraints
@Vermaji No, unfortunately, the records can't be sorted through a script. If you incluse an "order by " in the script it is ignored. Relationships, Views and the record picker all have to be sorted…
- John_Halls
- 9 mths ago
- Get help
- Reported - view
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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 mths ago
- Get help
- Reported - view
Re: v3.15 presentation
Thanks @Rafael . I'll enjoy watching this tonight.
- John_Halls
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 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
- 9 mths ago
- Get help
- Reported - view

1 2 3 4 5 34

Welcome to the Ninox community

John Halls

My Posts

Re: Inconsistency with 'Readable If' and 'Writable If'

Re: Field from newest (sub)record

Re: Hide multiple elements at once

Re: Hide multiple elements at once

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

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

Re: How to use order by with constraints

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?

Overview