Comma Logic for one of many fields with same name.

[XAllOutWarX]

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!

[try67]

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

[XAllOutWarX]

Nice! Didnt think of this before. Thank you!

[Editha22884063odzg]

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. 

[XAllOutWarX]

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!

[Editha22884063odzg]

AWESOME! It worked. Thank you very much for your help.