Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

756
123
1

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

My Posts

Latest Posts

Re: syntax problems
Hi Jarno We can help! Could you show me a screen shot of the table structure of your three tables. Are they joined together with Reference fields? Many thanks John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Auto-increment?
@Kent Signorini Hi Kent They are all in the one table, Reference. I have a record for each reference number that I need to track. My Reference table might look like this Each call Ref :…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Auto-increment?
@Mel Charles Do I have a problem overthinking things? Tell me the truth...
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Auto-increment?
Hi Kent This is going to seem like over-kill, but it's the way I do it as I have a Ref field in most of my tables. I have a Reference table with the following structure NextRef has the formula…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Make some informations confidential
@Paul Chappell Thanks. I only learned about this a few days ago. I found the simple concept fascinating!
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
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 ago
- 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 ago
- 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 ago
- 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 ago
- 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 ago
- 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 ago
- 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 ago
- 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 ago
- 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 ago
- 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 ago
- 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 ago
- 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 ago
- 1reply
- 143
- 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 ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
@Mel Charles Thanks Mel, glad you like it!
- John_Halls
- 2 yrs ago
- 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 ago
- 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 ago
- 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 ago
- 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 ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
In a formula field.
- John_Halls
- 2 yrs ago
- 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 ago
- Learn and share
- Reported - view

1 11 12 13 14 15 31

Back to top

Ninox-Documentation

Overview

View all topics