Show/hide text field if certain words in another text field

Forum|Forum|7 months ago
August 17, 2025
1 reply
236 views

I would like to show a text field if the words "accrued dividends" are typed into another text field. To complicate things, the words "accrued divedends" could be typed into one of 33 different text fields. The 33 text fields are named B1, B2, B3...B33. Thanks.

Correct answer Nesa Nurani

As a custom calculation script of the field which you want to show/hide use this:

var show = false;

for (var i=1; i <=33; i++) {
 var f = this.getField("B" + i).valueAsString;
  if (f && f.toLowerCase().indexOf("accrued dividends") !== -1) {
   show = true;
    break;}}

event.target.display = show ? display.visible : display.hidden;

Nesa Nurani

Correct answer

Community Expert

As a custom calculation script of the field which you want to show/hide use this:

var show = false;

for (var i=1; i <=33; i++) {
 var f = this.getField("B" + i).valueAsString;
  if (f && f.toLowerCase().indexOf("accrued dividends") !== -1) {
   show = true;
    break;}}

event.target.display = show ? display.visible : display.hidden;