Fillable Form Population - Conditional Formatting

Forum|Forum|5 years ago
December 7, 2020
1 reply
862 views

Hello, I recently created a fillable form that integrates with a Smartsheet product. How do I apply conditional formatting to color code a text field auto populated from a different application (ie, "Red" = change fillColor to color.red, "Yellow"=change fillColor to color.yellow, etc.)

Any help you can provide is greatly appreciated.

Edwina -

This topic has been closed for replies.

try67

Community Expert

As the field's custom calculation script you can add something like this:

if (event.value=="Red") event.target.fillColor = color.red;

if (event.value=="Yellow") event.target.fillColor = color.yellow;

etc.

If the data is imported from an external source you would need to add a command to execute all of these scripts when the file is opened, by adding this code as a doc-level script:

this.calculateNow();

E

Edwina5FF7Author

Participant

Hi, thank you for the feedback. Yes, you are correct, data is imported from an external source. Following are the changes I made to my original script:

Unfortunately, the fill color did not change per my criteria. Please advise.

try67

Community Expert

After importing the data you have to re-open the file.

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