Needing to copy and paste one field record into an empty column, and replace all instances of " " with "-"

[Christopher_Hac]

Hey everyone! I’m trying to create a script that will read whatever content is placed into the first column “Product Title” and create a url handle out of it. I’m just looking for it to copy whatever record is under “Product Title” to “Handle” and replace all instances of spaces with “-” instead. Thanks so much!

[Alexey_Gusev]

Hi,

use formula SUBSTITUTE(“Products title”, " ", “-”).
then turn formula field in Text(if needed)

or (if exactly script needed) use mine from here, change field names, add replacement to
rec.getCellValue(‘ source ’)

rec.getCellValue(‘ source ’).replace (/ /g,"_");
(g means all occurencies)

How Can I delete cells-value in specific field Scripting app

I wanna delete cells-value in Amount Field. I am referring to this↓ but I can’t.参考にしています I wanna just all clear Amount field Value… help me. //get table let merchandiseTable = base.getTable("C_商品"); let fieldAmount = merchandiseTable.getField("amount"); let merchandises = await merchandiseTable.selectRecordsAsync(); let merchandise = merchandises.records; //console.log(merchandise); //Amaount-fields value to null while (merchandise.length > 0) { tmp = merchandise.slice…