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: Cross Tab in a Form
In a formula field.
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
Aside from having my rows and cols the wrong way round(!), I now have the formula reduced down to this let a := this; let Rows := unique((List order by Row).…
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
No, the parent table is just a place holder. On a similar, probably better way, this works well in a formula field let a := this; let h := "<table style='width:100%'>"; let b :…
- John_Halls
- 2 yrs ago
- Learn and share
- Reported - view
Re: Cross Tab in a Form
XTab.ninox
- John_Halls
- 2 yrs ago
- 1
- Learn and share
- Reported - view
Cross Tab in a Form

I have come up with a way to cross tabulate a table of values in a form This is the table of values And this is the table I use to create the Cross Tab This code do as server delete XTab; let a :…
- John_Halls
- 2 yrs ago
- 19replies
- 207
- 1
- Learn and share
Re: sum((select......... with two values
Great seeing the progression here...
- John_Halls
- 2 yrs ago
- Get help
- Reported - view
Re: How to Calculate Cumulative Sum
Yes, that's why it works for you. It also works if you only add new records to the end of the list but not if you are inserting records or updating them
- John_Halls
- 2 yrs ago
- 1
- Get help
- Reported - view
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

1 12 13 14 15 16 31

Back to top

Ninox-Documentation

Overview

View all topics