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
@Rafael Thanks Rafael Works like a charm! Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Rafael Shouldn't it be let a := Cod_RQ; (select Renglones)[Subset != null].(Subset := null); Renglones.(Subset := a); openTable("Renglones", "By RQ") Changing Renglones_RQ.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Rafael Your code needs to go in a button.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Alain Fontaine I'd just done the same, may as well include it too!
Attachment
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Rafael It’s in my own system. I can put together an example over the next few days.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Alain Fontaine Marginally faster but far, far better code. Thank you.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
Got the do as server version to work consistently. do as server for a in select Chronos where Subset != null do a.(Subset := null) end; for b in Chronos do b.(Subset := b.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@Fred I do as David is asking across my own solution. I can have a few hundred child records per parent and there are times when I want to see more than just six of them at a time.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 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

1 12 13 14 15 16 32

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: Creating a Button That Goes to Table with only Linked Records

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: Creating a Button That Goes to Table with only Linked Records

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: 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

Overview