SuiteScript > RecordType internalID采集步骤与结果

时间:2023-12-11 22:53:26

当你碰到一个有很多sub Fields的id需要map到js文件的时候,是不是想到一个个复制到js文件中?建立成Object,library起来,方便不同的module*享。

一个复制,很烦,很浪费时间,有木有?

我想到了使用html页面,可以复制到excel,然后用formula自动处理后,直接copy进js文件,直接就可以使用,很省力!

步骤

1。Go to record type definition page, copy all the context under Fields subtab.

  - Now you have all the html in your clipboard

2。Create a new Notepad/TextEdit, Paste the clipboard to it.

  - Now you got all the information in plain text, in notepad.

3。Select All in Notepad/TextEdit, Copy it again.

  - Got plain text in clipboard

4。Open the excel file, paste in the plain text, you can get result in 'Step2-GotLastID' > Column F.  Details steps inside:  (In Attachment)

  - =MID('Step1-CopyRecordTypeFieldList'!C1,22,100)

  - =UPPER(A2)

  - =CONCATENATE(B2,C2,D2,E2)

5。Result, I.e.

APLY : 'custrecord_pkgspc_ply',

APKGXLCM : 'custrecord_pkgspc_pkgxlcm'

SuiteScript > RecordType internalID采集步骤与结果

Enjoy~