[Impr] Code generator formula improvement

sashavmorozov / vlocity-epc-on-steroids

Vlocity EPC on Steroids allows boosting EPC configuration speed by uploading configuration from spreadsheets into Vlocity data model

5 stars 0 forks source link

[Impr] Code generator formula improvement #156

Closed sashavmorozov closed 4 years ago

sashavmorozov commented 4 years ago

=IF(D42<>"",REGEXREPLACE(Settings!$B$2&"_"&"PICKLIST_VALUE"&"_"&REGEXREPLACE(UPPER(JOIN("",ArrayFormula(IFERROR(VLOOKUP(SPLIT(REGEXREPLACE(D42,"(.)","$1~"),"~"),'Diacritics Dictionary'!$B:$C,2,0),SPLIT(REGEXREPLACE(D42,"(.)","$1~"),"~"))))),"\_{2,}","_"),"_$",""),"")

Add

Spread across other tabs

Better support of "-"
Cut off of trailing "_"

sashavmorozov commented 4 years ago

Added into the spreadsheet (across tabs)

Release notes: a couple of entity code generation improvements implemented:

Entity code prefix is now retrieved from the "Settings" tab
Trailing "_" issue is fixed
Missing "-" issue is fixed