John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Bug? -- Dynamic Value Name not working for Radio Buttons view
Hi Luis Using a select outside a button or trigger will always be problematic. The select outside of this needs some action on the record, like a field update,…
- John_Halls
- 2 yrs agoMon, June 27, 2022 at 2:42 PM UTC
- Get help
- Reported - view
Re: while loop stops before reaching end
Hi I tested your code and it worked fine for me. How odd. Regards John
- John_Halls
- 2 yrs agoMon, June 27, 2022 at 2:36 PM UTC
- Get help
- Reported - view
Re: Bug? -- Dynamic Value Name not working for Radio Buttons view
Hi Luis Are your tables joined together so that your code can become let theItemName := text(Name); let theTotal := sum(AcquiredHistory.Qty); theItemName + ":…
- John_Halls
- 2 yrs agoMon, June 27, 2022 at 1:28 PM UTC
- Get help
- Reported - view
Re: Button to create new record for sub-table and with reference
Sorry, on the last line change MyID to myID. To take this code to the next level use let myID := this; (create History).( Backup := myID; Date := today(); Usage := sum(Backup.Storage.…
- John_Halls
- 2 yrs agoMon, June 27, 2022 at 6:30 AM UTC
- 1
- Get help
- Reported - view
Re: Button to create new record for sub-table and with reference
Very nearly there. If the reference field for the Backup table in History is called Backup then try let myID := this; let k := sum(Storage.Usage); let newRec := (create History); newRec.…
- John_Halls
- 2 yrs agoMon, June 27, 2022 at 6:10 AM UTC
- Get help
- Reported - view
Re: Make some informations confidential
With your skills I think you could build yourself an XOR Cypher. https://en.wikipedia.org/wiki/XOR_cipher
- John_Halls
- 2 yrs agoSun, June 26, 2022 at 6:05 AM UTC
- Get help
- Reported - view
Re: Expand Groups (default setting)?
Hi. What are groups? I know about Teams and Users and Roles.
- John_Halls
- 2 yrs agoSat, June 25, 2022 at 9:12 AM UTC
- Get help
- Reported - view
Re: Getting Ninox to Recognise a number
Use the number() function. Either wrap it around the formula for the '10am Snorkel AVAILABLE Spaces' field or the whole of your line number(first((select 'Snorkel / Sea Scooter Tours')[Date = 'Date…
- John_Halls
- 2 yrs agoThu, June 23, 2022 at 10:40 AM UTC
- Get help
- Reported - view
Re: Disable Duplicate Function
Hi Kate A similar question was asked the other day. https://forum.ninox.com/t/60hd967/disable-copy-button Regards John
- John_Halls
- 2 yrs agoWed, June 22, 2022 at 10:58 AM UTC
- 1
- Get help
- Reported - view
Re: Make some informations confidential
How about using PGP (Pretty Good Privacy) somehow? If anyone can, you can @Jacques TUR
- John_Halls
- 2 yrs agoTue, June 21, 2022 at 6:21 PM UTC
- Get help
- Reported - view
Re: Using if statements and date calculations to display yes or no based on variable.
Hi I've not fleshed this out but I would use a lookup table and check against it for patients eligible for a further dose. Create a script to run through the patients and create a join record when…
- John_Halls
- 2 yrs agoMon, June 20, 2022 at 8:49 PM UTC
- 1
- Get help
- Reported - view
Speed up a script using Local Binding

I wanted to check my stock position going forward for the next 100 days so I created a table of days and took the daily demand out of stock each day and added in any forward contracts on the day…
- John_Halls
- updated 2 yrs agoMon, June 20, 2022 at 12:44 PM UTC
- 1reply
- 156
- Learn and share
Re: Cross Tab in a Form
@Rafael Good luck. It might be tricky having different entities in each row. Let me know how you get on.
- John_Halls
- 2 yrs agoTue, June 14, 2022 at 11:59 AM UTC
- Learn and share
- Reported - view
Re: Cross Tab in a Form
@Mel Charles Thanks Mel, glad you like it!
- John_Halls
- 2 yrs agoMon, June 13, 2022 at 9:23 PM UTC
- Learn and share
- Reported - view
Re: How can i add more info into the Calendar title
In the date field there is a Show as option Add a formula in here such as 'Job Type' + " " + 'Job Price' + " " + Time Regards John
- John_Halls
- 2 yrs agoMon, June 13, 2022 at 5:13 AM UTC
- Get help
- Reported - view
Re: Hide Multiple fields at once
@Fred Sorry Fred, I only saw the first half of your post.
- John_Halls
- 2 yrs agoSun, June 12, 2022 at 6:06 PM UTC
- Get help
- Reported - view
Re: Hide Multiple fields at once
Hi Simon There is a neat trick, which I use on all of my forms. Create a tab, I call it Hidden, and set 'Display fields only if:' to false. Any objects place inside this tab will automatically be…
- John_Halls
- 2 yrs agoSun, June 12, 2022 at 4:46 PM UTC
- Get help
- Reported - view
Re: Cross Tab in a Form
H Rafael Yes, the rows on line 2, column on line 3, and the values on lines 12, 14, 18, and 20 can all be changed. I have improved to look of the table created by right aligning the values.…
- John_Halls
- 2 yrs agoSun, June 12, 2022 at 7:13 AM UTC
- Learn and share
- Reported - view
Re: Cross Tab in a Form
In a formula field.
- John_Halls
- 2 yrs agoSat, June 11, 2022 at 8:22 PM UTC
- Learn and share
- Reported - view
Re: Cross Tab in a Form
Aside from having my rows and cols the wrong way round(!), I now have the formula reduced down to this let a := this; let Rows := unique((List order by Row).…
- John_Halls
- 2 yrs agoSat, June 11, 2022 at 1:41 PM UTC
- Learn and share
- Reported - view
Re: Cross Tab in a Form
No, the parent table is just a place holder. On a similar, probably better way, this works well in a formula field let a := this; let h := "<table style='width:100%'>"; let b :…
- John_Halls
- 2 yrs agoSat, June 11, 2022 at 11:35 AM UTC
- Learn and share
- Reported - view
Re: Cross Tab in a Form
XTab.ninox
- John_Halls
- 2 yrs agoSat, June 11, 2022 at 10:48 AM UTC
- 1
- Learn and share
- Reported - view
Cross Tab in a Form

I have come up with a way to cross tabulate a table of values in a form This is the table of values And this is the table I use to create the Cross Tab This code do as server delete XTab; let a :…
- John_Halls
- 2 yrs agoSat, June 11, 2022 at 7:51 AM UTC
- 19replies
- 208
- 1
- Learn and share
Re: sum((select......... with two values
Great seeing the progression here...
- John_Halls
- 2 yrs agoSat, June 11, 2022 at 7:09 AM UTC
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
Yes, that's why it works for you. It also works if you only add new records to the end of the list but not if you are inserting records or updating them
- John_Halls
- 2 yrs agoWed, June 8, 2022 at 7:21 AM UTC
- 1
- Get help
- Reported - view

1 13 14 15 16 17 33

Welcome to the Ninox community

John Halls

My Posts

Re: Bug? -- Dynamic Value Name not working for Radio Buttons view

Re: while loop stops before reaching end

Re: Bug? -- Dynamic Value Name not working for Radio Buttons view

Re: Button to create new record for sub-table and with reference

Re: Button to create new record for sub-table and with reference

Re: Make some informations confidential

Re: Expand Groups (default setting)?

Re: Getting Ninox to Recognise a number

Re: Disable Duplicate Function

Re: Make some informations confidential

Re: Using if statements and date calculations to display yes or no based on variable.

Re: Cross Tab in a Form

Re: Cross Tab in a Form

Re: How can i add more info into the Calendar title

Re: Hide Multiple fields at once

Re: Hide Multiple fields at once

Re: Cross Tab in a Form

Re: Cross Tab in a Form

Re: Cross Tab in a Form

Re: Cross Tab in a Form

Re: Cross Tab in a Form

Re: sum((select......... with two values

Re: How to Calculate Cumulative Sum

Overview