Skip to main content

Ninox-Documentation

Pierre COLLE

Pierre_COLLE

21
0
0

Joined: 09 Oct 2018

My Posts

Latest Posts

Re: Thousands Separator
Well done Nick !!! Before : After : And it works : Thank you :) Have a good day
- Pierre_COLLE
- 4 yrs ago
- Get help
- Reported - view
Re: Thousands Separator
No, KO for me, as you can see the selection of Thousands Separator does'nt display "." in the choices, for me ...
- Pierre_COLLE
- 4 yrs ago
- Get help
- Reported - view
Re: Thousands Separator
with these parameters :
- Pierre_COLLE
- 4 yrs ago
- Get help
- Reported - view
Re: Thousands Separator
Hello Jacques, I'm sorry I probably don't manipulate the good function in the good place, but when I do that : I get That :
- Pierre_COLLE
- 4 yrs ago
- Get help
- Reported - view
Thousands Separator

Hi, I'd like to display a amount in € this way : 1.000.000 € (no decimal), but the Format number function doesn't operate, I never get the Thousands Separator.Thanks
- Pierre_COLLE
- 4 yrs ago
- 8replies
- 1,314
- Get help
Re: Formula for age calculation
Hello Nick, this morning I just moved my Birth years datas from text field to numbers field, my original mistake ;) Then I applied your formula, and it works perfectly, thanks a lot.…
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
Hello nick, still no ;)
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
I'm confused I can't make it work :( I have 3 fields : - BirthYear : 4 numbers - Birthdate0101 : a calculating field with this formula : date('BirthYear', 1, 1) - Age :…
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
I'm confused I can't make it work :( I have 3 fields : - BirthYear : 4 numbers - Birthdate : a calculating field with this formula : date('BirthYear', 1, 1) - Age :…
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
Its not a date it is just a Year (####)
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
not working, thanks anyway
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
Hello NINOXUS, I probably miss the simple age calculation, before the display points ;) I actually have 2 fields : TheBirthField (full) & TheAgeField (empty).…
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Re: Formula for age calculation
Great !! I try that soon. Thanks a lot !! :)))
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Formula for age calculation

Hello I need to roughly calculate age of persons : (ThisYear : is there a fonction about that or do I have to put '2019' in text?) - ('TheBirthField') What is the formula for this ?…
- Pierre_COLLE
- 5 yrs ago
- 20replies
- 5,300
- Get help
Re: Delete Button for active record
EDIT : OUPSSSS sorry I just saw I could select a record with the global search and use ... the trash up right :) :) :)
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Re: Delete Button for active record
EDIT : global search results (up LEFT)
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Delete Button for active record

Hello I need a button with a formula that DELETE the active record (and his links) In my DB, I have many contacts in double, triple, from different imports ...…
- Pierre_COLLE
- 5 yrs ago
- 3replies
- 1,785
- Get help
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
Wunderbarr !! Thanks ;)
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
Thank you Sean. So I tried with let ENTITESId := (select ENTITES).Id;let ENTITESText := (select ENTITES).'E.SIREN';ENTITESText := unique(ENTITESText);let ENTITESCnt := count(ENTITESId);…
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
Hello, I need to link 2 existing tables : x records of table "SITES" (=offices, local adress etc.) with 1 record of table "ENTITIES" (=companies) massively if possible,…
- Pierre_COLLE
- 5 yrs ago
- Get help
- Reported - view

Back to top

Ninox-Documentation

Overview

View all topics