Conditional Formating: Text font

Forum|Forum|1 year ago
October 3, 2024
1 reply
1124 views

Hello! Please help!

The Adobe Form I'm creating is to track money collected. It is subtotaled with a formula to calculate all of the individual payments. There is also a deposit section in which to record the currency, coin, checks, and credit card breakdowns. After the breakdowns are entered manually, there is a formula to calcuate them for the total pay-in amount. The Total Pay-In figure needs to equal the Subtotal figure. I want the text font in both of those fields to turn red is they do not equal one another. Please help! Thank you in advance!!

This topic has been closed for replies.

PDF Automation Station

Community Expert

Enter this custom format script in the Total Pay-In field:

if(event.value==this.getField("Subotal").value)

{event.target.textColor=color.black}

else

{event.target.textColor=color.red}

Change "Subtotal" to "Total Pay-In" and enter the same script as a custom format script in the Subtotal field.

K

Kellie390032568d0aAuthor

Known Participant

Thank you! It works, except after the breakdown amounts are entered
creating the Total Pay-In figure, the Subtotal figure doesn't change back
to black, even though they match.

I caught the misspelling of Subtotal ("Subotal") so that's not the issue.

Thanks again!

*Kellie Shoffner*
Main Campus Main Office, Secretary
( 937.778.1980 x 265 | *Fx* 937.778.4677
<>
www.uppervalleycc.org
8811 Career Drive, Piq
<>ua,
OH 45356
<>
*Online Payments: PaySchools Central <>*
PaySchools Central Support
<>

K

Kellie390032568d0aAuthor

Known Participant

Hello, Nesa!

First attempt: When I copy/paste the second script for just the subtotal field, the Subtotal figure stays red even when the Total Pay-In figure doesn't match. I left the orginally suggested script for the Total Pay-In figure. The figure stayed black.

Second Attempt: The second script was used for both the Subtotal and Total Pay-In figures. In this scenario, the Subtotal figure stays red regardless of matching the Total Pay-In figure. The Total Pay-In figure stays black until it matches the Subtotal figure and then turns red again, resulting in both figures being red even though they match.

Thanks so much for your help!

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.