Skip to main content
X
XAllOutWarX
Participating Frequently
October 3, 2023
Question

Comma Logic for one of many fields with same name.

  • October 3, 2023
  • 1 reply
  • 824 views

Hello there community!

I have been looking for a script that I can put into a text field that places a comma at the end of the text/ string. I found this little bit on another post: if (event.value) event.value+=","; this works 100% but I need to customize it a bit. I have 5 text fields that are identical in name that pull in information from a database but I only need that snippet of logic applied to the first instance of textbox. So, all 5 boxes will populate a client name but I only need comma logic applied to the first box. As it stands now, using just this tidbit in the first textbox produces a comma across all boxes which makes sense.   Any help or advice would be appreciated!

    This topic has been closed for replies.

    1 reply

    try67
    try67
    Community Expert
    October 3, 2023

    You will have to rename this field and copy its value from the others, or vice versa.

      E
      Editha22884063odzg
      New Participant
      October 4, 2023

      Hi, could you please show me step-by-step instructions? I renamed the field and copied the value from the other but it did not seem to work. Thank you so much. 

      X
      XAllOutWarXAuthor
      Participating Frequently
      October 4, 2023

      Take whatever field that you need the comma inserted at the end of the name at and open up you calculation tab in the field properties. I inserted this: this.getField("yourNameComma").value = this.getField("otherFields").valueAsString; in the custom calculation. the "yourNameComma" being the title of the text field that needs the comma appended and "otherFields" being the other fields that you have that need the name but not the comma. Then I went into the format tab in properties of the name field that needs the comma appended and added: if (event.value) event.value+=","; in the custom format script area. Hope this helps!

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