John Halls's Profile | Ninox community

Badges

Latest Posts

Re: I need to build a string for each "checked" multiple choice
Hi Jason Use the chosen() function. https://docs.ninox.com/en/script/functions/chosen Regards John
- John_Halls
- 4 yrs ago
- 2
- Get help
- Reported - view
Re: while loop stops before reaching end
Just tested your db and its working fine for me both for test and main records.
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: while loop stops before reaching end
There are a fair number of select statements in the function fields and I would think they are the primary reason for your button failing. Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: syntax problems
@Fred Hi Fred I think Jarno wants the start date of the new record to populate the end date of the previous record. Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
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
- 4 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
- 4 yrs ago
- Get help
- Reported - view
Re: Auto-increment?
@Mel Charles Do I have a problem overthinking things? Tell me the truth...
- John_Halls
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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 4 yrs ago
- 1reply
- 188
- 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
- 4 yrs ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
@Mel Charles Thanks Mel, glad you like it!
- John_Halls
- 4 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
- 4 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
- 4 yrs ago
- Get help
- Reported - view

1 17 18 19 20 21 37

Welcome to the Ninox community

John Halls

Re: I need to build a string for each "checked" multiple choice

Re: while loop stops before reaching end

Re: while loop stops before reaching end

Re: syntax problems

Re: syntax problems

Re: Auto-increment?

Re: Auto-increment?

Re: Auto-increment?

Re: Make some informations confidential

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

Overview