I am currently building a SharePoint info-path form with the following business cases below:

  1. An overtime form which has two conditions : Emergency and Planned. If Planned, the value of the total hours worked** should not increase until it has been approved by the Line Manager.

Currently the infopath form returns a number and decimal numbers when i return the total hours worked, how can i remove those decimals numbers?

Lastly, If i want the line manager to sign the infopath form when approving, how can i build the electronic signature in SharePoint?

Thank you in advance.


You need to change the column format on the list settings to specify the decimal places you'd like.

| improve this answer | |
  • basically on the infopath, i am displaying the Total Hours worked which must be a number excluding decimal placed. Under View the number is displayed corrently but on the infopath form it has decimal numbers. e.g 8.00000000 – Siphesakhe Aug 26 '15 at 12:21
  • I have hours to be worked, hours already worked and total accumulated hours. When an employee select Planned, i do not want the Hours to be worked field updating the Total accumulated hours before the manager approve it. – Siphesakhe Aug 26 '15 at 12:25
  • Hi Graham, The link above is broken. – Siphesakhe Aug 26 '15 at 12:33
  • Specific to the issue with the adding values based on a specific factor, you can use a calculated column – Graham Aug 26 '15 at 19:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.