John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

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
Re: How to update automatically "Trigger after update" option of a field?
That error message is correct, you can't use a formula to change values elsewhere, only its own value. What Steven means is to use formula fields in place of the fields being updated in the trigger.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Formula for colour change
Hi Use a formula field instead of a color field and include this code styled("", if today() > 'membership expiry date' then "red" else "green" end) Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: YES/NO use like to show / hide table element
Hi Mamuka As with Alain's solution, you need to move this away from an array to a boolean result, so include the max function max((select GM)[DATE = c].'Yes / No 2') Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: AGE function
Did this work for you?
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: YES/NO use like to show / hide table element
Can you send me a screenshot of the code. If you can als send a screenshot of the two tables concerned that would help too, plus the Data model (how they are joined together) Thanks John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view

1 23 24 25 26 27 33

Welcome to the Ninox community

John Halls

My Posts

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?

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

Re: Formula for colour change

Re: YES/NO use like to show / hide table element

Re: AGE function

Re: YES/NO use like to show / hide table element

Overview