首页 > 代码库 > SuiteScript > RecordType internalID采集步骤与结果
SuiteScript > RecordType internalID采集步骤与结果
当你碰到一个有很多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‘
Enjoy~
SuiteScript > RecordType internalID采集步骤与结果