John Halls's Profile | Ninox community

Badges

Latest Posts

Re: simple dynamic field - small issue
@sjames05569 Always a good idea to hide unneeded fields. It is also functionally worthwhile too. I have a RAG system (Red, Amber. Green) for my quality control.…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: Printing an attached file
@Mel Charles We are checking with the contractor who looks after our printers, but there should be a folder (variously called a "Hot Folder, "Direct Print" or "User Box") that documents can be sent…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: Printing an attached file
@Mel Charles Thanks Mel When I get back to work tomorrow I'm going to look to see if our photcopier has an email to print, or a folder to print service that I didn't know about. Regards John
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Printing an attached file

Hi All If I want to print an attached file I can click on the file and then download it, and from there print it out. Is there a way of ending up with a printed hardcopy from a single click of a…
- John_Halls
- 7 mths ago
- 3replies
- 81
- 1
- Get help
Re: copy table record with child records to another table record also with child records
Well done Fred. That's the one Regards John
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
@Mel Charles in your screenshot, your table is JobLines but the reference is Joblines. Have you done the same thing on the other side of the relationship,…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
@Mel Charles One has an uppercase J MultiJobs, but in your reply earlier you said 'deffo Multijobs' which is lower case j. Line 2 is the table but line 8 is the reference and if you named the table…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
Multijobs vs MultiJobs ?
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
I re-created your tables and the code is fine let source := this; let tgt := (create MultiJobs); tgt.(Customers := source.'Acc Link'); tgt.('Quote Ref' := source.QteNum); tgt.…
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
Hi Mel Just quickly There’s no semi-colon at the end of line 8 Regards John
- John_Halls
- 7 mths ago
- Get help
- Reported - view
Re: Auto-fill field not triggering when record is created via popup — is this expected?
Hi I just uploaded your example, and it works fine. I used the Public Cloud 3.18.6 Regards John
- John_Halls
- 7 mths ago
- Get help
- Reported - view
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
- 7 mths ago
- 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
- 7 mths 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
- 7 mths 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
- 7 mths ago
- Get help
- Reported - view
Re: Sorting for a View Element
Of course, good luck!
- John_Halls
- 7 mths 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
- 7 mths 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
- 7 mths 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
- 8 mths ago
- 1
- 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
- 8 mths 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 mths 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 mths 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 mths 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
- 8 mths ago
- Get help
- Reported - view
Re: Some Help
@Rafael My pleasure
- John_Halls
- 9 mths ago
- Get help
- Reported - view

1 2 3 4 5 37

Welcome to the Ninox community

John Halls

Re: simple dynamic field - small issue

Re: Printing an attached file

Re: Printing an attached file

Printing an attached file

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: copy table record with child records to another table record also with child records

Re: Auto-fill field not triggering when record is created via popup — is this expected?

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

Overview