General

Re: Auto Dash for field

tafavorite — Mon, 16 May 2011 15:30:27 GMT

Thank you for your help. This did exactly what I needed. Been of great help, thanks again.

Re: Auto Dash for field

Skarn — Sun, 15 May 2011 22:41:07 GMT

As a rule on the field - setting it's value.

Formula:

concat(substring(translate(., "-", ""), 1, 2), "-", substring(translate(., "-", ""), 3))

================================================================
This formula contains embedded commands:

A = translate(., "-", "")

to remove all existing dashes before processing the current field value.

B = substring(A ,1 ,2)
C = substring(A, 3)

to separate the first two characters and the rest of the current field value into two components.

concat(B,"-",C)

to combine the separated parts together with a dash in between.

Auto Dash for field

tafavorite — Fri, 13 May 2011 17:54:22 GMT

Hello,

I have a request that the owner would like their form to have a field be able to put the dash into this so the user does not have to. What the user has to enter is the following:

AA-1111

So the user should only enter: AA1111 and then a rule should be able to put the dash in the correct spot. I'm not sure how to do that exactly thou. Anyone have a clear method on how to accomplish this. Thanks.