John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: If possible, adapt the script.
Hi Rafael Why do you have these lines? let response := true; if response then Regards John
- John_Halls
- 10 days ago
- Get help
- Reported - view
Re: How to set a default value for dynamic fields?
Use the table level Trigger on new record: and add this code 'Saison a afficher' := 8 Regards John
- John_Halls
- 1 mth ago
- 1
- Get help
- Reported - view
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 mth 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 mth 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 mth 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 mth 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 mth 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 mth ago
- Get help
- Reported - view
Re: Sort by Nb Numerical Size
Try data order by -number(Nb) Regards John
- John_Halls
- 1 mth 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 mth ago
- Get help
- Reported - view
Re: Field from newest (sub)record
@Fred Neat!
- John_Halls
- 1 mth 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 mth 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 mth 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 mths ago
- Get help
- Reported - view
Re: v3.15 presentation
Thanks @Rafael . I'll enjoy watching this tonight.
- John_Halls
- 2 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
- 2 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
- 2 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
- 2 mths ago
- Get help
- Reported - view

1 2 3 4 5 33

Welcome to the Ninox community

John Halls

My Posts

Re: If possible, adapt the script.

Re: How to set a default value for dynamic fields?

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

Overview