swiss number format

[paulkauz]

How can I create following format: CHF 9’956’000
In the Form it's possible to exchange the $ trough CHF, but how can I change the 1.000 trough 1'000

[Janusz]

In browse form for example you can use Format:

FORMAT(ofe_cena,2,'rm_CH')

swiss.png

[paulkauz]

Thanks for the proposal, but where can I put that Format in?

[Janusz]

Put it in the
From / Browse / Display field
for example if you have there: ofe_cena
then replace with: FORMAT(ofe_cena,2,'rm_CH')

(this is OK with MariaDB)

[kev1n]

BTW, "rm_CH" is the ICU Locale of “Romansh (Switzerland)
You might want to use "de_CH" instead (even though the grouping separator is ' for both of them)

[paulkauz]

thanks so far and what about the edit part of a form?
how can I set there the right format?

BR Paul

[Janusz]

Hi,
Please find enclosed short movie how you can add your own format.
https://drive.google.com/file/d/1wzEzVw ... sp=sharing

[paulkauz]

Perfect, I'll try that and I'm sure it will work.

[kev1n]

Here's another solution (Advantage: No JavaScript required)

Run this query in your database

Code: Select all

INSERT INTO `zzzzsys_format` (`zzzzsys_format_id`, `srm_type`, `srm_format`) VALUES ('5f4759ef6e2cec9', 'Number', 'CHF 1\'000.00');

Then replace the function nuPunctuation() in nucommon.php with this one:

Code: Select all

function nuPunctuation($f){

	$c			= '';
	$d			= '';
		
	if(strpos($f , '1,' ) !== false){
		$c		= ',';
	}

	if(strpos($f , '1.' ) !== false){
		$c		= '.';
	}

	if(strpos($f , '0,' ) !== false){
		$d		= ',';
	}

	if(strpos($f , '0.' ) !== false){
		$d		= '.';
	}

	if(strpos($f , '0\'' ) !== false){
		$d		= '\'';
	}
	
	return [$c, $d];
	
}

PS: Other changes will have to be done in nuAddFormatting() to make it work with negative amounts.

[paulkauz]

Thanks for the quick help. It works like a charm on forms and I really appreciate it.
The solution with the new code in function nuPunctuation($f) does not work on reports.