Create Entity with an ACN Button and add Information to Custom Data field?

[JTRTech]

Try adding a letter prefix. Made some fields with- the other day and didn’t hit this issue, those fields had value like KAH-101

[Memo]

@Manuel

Hello @Memo yes that’s right but no solution atm?

None that I’m aware of. Use the mask workaround Jesse mentioned for the time being.
I do the same for our tax numbers:

[Jesse]

I think this is a Microsoft issue. It does the same thing in other Microsoft apps. I think the framework we use is causing it. I will add it to our Redmine tracker.

[Manuel]

Hello @Jesse the problem is that the number sometimes is longer or shorter but the end will always be the same. Like 1234567-8 or 12345678-9

[Jesse]

You can set a mask for that.

[Manuel]

And how it can be done?

[Jesse]

Entity Custom Data Field Formatting Masks

##Entity Custom Data Field Format using Masks## 0 Digit, required. This element will accept any single digit between 0 and 9. 9 Digit or space, optional. # Digit or space, optional. If this position is blank in the mask, it will be rendered as a space in the Text property. Plus (+) and minus (-) signs are allowed. L Letter, required. Restricts input to the ASCII letters a-z and A-Z. This mask element is equivalent to [a-zA-Z] in regular expressions. ? Letter, optional. Res…

[Manuel]

How would this be set it up

it works like -0 but i need 0000000-0 for example
i need at least 7, 8 or 9 digits befor that…

[Jesse]

I think our problem is we do not have the ability to turn on Right to Left matching. Can you change your number format so its

That would output 1-23423423 or 2-234234 for example.

Be sure and set Mask Type to Regex

[Manuel]

thanks @Jesse but thats not working for me i will think how to do that… its a special number here in my country with a “-#” at final.

But can y show on a printer template it this way? ########-# with 7,8 or 9 digits before?

[Jesse]

Try this:

See if it doesnt convert it to date.

That should allow you to use the - and it wont convert to date.

[JTRTech]

could you prefix with a letter behind the scenes since your using ?prompt
And then slice the letter off on print template if needed?

[Manuel]

Thanks @Jesse but it converts it into date

[Manuel]

hello @JTRTech how do you mean that?

you mean here?

[Jesse]

@Manuel

Thanks @Jesse but it converts it into date

Thats a shame. I dont think we will have a solution for this anytime soon.

[Jesse]

You may need to rethink your numbering scheme. Or use a character other than -

My guess is both - and / will cause the issue.

[JTRTech]

Sure i saw you were using ?prompt earlier.
If you put say A[?Prompt] it should prefix with a letter.
Just try that for now, sure a letter will stop the conversion since I have fields with - and numbers with with letters infront and havnt seen this issue.

[Manuel]

how i can write that right?
but the thing is that sometimes the number has a - sign and sometimes not

[JTRTech]

How are you entering the number?
?Prompt right

So
A[?RUC/CI]

[Manuel]

yes but sometimes the number will be a simple number and other times it will be 1234567-8