John Halls

John_Halls

Somerset, England

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

My Posts

Latest Posts

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
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
- 4 yrs ago
- Get help
- Reported - view
Re: Restriction of rights for users
Thanks Mamuka I'll be in touch. Regards John
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Restriction of rights for users
Thanks Mamuka I'll be in touch. Regards John
- John_Halls
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 yrs ago
- Get help
- Reported - view
Re: Use Update Trigger to Chnage the value in Linked Record
Hi Matt You don't need to set t because Features is a reference from Products, so your code can become let x := text('Main Category (English)'.'Product Type (English)');…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: use yesterday's information in the table
Always post that litte bit too soon. Just realised the RunningTotal isn't correct. This might have to be scripted but still pretty easy to get going.
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: use yesterday's information in the table
I created a tabe called DaisyChain and made a table reference to itself, one half called Yesterday and the other Today I included a field called Flag. Every record except the latest has been set.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: use yesterday's information in the table
I know Alain has found a solution for you but I'd like to suggest something. If I were doing this I would have a relationship joining yesterday to today created in the Trigger on create section.…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Trying to count using where with child and linked tables data
Replace where code = "C1" with [Code = "C1"] The where and square bracket formats both work with select statements, only the square bracket format works with a relationship field.
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Popup related record
Hi Jan. It's a forum, not support. I like to think that, between us we all provide professional, detailed answers as best we can to all who come here from the simplest of queries to some more…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Select from another table
Hi I suspect the reason you are not seeing anything is that nazwa_p and producent are not exactly the same. They have to match in spelling, capitalisation,…
- John_Halls
- 4 yrs ago
- Learn and share
- Reported - view
Re: Relationship between a table and itself
Having made one relationship Peter - Son - David and noting the that reverse relationship is Father (the Reverse field) the button is creating or updating the second David - Father - Peter Lines 1 -…
- John_Halls
- 4 yrs ago
- Get help
- Reported - view
Re: Using Ninox seems like pulling teeth!
It's not Ninox, it's the problem, which is quite a complex one. I have just posted a solution in response to your request a few hours ago which I hope restores some faith in Ninox.
- John_Halls
- 4 yrs ago
- Get help
- Reported - view

1 25 26 27 28 29 34

Welcome to the Ninox community

John Halls

My Posts

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

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

Re: use yesterday's information in the table

Re: use yesterday's information in the table

Re: use yesterday's information in the table

Re: Trying to count using where with child and linked tables data

Re: Popup related record

Re: Select from another table

Re: Relationship between a table and itself

Re: Using Ninox seems like pulling teeth!

Overview