Concatenation with condition

#1

I have to columns namely “ID_Siswa” and “ID_Kota” like picture below.
I have a column too namely “NRP_Siswa”, this column represent concatenation both “ID_Kota” + “ID_Siswa”. But between “ID_Kota” and “ID_Siswa”, it must be number format “31184000000”
I try to use this syntax:
IF (‘ID_Siswa’) < 10 THEN SET (‘NRP_Siswa’) = CONCAT(field(‘ID_Kota’), ‘31184000000’, field(‘ID_Siswa’));
ELSEIF (‘ID_Siswa’) < 100 THEN SET (‘NRP_Siswa’) = CONCAT(field(‘ID_Kota’), ‘3118400000’, field(‘ID_Siswa’));
ELSE SET (‘NRP_Siswa’) = CONCAT(field(‘ID_Kota’), ‘311840000’, field(‘ID_Siswa’));
END IF;

But, it shows me that the syntax is error :frowning:
Anybody can help me, please?

mockaroo
mockaroo1841×698 71.2 KB

#2

I think this is what you are looking to do, please check it out: https://mockaroo.com/14620c70

Updated formula:
if field('ID_Siswa') < 10 then concat(field('ID_Kota'),'31184000000',field('ID_Siswa')) elseif field('ID_Siswa') < 100 then concat(field('ID_Kota'),'3118400000',field('ID_Siswa')) else concat(field('ID_Kota'),'311840000',field('ID_Siswa')) end