John Halls's Profile | Ninox community

Badges

Latest Posts

Re: Sorting for a View Element
@RoSoft_Steven Can you add links to these HTML tables that will go to a record? I've made cross-tabulation tables in HTML before but not had need to interact with them. Regards John
- John_Halls
- yesterday
- Get help
- Reported - view
Re: Formula Problem ?
Hi @Rafael If 'Cost Rate' has 2 decimal places and you are multiplying by 1.35, the 'Fully Loaded Cost Rate' can have up to 4 decimal places. I would use 'Fully Loaded Cost Rate' = round('Cost Rate'…
- John_Halls
- 2 days ago
- Get help
- Reported - view
Re: Sorting for a View Element
@Fred Hi Fred. I don't think the view takes into account how the records are sorted by the select. Let me know if that's incorrect. Regards John
- John_Halls
- 2 days ago
- 1
- Get help
- Reported - view
Re: Formula Problem ?
I see there might be a link between the 1,100 and 5.5. Maybe the 55.22 has been rounded up from 55.215? Regards John
- John_Halls
- 2 days ago
- Get help
- Reported - view
Re: Sorting for a View Element
Of course, good luck!
- John_Halls
- 2 days ago
- 1
- Get help
- Reported - view
Re: Sorting for a View Element
@Michael Blechinger If it were me, I'd go with creating 4 views. You have done so much prep work anyway.
- John_Halls
- 2 days ago
- 1
- Get help
- Reported - view
Re: Sorting for a View Element
Hi @Michael Blechinger I am fairly certain that the sort order is defined in the view (where you say which columns to show and you are able to sort one of them ascending or descending,…
- John_Halls
- 2 days ago
- 1
- Get help
- Reported - view
Re: Negative Round number make the APP CRASH!!!
You are right! I've quickly put together a global function to address this. I've kept it line by line so you can see how it works function rnd(numberToRound : number,digits :…
- John_Halls
- 6 days ago
- Get help
- Reported - view
Re: Date formula
@wright. 74472 I started re-creating your formula and this works format('Start Date' + 30, "MM") = format('Start Date', "MM") But this doesn't format('Start Date' + 30, "MM") = format('Start Date',…
- John_Halls
- 7 days ago
- Get help
- Reported - view
Re: Date formula
@John Halls In fact, I don't think I am quite right there but I feel I must be along the right lines... I know you must have put in a lot of work to get this working but I would encourage you to…
- John_Halls
- 8 days ago
- Get help
- Reported - view
Re: Date formula
@wright. 74472 It's to do with the first line of your formula format('Start Date' + 30 "MM") = format('Start Date' "MM") For February, and only February, this is not true. Regards John
- John_Halls
- 8 days ago
- 1
- Get help
- Reported - view
Re: Date formula
Hi I agree with Fred. Having 31 copies of the same fields is going to be so hard to maintain. Create a child table with a single copy of the same set of fields and then create the records you need in…
- John_Halls
- 8 days ago
- Get help
- Reported - view
Re: Count number of entries in a year
Hi @Burkay You are missing a second closing bracket count(select 'Verkauf' where year('Datum') = 2025)) But if it's a subtable your code would count all the entries for every parent.…
- John_Halls
- 2 wk ago
- Get help
- Reported - view
Re: Some Help
@Rafael My pleasure
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Some Help
Hi @Rafael I hope you don't mind me looking at your code. I see it as a challenge to make it as succinct as possible and I have come up with let options := ["Cancel", "Major Projects",…
- John_Halls
- 1 mth ago
- 1
- Get help
- Reported - view
Re: Lizenzaktivität
In Options, there is a Trigger after open section where you can put code to add a record to a table when the database is opened. The user() function returns the name of the current user.…
- John_Halls
- 1 mth ago
- Get help
- Reported - view
Re: Number field error with 22 digit USPS tracking #
Hi @Mr. K. Although these are all digits, the field should be a text field. Some couriers might use alphanumeric tracking numbers. Number fields should not be used for tracking numbers,…
- John_Halls
- 1 mth ago
- 1
- Get help
- Reported - view
Re: Merry Christmas
Merry Christmas everyone. Looking forward to 2026.
- John_Halls
- 2 mths ago
- 6
- Learn and share
- Reported - view
Re: Formula for the button
If you look at your data model, it looks like this There is nothing joining your Investors to your Projects. Because a Project can have more than one Investor,…
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: Formula for the button
@Fred Glad you asked, I was struggling to get my head round this one...
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: Count items (all) in a dynamic multi choice field
@Graham Brown Fred is right. Should work Graham
- John_Halls
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Count items (all) in a dynamic multi choice field
You could repeat the select in a formula field and count the members of the resulting array. count(select table where field1 = value1) All other options seem to give the number of selected items…
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: “Trigger after open“. Opening a page in fullscreen
Hi Pascal openFullscreen(nid) does open a page in fullscreen, but doesn't maximise the window you are in. Not sure how you would do that outside of manually doing so. Regards John
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: Trouble finding a column
There’s an extra end, line 14, that isn’t needed.
- John_Halls
- 2 mths ago
- Get help
- Reported - view
Re: Trouble finding a column
Sorry, from your original issue, it should be let key := this; if 'Commande?' then let t := (create 'Lignes Commandes'); let d := Offres.Options.'Fiche Option'.…
- John_Halls
- 2 mths ago
- Get help
- Reported - view

1 2 3 4 5 35

Welcome to the Ninox community

John Halls

Re: Sorting for a View Element

Re: Formula Problem ?

Re: Sorting for a View Element

Re: Formula Problem ?

Re: Sorting for a View Element

Re: Sorting for a View Element

Re: Sorting for a View Element

Re: Negative Round number make the APP CRASH!!!

Re: Date formula

Re: Date formula

Re: Date formula

Re: Date formula

Re: Count number of entries in a year

Re: Some Help

Re: Some Help

Re: Lizenzaktivität

Re: Number field error with 22 digit USPS tracking #

Re: Merry Christmas

Re: Formula for the button

Re: Formula for the button

Re: Count items (all) in a dynamic multi choice field

Re: Count items (all) in a dynamic multi choice field

Re: “Trigger after open“. Opening a page in fullscreen

Re: Trouble finding a column

Re: Trouble finding a column

Overview