John Halls's Profile | Ninox community

Badges

Latest Posts

Re: Making a field writable based on a condition
Thanks for the demo. Using the number associated with OTHER works, so try number('To Wallet') = 23 Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Inconsistency with 'Readable If' and 'Writable If'
@S Moore I've looked into this a bit more and @Jacques TUR is correct. The Ninox table level and field level Writable if... sections do not like select commands being used to return a value.…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: do as deferred
Hi @Rafael I wanted to check you are using do as deferred as it is intended to be used. Have a look at this Optimize performance of scripts You can see,…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Making a field writable based on a condition
I have recreated a working version of this with no issues upper(text('To Wallet')) = upper("other") Not sure what is wrong. What values of 'To Wallet' do you have?…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Inconsistency with 'Readable If' and 'Writable If'
@Jacques TUR Not mine! Agreed it needs a re-write but I didn’t understand it well enough on first sight to do so
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Inconsistency with 'Readable If' and 'Writable If'
@Jacques TUR The first thing I did was take all the comments out, and tidy up the function but there is definitely something odd going on. Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Sort by Nb Numerical Size
Try data order by -number(Nb) Regards John
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
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
- 1 yr ago
- Get help
- Reported - view
Re: Field from newest (sub)record
@Fred Neat!
- John_Halls
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: v3.15 presentation
Thanks @Rafael . I'll enjoy watching this tonight.
- John_Halls
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Output format doesn't work for me
@Rafael What would you like it to look like?
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Image disappears, replaced by spinning wheel
@rossowilliams Good spot. Well done for working that one out.
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view

1 2 3 4 5 35

Welcome to the Ninox community

John Halls

Re: Making a field writable based on a condition

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

Re: do as deferred

Re: Making a field writable based on a condition

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

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

Re: Sort by Nb Numerical Size

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

Overview