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
Find and Replace a Character in a Paragraph Text Entry Value
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.
July 21, 2017 at 11:33 am
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? ,
July 21, 2017 at 11:38 am
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.
July 21, 2017 at 11:39 am
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.
July 21, 2017 at 11:40 am
I can try HTML entity and see if it passes through Zapier into Sheets though.
Discussion closed.