Re: Jalali Convert date in scripting

567 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I want use scripting app for convert gregorian calender to jalali calender.
I have a field named as ''date" for Gregorian and an empty field named as"Jalali" for result of code.
for convert I want use of this code:
let day = new Date().toLocaleDateString(‘fa-IR-u-nu-latn’);

But I don’t know how to put field names in the code!
and also I want the result, entry in jalali field.

1 Reply 1
const table=base.getTable('YOURTABLE');
const jal=r=>({'Jalali':new Date(r.getCellValue('date')).toLocaleDateString('fa-IR-u-nu-latn')})
const upd=await table.selectRecordsAsync({fields:['date']}).then(q=>>({'id','fields':jal(r)})))
while(upd.length) await table.updateRecordsAsync(upd.splice(0,50))```