John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: Concatanate - Two For loop -
Not checked but this should work. Notice how much shorter this format is... let check := dialog(" ATENCION ", " ¿Confirma el SETUP de la tabla de AVANCES_PROYECTO ? ", ["Si", "No"]);…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Concatanate - Two For loop -
Loops can be arranged one after another, or nested one inside another. It all depends on your use case.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Production: should storage tanks share a table or each have their own?
@Alex Mumm Good find Alex.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Join without empty lines
Hi Gianluca A different take would be let a := ["One", "Two", "Three"]; let b := ['Yes / No', 'Yes / No 2', 'Yes / No 3']; let c := ["x"]; let i := 0; for d in b do if d then c := array(c, [item(a,…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: POS System ( Sales,Income,Expenses,Stock,Supply)
@Paul Chappell @Bruno Skëndaj Hi Bruno. Paul is right. I wouldn't take this as any form of criticism, embrace your newly found knowledge. Much of the pain you are feeling with your development will…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Formula Problem
Once you have checked for =0 or >0 then all that's left is <0 so you can simplify this code to if Schedule_V > 0 then styled(" AHEAD OF SCHEDULE ", "white",…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: When to use "do as server"?
@Mel Charles Thanks. No I haven't mentioned it to support, it was code I was testing out for someone on the forum, so it's not being used in a production environment.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Suggestions from May 2022
@Rafael No idea! This is a thread for suggestions, not solutions. Sorry...
- John_Halls
- 3 yrs ago
- Learn and share
- Reported - view
Re: When to use "do as server"?
@Mel Charles Hi Mel, I ran into an issue which gave different results here https://forum.ninox.com/t/m1hbwv5/client-vs-server-script-differences Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
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
- 3 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
- 3 yrs ago
- Learn and share
- Reported - view
Re: Suggestions from May 2022
A calendar as a view, and as a layout element
- John_Halls
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: Improve performance: Count records from subtable WITHOUT select statement
@Jacques TUR Very true Jacques
- John_Halls
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Learn and share
- Reported - view
Re: Complex Select statement for View
@Mike N. Thanks Mike
- John_Halls
- 3 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
- 3 yrs ago
- Learn and share
- Reported - view

1 16 17 18 19 20 34

Welcome to the Ninox community

John Halls

My Posts

Re: Concatanate - Two For loop -

Re: Concatanate - Two For loop -

Re: Production: should storage tanks share a table or each have their own?

Re: Join without empty lines

Re: POS System ( Sales,Income,Expenses,Stock,Supply)

Re: Formula Problem

Re: When to use "do as server"?

Re: Suggestions from May 2022

Re: When to use "do as server"?

Re: Production: should storage tanks share a table or each have their own?

Re: Suggestions from May 2022

Re: Suggestions from May 2022

Re: POS System ( Sales,Income,Expenses,Stock,Supply)

Re: Not Displaying Appointments on Mondays???!?!?!?

Re: Report Writer

Re: Not Displaying Appointments on Mondays???!?!?!?

Re: Creating a template to print labels

Re: Improve performance: Count records from subtable WITHOUT select statement

Re: Improve performance: Count records from subtable WITHOUT select statement

Re: Accessing a single line item on an invoice

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: Complex Select statement for View

Re: acces to array items like with Where fonction

Overview