John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

Re: How to Calculate Cumulative Sum
@Rafael I don't think this is a bug, just a limitation. Ninox would grind to a halt if all select statements fired without some reason and so, in a formula field,…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
Hi both, I hope you don't mind me saying bit I'm not sure it is a good idea to have a select statement in a formula field let t := this; sum((select COST_W)[Week <= t.Week].…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
I had worked something out along Fred's lines, which can be adapted to your needs. If your table looks like this Where the closing balance is opening balance plus adding less subtracting.…
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Multiple Choice Field - How to get possible values/choices
This is a similar question https://forum.ninox.com/t/p8hb6tq/set-choice-value You could adapt the script to meet your needs
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Formula field not displayed in table view
Hi Jarno The select statement will always return an array, even if it only finds one record. Try using first() let a := Medewerkers.'Woon-werk afstand'; first((select 'Barema B' where Afstand = a).…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Auto create record on first day of the new year
@Michael No worries!
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Auto create record on first day of the new year
Hi Michael @Michael said: One way I'm thinking that this could work would be to add the formula to "trigger on new record" part of my invoice table that first checks if a record exists for the…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: Send reminder SMS
@Cirugia Toracica If you did decide to use a timed script then have a look my simple step-by-step guide here https://forum.ninox.com/t/x2hbzyb/timed-scripts
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: List field content using rsort()
Try using Fred's test code in a view 'Folha de Ponto'['Data FL_CX'.Data >= myStartDate and 'Data FL_CX'.Data <= myEndDate] This should bring up a list of records which you can then adjust to just…
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 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

1 14 15 16 17 18 33

Welcome to the Ninox community

John Halls

My Posts

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: How to Calculate Cumulative Sum

Re: Multiple Choice Field - How to get possible values/choices

Re: Formula field not displayed in table view

Re: Auto create record on first day of the new year

Re: Auto create record on first day of the new year

Re: Send reminder SMS

Re: List field content using rsort()

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???!?!?!?

Overview