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: 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: AGE function
Did this work for you?
- John_Halls
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: YES/NO use like to show / hide table element
Hi Mamuka If your code is in the Display field only, if: section 1. You don't need to format the dates in you code 2. Your field is probably called 'Yes / No' 3.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Restriction of rights for users
Thanks Mamuka I'll be in touch. Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Restriction of rights for users
Thanks Mamuka I'll be in touch. Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Restriction of rights for users
Hi I'm happy to have a look at this. Please contact me via this form https://forms.gle/uhHydUCjqCqHEjWEA if you want to work together on a shared database. Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: AGE function
It's less readable but this can be shortened to function ageYM(date : date) do let months := (year(today()) - year(date) - 1) * 12 + 12 - month(date) + month(today()) - number(day(today()) <…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: AGE function
That code was fundamentally flawed plus it doesn't take into account the day of the month. Here is my code function ageYM(date : date) do let xDate := date; let fullYears :…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view

1 21 22 23 24 25 31

Back to top

Ninox-Documentation

Overview

View all topics