John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Button script: add new record from table B to current record in table A
Hi Do you mean, turn this let newServiceLog := (create 'Service Log'); newServiceLog.('Vehicle Service' := newVehicleService); let this.'Service Log' := newServiceLog; into this let newServiceLog :…
- John_Halls
- 3 mths ago
- Get help
- Reported - view
Re: Anybody have 3.15.5 yet?
@Mel Charles Has it been sorted for you Mel?
- John_Halls
- 4 mths ago
- Learn and share
- Reported - view
Re: Error """ in formula field
Hi Andrea You could use urlDecode. The code for a quote is %22 and so your formula should be urlDecode("%22"+ROLE+"%22") Regards John
- John_Halls
- 4 mths ago
- Get help
- Reported - view
Re: use of for fonction
So pleased. All the best.
- John_Halls
- 4 mths ago
- Get help
- Reported - view
Re: use of for fonction
Hi for is used to loop through an array for a in select table do do something here using a... end where is used to scope the array returned with a select command for a in select table where condition…
- John_Halls
- 4 mths ago
- Get help
- Reported - view
Re: If possible, adapt the script.
Hi Rafael Why do you have these lines? let response := true; if response then Regards John
- John_Halls
- 5 mths 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
- 6 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 7 mths ago
- Get help
- Reported - view
Re: Sort by Nb Numerical Size
Try data order by -number(Nb) Regards John
- John_Halls
- 7 mths 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
- 7 mths ago
- Get help
- Reported - view
Re: Field from newest (sub)record
@Fred Neat!
- John_Halls
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 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
- 7 mths ago
- Get help
- Reported - view

1 2 3 4 5 34

Welcome to the Ninox community

John Halls

My Posts

Re: Button script: add new record from table B to current record in table A

Re: Anybody have 3.15.5 yet?

Re: Error """ in formula field

Re: use of for fonction

Re: use of for fonction

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

Overview