format of a field with a formula

Forum|Forum|2 years ago
April 22, 2024
1 reply
781 views

Hi,

I

I am attaching a form with a simple formula in field 20, where we add up fields 10-19.
How do I change the format of field 20 so that '0' does not appear if none of the fields from 10 to 19 are filled ?

Thank you very much for your help !

WS.

test.pdf

This topic has been closed for replies.

Correct answer Nesa Nurani

Use this as custom format script:
if(event.value){
event.value = util.printf("%,2.2f",event.value).toString().replace(/\./gim," ");}

Then use this as 'Validate' script:
if(event.value == 0)
event.value = "";

Nesa Nurani

Correct answer

Community Expert

Use this as custom format script:
if(event.value){
event.value = util.printf("%,2.2f",event.value).toString().replace(/\./gim," ");}

Then use this as 'Validate' script:
if(event.value == 0)
event.value = "";

R

robertb87361850Author

Known Participant

Thank YOU ! ❤🌹🌹🌹🌹🌹

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded