John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Creating a Button That Goes to Table with only Linked Records
Hi David Here's an alternative way. Add a new field to your child, lets call it Subset Add a new child view (let's call it By Client) that matches the existing view but swapping out Client ID for…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@David Irving Did you try it because that's exactly what it will do?
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
@Jacques TUR Thank you Jacques. There will be plenty of places for that beauty in my code from now on.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Function parameters - which types are possible
@Sean What does the second parameter in eval() do? I've only ever seen and used "this" Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
Hi David Have a look at this post I put up about Virtual Lists https://forum.ninox.com/t/m1hrzt8 It's not exactly what you describe above, but the end result is essentially the same.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Values of Multiple Choice shown as list in print report
Hi Joren Use Join() in conjunction with chosen() join(chosen('Multiple choice'), " ") Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: while loop stops before reaching end
@Mel Charles @Sean I have a few FileMaker clients and also use it, together with Ninox, for my own business. Love ‘em both.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Auto-increment?
@Mel Charles Do I have a problem overthinking things? Tell me the truth...
- John_Halls
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- 1
- Get help
- Reported - view

1 14 15 16 17 18 34

Welcome to the Ninox community

John Halls

My Posts

Re: Creating a Button That Goes to Table with only Linked Records

Re: Creating a Button That Goes to Table with only Linked Records

Re: Function parameters - which types are possible

Re: Function parameters - which types are possible

Re: Creating a Button That Goes to Table with only Linked Records

Re: Values of Multiple Choice shown as list in print report

Re: while loop stops before reaching end

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

Overview