Question

Decimal disappears from Form

Forms

Updated November 27, 2016

asked on November 21, 2016

Good day,

We have a form which does a lookup to a SQL and populates a table. The initial user submits the form to their manager and HR to approve.

Often when the form gets to HR, the number lookup loses the decimal and displays the number incorrectly. The javascript which calculates the total still displays the correct total.

If the form is returned to the user, the incorrect still show and the total is still correct. It seems to be just a display issue, not an actual value or data issue.

It is the same form across all tasks with the HR and Manager one being read only. I have attached screen shots showing the different scenarios.

Thanks

Ian

Incorrect Numbers.PNG (25.96 KB)

| Download

Correct Numbers.PNG (156.34 KB)

| Download

0 0

Replies

replied on November 22, 2016

I can't reproduce this issue. Why the decimal in the table is "," while the decimal out of the table is "."?What the language of your browser? Do you have any customized JavaScript to change the decimal?

0 0

replied on November 22, 2016

Good day Xiuhong,

The "," is the format our Forms server displays currency while "."is the format our SQL captures decimal data.

It is English (Chrome). The only Javascript running is for the calculations of the fields out of the table. There is a CSS class to move the values to the right of the column ".right input {text-align: right;}"

I also cannot reproduce this but in production, it occurs.

Regards

Ian

0 0

replied on November 24, 2016

Hi Ian,

Can you give more details on the form? Is the amount field a number or currency field? How is the field configured?

And the number format on Forms should not be affected by Forms server display format, as it should only follow browser locale. When user submits the form, is it "." or "," displayed on the field? Is your Forms server OS in a different language? How did you configured the currency format?

Also I noticed that the "Total" field has different decimal place in the two pictures. Did you use two forms with different field settings in the process?

0 0

replied on November 25, 2016

HI Rui,

The amount field is a currency field and the only configuration or changes from the norm is a CSS section to move it to the right of the column. The form has a table which is filled with data from a SQL table.

The form is submitted by a staff member to a manager who approves it and then HR approves. This issue has only occurred at the HR stage and if the form is sent back then the data displays incorrectly for all members of the process.

The forms server is not in a different language. The currency format in SQL is decimal (18,2)

It is screen shots from the same form just in different stages of the process.

Thank for assisting and please let me know if there is anything I can clarify. This issue is not consistent and is difficult to recreate

0 0

replied on November 27, 2016 • Show version history

Since both browser and forms server are in English, the decimal point should not be "," at all. So your picture "Correct Numbers.PNG" actually is not correct. And I guess that's why decimal point disappears from HR form: Forms won't treat "," as decimal point so it gets removed.

When the issue did not happen, what is the decimal point? If it keeps showing "," then it should be a bug. If so, can you open a support case on that? We need details (form and lookup results) for how to reproduce the issue.

0 0

replied on November 27, 2016

Hi Rui,

When using a number field with 2 decimal places, the number displays a ".". As currency does not have the option for decimal places, this is how it inserts the data from SQL where the data has 2 decimal places.

I shall open a ticket.

Regards

Ian

0 0

You are not allowed to follow up in this post.

Question

Question

Decimal disappears from Form

Replies

Sign in to reply to this post.