John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

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
Re: AGE function
I have double checked the code as written and I am sure I have copied it out correctly but I have been testing it and I am getting some odd behaviour. I wouldn't use this code just yet!
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: AGE function
Hi You need to put your global function in the Global script definitions section, found under the Options tab The script from the video is this (screenshot taken from the video) Here is that code…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: AGE function
Hi If you tell me what ageYM does I am sure I can re-create it for you. Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Using formatted name as form header
Hi Michael Create a formula using SpeciesName in the formula. Formula fields have a Style option and you can change the font size to Large or Very large Regards John
- John_Halls
- 3 yrs ago
- Get help
- Reported - view
Re: Use Update Trigger to Chnage the value in Linked Record
On reflection I would add a Yes / No field to your Main Category (English) table. Call it Disposable and set it to Yes where Product Type (English) s "Cups", "Napkins - Christmas", etc.…
- John_Halls
- 3 yrs ago
- Get help
- Reported - view

1 23 24 25 26 27 33

Welcome to the Ninox community

John Halls

My Posts

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

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

Re: Restriction of rights for users

Re: Restriction of rights for users

Re: Restriction of rights for users

Re: AGE function

Re: AGE function

Re: AGE function

Re: AGE function

Re: AGE function

Re: Using formatted name as form header

Re: Use Update Trigger to Chnage the value in Linked Record

Overview