John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Related table field reference
Hi Gianluca Any fields mentioned after the where clause of a select statement, or in the square brackets come from the table mentioned before the where clause or square brackets.…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Readable If within a range
@S Moore I have just realised that this doesn't allow someone to automatically have access to all the accounts. A subtle change to the code could allow that.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Readable If within a range
To get the record ids of a Dynamic Multiple Choice field you need to use the numbers() function. This returns an array of the ids. There isn't a function which can find an element of an array so,…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Counting Confirmed Guests
Hi, just a few questions first Is 'Checked In' a number field or a Yes/No field? What is 'Total Pax'? You mention a group, so are the guests part of a group with one of them the lead in a parent…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: add onselect event for view field
@Jacques TUR That is awesome. Thank you!
- John_Halls
- 2 yrs ago
- Learn and Share
- Reported - view
Re: Conversion into Ninox of old relational data
Hi William Welcome and good to hear from another FileMaker developer. You will have no problems transitioning I am sure, and if you have any questions along the please feel free to ask.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: How to query a table using a dynamic combo box value?
@Fred I thought so too but surprisingly it doesn't work. I spent quite a while trying variants before I found this let i := 'Assigned To'; first((select Staff where Id = number(i)).…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: using if else in formula field
Sorry, that should be switch text(Status1) do case text(Status1) = "offer" or text(Status1) = "angeboten" or text(Status1) = "reserviert": "entworfen" case text(Status1) = "won":…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: using if else in formula field
If this is in a formula field then remove the equals signs if text(Status1) = "lead" then "empty" else if text(Status1) = "offer" then "entworfen" else if text(Status1) = "offer" or text(Status1) =…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: add onselect event for view field
@Jacques TUR That's very kind of you Jacques. I think it would be worthwhile Regards John
- John_Halls
- 2 yrs ago
- Learn and Share
- Reported - view
Re: add onselect event for view field
@Jacques TUR I have noticed that if I chose a different course each time the student record pops up as expected, but if I chose the same course again that student doesn't pop up.…
- John_Halls
- 2 yrs ago
- Learn and Share
- Reported - view
Re: add onselect event for view field
@Jacques TUR Just brilliant. Where there is a many to many join I have always wanted to be able to popup the record of the other side, not the join. Solved!…
- John_Halls
- 2 yrs ago
- 2
- Learn and Share
- Reported - view
Re: Help with wedding base
Hi Ed If your csv imports are working well for you then I would keep these and continue to import your csvs as you have been doing. You need to have a single master table that brings together the…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Trigger after update record not triggered when linking/adding records to sub-table
@Javier You are right in that the parent is not changing, the view. It's not the sum function that's causing the trigger. Triggers only ever happen when you go into a field and make a change to the…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: How do i add up totals
@Edward Can you send the screenshot Edward Thanks John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Number value of multiple choice not correct
Hi Joren It depends... raw(Bestemming) gives 4 (as a hex value in a text field) numbers(Bestemming) gives 3 (as an array) Had you chosen Wonen and Industrie raw(Bestemming) would give 5 (as a hex…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Trigger after update record not triggered when linking/adding records to sub-table
Hi Javier The Trigger after update: has to be on the updated table or field. So if you had a Trigger on update: at the table level of the parent if sum((child).…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: How do i add up totals
@Edward Hi Edward. I've just sent you a message. Regards John
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Unlink composition records
Once unlinked with a button, how are you going to re-assign a parent to this record? The behaviour of Composition, when set to Yes, is designed as such for a well-established reason.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: How do i add up totals
Hi Edward So glad to hear you are still having a go with Ninox. Honestly, it's an amazing bit of kit. I transferred a portion of my FileMaker system to Ninox last week.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Choose more than one?
Having just posted the above after a few hours working the code out, I thought I'd read all of that post and now realise that my code can be replace with if count(numbers(MultipleChoiceField)) > 2…
- John_Halls
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: Choose more than one?
@RoSoft_Steven Rooryck @Lars I had in mind a Trigger on update: on the MCF that would only allow 2 choices and any attempt to add a third would revert the MCF to its original value.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Choose more than one?
@Lars Hi, I'm in the middle of working this out for you. As you say, it's not simple. I should have a solution for you before the end of the weekend!
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Accessing a single line item on an invoice
@Roger You can use the item function to access a single line. Arrays are zero indexed so you need to subtract 1 from the number you use, so let a := 2 item(LineItem,a-1).…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Ignore hyphens when sorting
Hi Davie You could create a formula field with replace(ReferenceNumber, "-", "") and then sort on this field instead. Regards John
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view

1 14 15 16 17 18 31

Welcome to the Ninox community

John Halls

My Posts

Re: Related table field reference

Re: Readable If within a range

Re: Readable If within a range

Re: Counting Confirmed Guests

Re: add onselect event for view field

Re: Conversion into Ninox of old relational data

Re: How to query a table using a dynamic combo box value?

Re: using if else in formula field

Re: using if else in formula field

Re: add onselect event for view field

Re: add onselect event for view field

Re: add onselect event for view field

Re: Help with wedding base

Re: Trigger after update record not triggered when linking/adding records to sub-table

Re: How do i add up totals

Re: Number value of multiple choice not correct

Re: Trigger after update record not triggered when linking/adding records to sub-table

Re: How do i add up totals

Re: Unlink composition records

Re: How do i add up totals

Re: Choose more than one?

Re: Choose more than one?

Re: Choose more than one?

Re: Accessing a single line item on an invoice

Re: Ignore hyphens when sorting

Overview