Skip to main content
AlbertanFireFly
Participant
January 16, 2019
Question

How to highlight fields if their sum is greater than a specified value?

  • January 16, 2019
  • 1 reply
  • 331 views

I have a form that I use for time tickets. It has eight fields (ST 1 - 4, and OT 1 - 4). Question 1: Is there any way that I can have all the ST fields highlight in red if the sum is greater than 8? There is no total column (and I would strongly not like to add one). Related Question 2: can I highlight all the OT fields if the sum of all eight ST and OT fields is greater than 12?

I would prefer to have them highlight as I'm entering data, but I wouldn't be opposed to a Validate button if that's easier.

Also, I have 17 rows, so is there any way to write the validation script as "this row"?

My fields are named Row1.ST1, Row 1.OT1, Row2.ST1, Row2.OT1, etc.

This topic has been closed for replies.

1 reply

JR Boulay
Community Expert
Community Expert
January 17, 2019

Answer is yes, and yes.

Can you share your form or a project model?

Acrobate du PDF, InDesigner et Photoshopographe
AlbertanFireFly
Participant
January 17, 2019

It's in a really rough draft state right now, so excuse it's messiness!

I think this is how to share it?

Adobe Document Cloud