Skip to main content
H
HungryJack619
Participant
July 16, 2019
Answered

Change one textbox based on whether another textbox includes certain characters

  • July 16, 2019
  • 1 reply
  • 587 views

Thanks in advance for everyone's help. I'm using Pro 11.

I'm creating a document template where I need certain textboxes to change based on whether a specific box contains certain text, but where there is still other text in the box. For example, if the primary textbox contains "2019-PR-123" I would like a separate box to return "Product", but if the box contains "2019-LM-123" I would like the separate box to return "Labor". But I want the return values to be only based on whether the primary box contains the "PR" or "LM" irrespective of what the other numbers are.

I've searched and searched and can't seem to find a simple way to do this. And I'm easily able to achieve the result of the primary textbox contains only the "PR" or "LM" using an if/then based on the value of the primary box, but I need it to do an if/then based not on the value of the box but whether the box includes certain text within the large text.

This topic has been closed for replies.
Correct answer try67

This kind of thing is usually done using a Regular Expression.

You can use this code as the custom calculation script of the second text field:

var s = this.getField("Text1").valueAsString; // insert actual field name
if (/PR/.test(s)) event.value = "Product";
else if (/LM/.test(s)) event.value = "Labor";
else event.value = "";

1 reply

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
July 16, 2019

This kind of thing is usually done using a Regular Expression.

You can use this code as the custom calculation script of the second text field:

var s = this.getField("Text1").valueAsString; // insert actual field name
if (/PR/.test(s)) event.value = "Product";
else if (/LM/.test(s)) event.value = "Labor";
else event.value = "";
H
HungryJack619Author
Participant
July 16, 2019

This exactly what I needed, thank you. I think my two problems was that I wasn't using valueAsString for the source textbox, and I didn't realize you could do a /RegEx/.test(s), I kept incorrectly trying to do the test as a standalone function.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices