John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: The script don't work
Hi @Rafael You need to add a first() function in your select statement to return a record rather than an array let rate := first(select Categories where Category = catg).Rate; Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Time to create more work for myself...
Super impressive Fred. What sport is this?
- John_Halls
- 1 yr ago
- Learn and share
- Reported - view
Re: Database Split
Hi Mel. Thank is a pain, that if you want to re-order the tabs you need to move all the fields as well.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Database Split
Thanks Alan. I didn’t know that!
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
@Fred Hi Fred, so good to see these techniques unfold. I have NEVER used range() before. It's such a powerful function. Unlike the for i from 0 to 10 do statement range() allows for descending…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Database Split
My Pleasure Ian It is, in my view, good practice to add a tab layout field in the first position because it gives you far more control going forward. I always include another tab called 'Hidden' as…
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
@MZ Ah, that's what I was trying to put together. It would have taken me days to put it so succinctly.
- John_Halls
- 1 yr ago
- 2
- Get help
- Reported - view
Re: Database Split
Hi Ian If I understand it correctly "Database" is a tab which was the first item in the Edit fields... section. This has now been moved down two places.…
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Help with code to create non-repeating set of 10 numbers
Hi Fred My reply to the previous post gives a non-repeating set of numbers between 0 and 9. It makes an array of 100 numbers but all of them are between 0 and 9.…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Populate a field with values from a list
This works in the console let letterArray := ["A", "B", "C", "D", "E", "F", "G", "H", "I", "J"]; let numArray := unique(for loop1 from 1 to 100 do [floor(random() * 10)] end); let Text :…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Populate a field with values from a list
I know it's a bit of a sledgehammer to crack a nut but this gives and array of 0 to 9 randomly sorted let numArray := for loop1 from 1 to 100 do [floor(random() * 10)] end;…
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Regarding the issue of modifying a sub-table of a sub-table.
Where Script is a field to allow you to see the result of running your script instead of shown by an alert
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Issue with a script that does not display the expected value when two fields are equal
Hi Rafael It’s the same as the code I reduced in size in your last post. Take a look at it. I took out the if.. else part where you set a field to null.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Regarding the issue of modifying a sub-table of a sub-table.
Fred is right, it isn't reccommened to put alerts in a loop. I would set a text or choice field so that you can see the results of running your script. If it was a choice field called Script it would…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Regarding the issue of modifying a sub-table of a sub-table.
Hi Your codes goes from this for one product line let aa := this; for i from 0 to nb do let newRec := (create Code); newRec.(Products := aa) end To this for all product lines in a order for aa in…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: How to use code to remove extra information?
let cr := " "; join(split('Text 2', cr)[!= ""], cr)
- John_Halls
- 1 yr ago
- 5
- Get help
- Reported - view
Re: Some idea ?
@Rafael Fab. Always tricky when it's being coded outside of Ninox.
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Some idea ?
I think your code can be shorted to this, at least. Test it first though... let vDd := 'Add Data|Date'; if dialog(" Warning ", " ¿Confirm the Progress Update by Disciplines ? ", ["Yes",…
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Sub table query - limit to current record
Hi James You have hit the nail on the head. The language has been designed so that almost everything in Ninox has a simple solution. As soon as you feel like you are going down a rabbit hole it's…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Script to update records in another table
Hi You can also make if count(existingRecord) > 0 then for record in existingRecord do delete record; end end become for record in existingRecord do delete record;…
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Sub table query - limit to current record
Hi James No need for a select statement, you can scope with square brakets sum('Event Expenses'[Type = 10].Amount) Regards John
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Script to update records in another table
Well, I've just spent half an hour writing a detailed reply, only to lose it! Sorry about that...
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Activate or Deactivate all records in a "Yes/No" field
@Rafael Another approach would be to set the Binding of your Protect field to 'Global variable in memory (browser)'. It then has a single value for all your records.…
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected
Hi. Unfortunately, it's not quite as simple as that. Have a look at this post https://forum.ninox.com/t/83hrts2#y4hrsgn Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Analysis of your database structure with Ninext
Hi @Jacques TUR Interesting to see @Fred has the following "relation <= 1:N": 52, "relation => N:1": 52, Which would be expected but you have "relation <= 1:N": 146, "relation => N:1": 144,…
- John_Halls
- 1 yr ago
- Learn and share
- Reported - view

1 7 8 9 10 11 34

Welcome to the Ninox community

John Halls

My Posts

Re: The script don't work

Re: Time to create more work for myself...

Re: Database Split

Re: Database Split

Re: Help with code to create non-repeating set of 10 numbers

Re: Database Split

Re: Help with code to create non-repeating set of 10 numbers

Re: Database Split

Re: Help with code to create non-repeating set of 10 numbers

Re: Populate a field with values from a list

Re: Populate a field with values from a list

Re: Regarding the issue of modifying a sub-table of a sub-table.

Re: Issue with a script that does not display the expected value when two fields are equal

Re: Regarding the issue of modifying a sub-table of a sub-table.

Re: Regarding the issue of modifying a sub-table of a sub-table.

Re: How to use code to remove extra information?

Re: Some idea ?

Re: Some idea ?

Re: Sub table query - limit to current record

Re: Script to update records in another table

Re: Sub table query - limit to current record

Re: Script to update records in another table

Re: Activate or Deactivate all records in a "Yes/No" field

Re: Issue with trigger conditions in 'Liste' Field: Multiple Text conditions not triggering as expected

Re: Analysis of your database structure with Ninext

Overview