Adding character and number to Record ID
I'm trying to add character and number to Record ID. For example, [Record ID#] = 326. My goal is to create a new formula field to add 'MF' and '00' before it. The final result should look like this MF...
Forum Discussion
Solve it by the following code:
var number Len = Length(ToText([Record ID#]));
Case($Len,
2, "MF"&"000"&[Record ID#],
3, "MF"&"00"&[Record ID#],
4, "MF"&"0"&[Record ID#],
5, "MF"&[Record ID#]
)
var number Len = Length(ToText([Record ID#]));
Case($Len,
2, "MF"&"000"&[Record ID#],
3, "MF"&"00"&[Record ID#],
4, "MF"&"0"&[Record ID#],
5, "MF"&[Record ID#]
)