Question

Why is a currency field in Forms restricted to 10 characters?

Forms Version 11

Updated January 26, 2024

asked on January 25, 2024 • Show version history

We have a currency field in Forms and just had someone try to enter a negative value of over 100,000.00. It gives the error "This value is too long. It should have 10 characters or fewer". It counts all of the - , . characters in the 10, so we can't have users enter anything over -99,999.99. If we disable showing the thousands delimiter we gain a digit.

Is there a reason why the currency field is restricted to 10 characters?

We are using Professional Version 11.0.2307.40556 and 11.0.2311.50553.

0 0

Answer

APPROVED ANSWER SELECTED ANSWER

replied on January 26, 2024

You can try to export the process xml and search for the field in question. See if there is any character limit attribute on the field in question

0 0

Replies

replied on January 26, 2024

I'm not getting that error on my side and we are on the same version:

I do not have any css or js on the back end of this form.

1 0

View 4 previous replies

replied on January 26, 2024

Katy, I found your results interesting, so I created a new process and recreated the table and fields in the table, and I do not receive the same error message when adding more than 10 characters, so now I'm confused on what is causing this error. It is a built-in error and not a custom error, so I don't know it was from a previous version that was carried forward. This process is a few years old.

0 0

APPROVED ANSWER SELECTED ANSWER

replied on January 26, 2024

You can try to export the process xml and search for the field in question. See if there is any character limit attribute on the field in question

0 0

replied on January 26, 2024

Zachary, I am seeing a <length>10</length> attribute for that field from the process XML.

0 0

replied on January 26, 2024

if you compare that to your new form without the issue, you can figure out if that attribute is needed. then you can re-import the xml and you should be good

0 0

replied on January 26, 2024

Zachary, the value in the new process is <length i:nil="true" />. This is a rather large process with thousands of active instances. Is there a way we can update all currency fields to have the new value using a SQL query?

0 0

replied on January 26, 2024

Never mind. I figured it out. Thank you for helping narrow it down.

0 0

replied on January 26, 2024

Excellent, in talking with the devs we would have wanted the db option to be a very last resort. Glad you were able to fix it!

0 0

replied on January 25, 2024

Which form designer are you using? Are there any field rules or custom error messages associated with this field? If this is using the classic designer, is there any JS?

0 0

replied on January 25, 2024

Using the Classic Designer. No custom error messages. There is a field rule that affects the table, but not the individual columns in the table. There is JS that affects the table, but not the field in question.

0 0

You are not allowed to follow up in this post.

Question

Question

Why is a currency field in Forms restricted to 10 characters?

Answer

Replies

Sign in to reply to this post.