John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 yrs ago
- 1
- Get help
- Reported - view
Re: leap years
Hi Raphael This is a red herring, nothing to do with 29th February. The days() function takes the difference between two date, not the number of days. days(date(2020,02,01),date(2020,02,…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Converting min/mile
@Sean I've just tested something... Instead of if Miles != null and Miles != 0 then try if number(Miles) != 0 then Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Count Saturdays an appointment ?
Hi Either Copy and paste your function into the Options / Global script definitions section and then in your formua put countDays(DateFrom,DateTo,5) 5 tells it to count Saturdays.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: disappearing formulas
Notion treats all its relationships as N:N. Do you want to show the problem formula?
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: YES / NO Default value
Isn't that the same as having one record which can be updated each day as necessary? Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: disappearing formulas
Is that correct Fred? I thought all the relationshipes were 1:N Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: disappearing formulas
Can you let us see this formula? It my well be something quite simple that is going wrong. Thanks John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Count Saturdays an appointment ?
Hi I have created this function which takes the start date, end date and weekday ( where 0 is Monday and 6 is Sunday) function countDays(dateFrom : date,dateTo : date,dow : number) do let countDays :…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Haywire formulas while duplicating a table
Could you develop an alternative stragegy, to maybe archive a section of a table periodically, either by moving records from a live table to an to an archive table and then deleting the archived live…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Count separately positive and negative numbers
If your the amount is held in a field called amount then somewhere in your table include a formula field with max(amount,0) for the positive days and (if you want) min(amount,0) for the negative days.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Should the number of fields be limited for navigation and future editing simplicity sake?
Hi John This is a table of questions. The default ones will automatically be added to the reord Here is a record with the question and answers And this code in the Trigger on create adds the default…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Should the number of fields be limited for navigation and future editing simplicity sake?
Hi John It might be worth creating a table linked to the parent, with two fields, Question and Answer. The Question can be a Dynamic Choce field for consistency if you wish.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Trigger additional field is a condition is met.
Hi John You can also show and hide a tab in the same way, so you additional set of questions could all be shown under a tab. You would only need to show or hide the tab, not each field. Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: How to update automatically "Trigger after update" option of a field?
Hi Romain There is nothing you mention in your reply that makes me think you need a trigger to get your dashboard to work. Can you post the code in your trigger? Thanks John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view

1 24 25 26 27 28 34

Welcome to the Ninox community

John Halls

My Posts

Re: Help with SELECT query needed!

Re: Why is the date wrong?

Re: Table - trigger after update being ignored

Re: Update only some some children

Re: Log base other than 10

Re: Purging Job History

Re: syntax "last(select table)" issue

Re: stumped

Re: Filtering a view

Re: Count Saturdays an appointment ?

Re: Filtering a view

Re: leap years

Re: Converting min/mile

Re: Count Saturdays an appointment ?

Re: disappearing formulas

Re: YES / NO Default value

Re: disappearing formulas

Re: disappearing formulas

Re: Count Saturdays an appointment ?

Re: Haywire formulas while duplicating a table

Re: Count separately positive and negative numbers

Re: Should the number of fields be limited for navigation and future editing simplicity sake?

Re: Should the number of fields be limited for navigation and future editing simplicity sake?

Re: Trigger additional field is a condition is met.

Re: How to update automatically "Trigger after update" option of a field?

Overview