John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

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
Re: Setting up a FIFO inventory
Hi Andy I can't see it ATM but it wouldn't be too difficult to re-create if you would like me to? I can't today but will do so in the next couple of days if you would like. Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: New Member Introduction - Seeking Guidance and Tips
Hi Mitchel Welcome to our forum.You will be made to feel more than welcome here, as I was. No question is too big or small. Kind regards John
- John_Halls
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Issue/Bug in report creation
Hi Alan. Yes I am seeing the same issue. Clicking on the cog icon (top right in any highlighted field) brings up the formula builder and you can add / update fields from there. Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Values not displaying
Hi The Edit columns section is used to determine what is shown when selecting a record. Regards John
- John_Halls
- 1 yr ago
- Get help
- Reported - view
Re: Values not displaying
I can understand why you thought that would be the correct place to set this, but in fact, it's set in the 'Show data as' formula field TBH I'm not quite sure where the Edit columns set here would…
- John_Halls
- 1 yr ago
- Get help
- Reported - view

1 6 7 8 9 10 33

Welcome to the Ninox community

John Halls

My Posts

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

Re: Setting up a FIFO inventory

Re: New Member Introduction - Seeking Guidance and Tips

Re: Issue/Bug in report creation

Re: Values not displaying

Re: Values not displaying

Overview