+1 Same issue for me, tried formatting the column as plain text but keeps reverting to automatic
Thread Starter
andomp
(@andomp)
i’ve used a workaround
$( “#sndcntfrm” ).click(function() {
var phone = $(‘input[name=”your-phone”]’).val();
if (phone.startsWith(‘0’)) {
$(‘input[name=”your-phone”]’).val(“.+39″+phone);
}
});
sndcntfrm is the contact form submit button id.
The dot before international prefix is for Google Sheets
requirements (https://webapps.stackexchange.com/questions/33202/how-to-set-a-google-docs-spreadsheet-cell-format-to-bare-text)
I hope this help
Hello @andomp @samwired
It looks like there is an issue with the Google sheet formatting, you can set the column as an plain text and it will work perfectly,
Already tested on our development server and looks everything is working perfect,
let us know if still you have any issue..
Thanks
Abdullah
