Skip to main content

Ninox-Documentation

John Halls

John_Halls

Somerset, England

756
123
1

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

My Posts

Latest Posts

Re: Dynamic Choice triggers twice
This is my updated code let factor := 0.55555556;let offset := -32;let centid := 2;Valnum := (Valnum + offset) * factor;Unit := centid;Notes := Valnum It still only runs once for me.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice triggers twice
I have re-created your database with your code in the Trigger on update of the unit in the Specs table it works correctly. It doesn't run twice. https://www.dropbox.com/s/z6l95e48r4mxw7v/Specs.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice triggers twice
Hi You haven't by any chance got the code both at the record level Trigger on update and the field level Trigger on update? Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: issue trying to get a table view to work in a non related table
Hi Mel You can go from one relationship to another so create a view in JobDockets and put this line of code Customers.Quotes It goes up to the customer of the JobDocket and back doen to the…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Why Im getting endless loop here?
Hi rene If Slct = Srch doesn't have true answer before Counter becomes larger than the largest Id in Company then Counter will continue to increment for ever and ever.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Search for tables with part of their name or with certain conditions
Hi. How many customers do you have? Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Print limit
Hi Your 6 records are shown in the design of the report but when you print it out it will show all the records correctly. Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Table function
Hi I have checked the order of execution and the field level Trigger after update fires before the record level Trigger after update. This means you could set a flag field at the field level flag :…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Filtering with many arguments in a related table
Hi Leodardo Can you tell me what the tables Report, Report_instruments and Report_spares do? Are they used as dashboards (typically having just a single record)? Thanks John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Child Records – Creating a Virtual List

There are times, when the number of child records of a parent becomes large, that it would be useful to be able to search, sort and aggregate the child records without changing the set-up of the view…
- John_Halls
- 3 yrs ago
- 458
- Learn and share
Re: Help with SELECT query needed!
Hi Agassi Use Alain's solution. Print it out and frame it. @Alain - have you used this technique before? Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Help with SELECT query needed!
That is so impressive Alain, very well done. I have to say that proves just how powerful the Ninox language is.
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Help with SELECT query needed!
Hi Agassi I have a working copy of this, so I know it works. It's not so complex once you break it down into parts. I thought you might have TreatmentsList.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Help with SELECT query needed!
Hi Agassi You need to build a matrix of clients and treatment names and hold the last treatment date. So I have mocked this up using two new tables TreatmentList,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Help with SELECT query needed!
Hi Agassi I've had a really good look at this problem and I don't think it can be solved with a select statement. Regardless of the table you base your select on you will fall short of a solution.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Why is the date wrong?
I had the same issue a few days ago! Not checked it out though. What is today() saying in the console? Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Table - trigger after update being ignored
Hi Mel Swap if FirstName = " " and LastName = " " and GDPR = 3 then for if FirstName = null and LastName = null and GDPR = 3 then Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Update only some some children
Hi From a parent record use this format for a in Child[Date > today() or Date = null] do a.(Date := NewValue)end To loop through all the parent records,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Log base other than 10
Hi From the reference section log(x) – Logarithm of x to the base of 10. log(x, y) – Logarithm of x to the base of y Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Purging Job History
Hi Mel I can't see anything wrong but maybe swap the code round a bit let myDate := 'DeleteDate!';if myDate <= today() - 2190 then alert("Records cannot be deleted less than 6 years for HMRC…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: syntax "last(select table)" issue
Hi Sebastian I would suggest sorting the table 'Currency Rates' := last(select 'Currency Rates' order by Date) Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: stumped
I'm not saying to use it, use Steven's code, but your code should have looked like this let reg := ""; if fasst.Id thenreg := "yes"elsereg := "no"end;reg Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Filtering a view
Hi For each form I create a tab called Hidden, and set it as 'Hidden'. Arrange it as the last tab on the form and place all the fields I don't see to see in that tab.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Count Saturdays an appointment ?
Hi Let's take July 2021. The number of days in the month, 31 is calculated by this line let countDays := days(DateFrom, DateTo) + 1 There are at least 4 days for any day of the week,…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Filtering a view
I know you will tell me it should be simpler than that, but I just want to show that it can be done... Pick a column you know will you will want to display,…
- John_Halls
- 3 yrs ago
- 1
- Get help
- Reported - view

1 20 21 22 23 24 31

Back to top

Ninox-Documentation

Overview

View all topics