Dynamic Fields restrictions and formulas

[philiutr]

Hi Everyone,

1. How can I restrict dynamic text field to accept decimal format only (i.e. 123.45)?
2. How can I create formula/calculated fields using other dynamic fields (i.e. TotalAmount = Quantity x PriceUnit)?

Thanks!

[crythias]

1) regex in the setup of DF. maybe [\d\.]+ or \d+\.{0,1}\d*
2) javascript.

Explanation of [\d\.]+ is
1 or more of digits or periods

\d+\.{0,1}\d* is
1 or more digits, exactly zero or 1 periods/decimal separators, and zero or more digits following the period.

[philiutr]

Great! I'll try this. Thanks!