The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group

Slack Signup
Newsletter Optin
Help Desk

Find and Replace a Character in a Paragraph Text Entry Value

Labels

This Discussion is public

Notifications

I think this can be done with Javascript in the customize html after field section.

Due to the Zapier integration there is a bug where a , inside any text field breaks the ability for Zapier to update Google Sheets.  I need therefore to change a , to a . if someone types a , in the field or somehow restrict so that , is not allowed to be in the submit value.

Does anyone have a sample script code that can work, I scoured over the support site and can't find something that does this, I found one to change currency value but the same logic code didn't work for paragraph text field.

If a user enters a comma and it is a legitimate character for the field, changing it could be a problem for the user, no? Wouldn't it be better to use the HTML entity for a comma? &#044

It may not be proper english, but this paragraph field is mostly people introducing themselves or asking for information.  The fact that a , would turn to a . when it arrives in the field in the sheets is not of concern.

Example,

Hello staff,

I represent XYZ and I want you to review our product.
Sincerely,

Alpha

----

Those comma's are killing Zapier, turning them to . is no big deal.

I can try HTML entity and see if it passes through Zapier into Sheets though.

Discussion closed.