topic Re: Constraint rule to only input text formatted as ##-#####-## in Attribute Rules Questions

Constraint rule to only input text formatted as ##-#####-##

NikeshPatel — Thu, 16 Sep 2021 20:15:49 GMT

Hi,

I've been struggling to find a reference to enable a constraint attribute rule that only allows users to input text as "##-#####-##" for a specific text field. I'm happy to have the user input this manually or have the dashes automatically put in.

I tried the below:

text($feature.accountname, '##-#####-##')

I'm avoiding creating a new field to perform a calculation rule as I can't really change the schema at this current time due to connected services.

Would appreciate any and all help

Re: Constraint rule to only input text formatted as ##-#####-##

JohannesLindner — Mon, 20 Sep 2021 06:47:54 GMT

Don't do it as constraint rule, but as calculation rule on accountname:

// Calculation attribute rule // Field acccountname // Triggers: Insert, Update if(IsEmpty($feature.accountname)) { return null } var input = Replace($feature.accountname, "-", "") return Left(input, 2) + "-" + Mid(input, 2, 5) + "-" + Right(input, 2)

To ensure that this calculates correct values, you can do a constraint rule that checks for the length of the string:

// Constraint attribute rule // rejects the edit if there are not exactly 9 characters var input = Replace($feature.accountname, "-", "") return Count(input) == 9

Re: Constraint rule to only input text formatted as ##-#####-##

NikeshPatel — Tue, 21 Sep 2021 16:16:35 GMT

Thank you! I did not think to use replace in a calculation.