Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
John Halls
John_Halls
Somerset, England
718
111
1
Joined: Thu Feb 11 10:04:26 UTC 2021
Follow
My Posts
Latest Posts
Re: acces to array items like with Where fonction
@Jacques TUR Hi Jacques. Plenty of new concepts for me here. So 'this' is not confined to records x[=v], v doesn't have to be a single element, and can in fact be larger than x All good stuff,…
John Halls
John_Halls
2 yrs ago
Learn & Share
Reported - view
Re: Complex Select statement for View
Hi Mike It all sounds so intriguing. I'd like to have a look at this but worry that I might spend an hour so two barking up the wrong tree. Can you give me a couple of examples?…
John Halls
John_Halls
2 yrs ago
Get help
Reported - view
Re: How do i connect a table?
Hi Edward These arrows can seem mightily confusing, to begin with. Table references are always added from the 'Many' side, so go to your Invoices table and add Customer-old to it. Regards John
John Halls
John_Halls
2 yrs ago
Get help
Reported - view
Re: How to action a trigger after form close?
@MUGANJI JULIUS You are right. It will need additional controls to find out who and when the record was modified. There are 'Modified on' and 'Modified by' fields and you could use these in…
John Halls
John_Halls
2 yrs ago
Get help
Reported - view
Re: How to action a trigger after form close?
I'm not 100% sure but try this: If you don't have one on your form already, add a Tab. Place your code in the Trigger after hide option of the tab. If you only have one tab and don't want a second…
John Halls
John_Halls
2 yrs ago
1
Get help
Reported - view
Re: Related table field reference
@Gianluca Wherever you have a relationship between tables you can use the name of the relationship field to access related data. In my bit of code sum(Table2.…
John Halls
John_Halls
2 yrs ago
1
Get help
Reported - view
Re: Related table field reference
@Gianluca Hi, it won't return multiple values because you are looking for the sum of the amount. This would go in a formula field. Now that you have explained a bit more the formula is simpler than…
John Halls
John_Halls
2 yrs ago
1
Get help
Reported - view
Re: Filter on hidden columns
@Chris Mullett To filter on a hidden field create a formula field and chose a field you do want to display. Set a script in the formula field to show this data if the filter condition is true,…
John Halls
John_Halls
2 yrs ago
Get help
Reported - view
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
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
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
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
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
John_Halls
2 yrs ago
Learn & 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
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
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
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
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
John_Halls
2 yrs ago
Learn & 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
John_Halls
2 yrs ago
Learn & 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
John_Halls
2 yrs ago
2
Learn & 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
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
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
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
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
John_Halls
2 yrs ago
1
Get help
Reported - view
1
12
13
14
15
16
29
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics