John Halls's Profile | Ninox community

Badges

Latest Posts

Re: Return of ID Number
I can't see why? I can create a formula with let me := this; number(me.Id) without errors, but if you are staying on the current record all you need is Id Regards John
- John_Halls
- 12 days ago
- Get help
- Reported - view
Re: Status script not working
@Fred Just did a small test. Initially cnt(JobLines.Dispatched) will return 0. As they are checked it increments up, but regardless of its state, as it has gone from null to True or False and null…
- John_Halls
- 2 wk ago
- Get help
- Reported - view
Re: Status script not working
Hi Mel The two are going to be equal. You need square brackets in the JobLines count, eg if cnt(JobLines[Dispatched]) = LineCount then "Order Completed" else if cnt(JobLines[Dispatched]) < LineCount…
- John_Halls
- 2 wk ago
- Get help
- Reported - view
Re: Problem Ninox
Pretty sure it's linked to Ninox 4. If you had a beta invite you now have to reset your password in Ninox 3, which unifies the login details for Ninox 3, and Ninox 4.…
- John_Halls
- 2 wk ago
- Get help
- Reported - view
Re: Parent and Child reUnion
@Fred I doubt it's a feature as such, so use with caution.
- John_Halls
- 3 wk ago
- Get help
- Reported - view
Re: Parent and Child reUnion
@Fred Not so. Have a look at this example. Two different tables with the same structure. The View code is let a := (select A); let b := (select B); let c := array(a, b);…
Attachment
- John_Halls
- 3 wk ago
- 2
- Get help
- Reported - view
Re: copy table record with child records to another table record also with child records
Hi @Mel Charles @Fred this is just what I was alluding to with my post a couple of days ago. Took me ages to get the syntax right for shareFile and then use the result in importFile.…
- John_Halls
- 4 wk ago
- Get help
- Reported - view
Re: Emailing a set of child attachments
@Mel Charles Glad it was useful Mel.
- John_Halls
- 1 mth ago
- Learn and share
- Reported - view
Emailing a set of child attachments

I thought I'd post the code that I came up with, as I struggled to get all the syntax correct and couldn't find a decent example of how to go about it. I have a quality system and I wanted to send an…
- John_Halls
- 1 mth ago
- 2replies
- 32
- 1
- Learn and share
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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- 3replies
- 40
- 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 2 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
- 2 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
- 2 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
- 2 mths ago
- Get help
- Reported - view
Re: Sorting for a View Element
Of course, good luck!
- John_Halls
- 2 mths ago
- 1
- Get help
- Reported - view

1 2 3 4 5 36

Welcome to the Ninox community

John Halls

Re: Return of ID Number

Re: Status script not working

Re: Status script not working

Re: Problem Ninox

Re: Parent and Child reUnion

Re: Parent and Child reUnion

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

Re: Emailing a set of child attachments

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

Overview