Skip to main content

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’);


console.log(day);

//

But I don’t know how to put field names in the code!

and also I want the result, entry in jalali field.

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=>q.records.map(r=>({'id':r.id,'fields':jal(r)})))

while(upd.length) await table.updateRecordsAsync(upd.splice(0,50))```

Reply


Terms & Conditions