Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

758
128
1

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

My Posts

Latest Posts

Re: Production: should storage tanks share a table or each have their own?
@Alex Mumm Hi Alex Looking at your recent posts it looks like there is something going on that is not limited to this bit of code. You could try wrapping it in a do as server command.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Suggestions from May 2022
Y axis data ranges for charts. I keep track of a daily market value which is alway between 150 and 250 and I don’t need the chart to go to zero.
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Suggestions from May 2022
A calendar as a view, and as a layout element
- John_Halls
- 2 yrs ago
- 2
- Learn and share
- Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
Can we see an image of your data model please.
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Not Displaying Appointments on Mondays???!?!?!?
Hi. Sorry but I’ve been unable to recreate this. What happens if you test this in a new database?
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Report Writer
Hi Jane @jane.e.fielding said: Is it possible to sort on a field in the report writer but not display it? Not that I am aware. What I would recommend doing is create an additional number field,…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Not Displaying Appointments on Mondays???!?!?!?
Hi Admin Have you looked at the other views, 5 day or 1 day, or unchecked the 'show only working hours' button? What type of field is the date derived from, Date or Date + Time or Appointment?…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Creating a template to print labels
I have just put something together to do this. It involves a label table with 10 links to the name table. There are 10 equivalent formula fields that display the 10 labels per page.…
Attachment
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Improve performance: Count records from subtable WITHOUT select statement
@Jacques TUR Very true Jacques
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Improve performance: Count records from subtable WITHOUT select statement
@Jacques TUR @Maria I come from a FileMaker background and was always taught to try and keep these calculations to a minimum. In an invoicing situation I might have the sum of the invoice lines as a…
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Accessing a single line item on an invoice
@Roger in the code let a := 2 item(LineItem,a-1).LineTotal a is a variable to hold the line number. It's not really necessary. LineItem is the array of line item records.…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: acces to array items like with Where fonction
@Jacques TUR @Fred I became a bit curious about all of this so started looking up about sets. What Fred is asking for is the Complement. There is also the Union and Intersection.…
- John_Halls
- 2 yrs ago
- 2
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
@Jacques TUR Worked for me Jacques.
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
@Fred You are right Fred, thank you. You need to put the var v... inside brackets let array1 := [1, 2, 3, 4, 5]; let x := [1, 3]; array1[(var v := this; not x[= v])] Regards John
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Complex Select statement for View
@Mike N. Thanks Mike
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
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
- 2 yrs ago
- Learn and 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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

1 13 14 15 16 17 31

Back to top

Ninox-Documentation

Overview

View all topics