Support » Plugin: CF7 Google Sheets Connector » Various-length “text” that starts with 0

  • Resolved AdventDeo

    (@adventdeo)


    Hi, great plugin, bought the premium and loved it.

    I have one issue.

    My form is a thorough registration form and asks for several phone numbers. In my country, the cell phone numbers start with zero, and it can be 10 digits, 11 digits, 12 digits, etc.

    I saw a thread in this forum stating a similar problem and your solution was to format the cells within the Google Sheets.

    Since it’s various length, I used “@” instead of “### ### ###”… @ works fine when I manually enter string of numbers starting with 0, the number saves just fine.

    However, a new data just came in, and it didn’t register the 0 again… This seems to me that the problem with accepting 0 as a start of a string or not is not within the Sheets excel, but how the data is formatted when saved on the excel?

    Let me know if you have a way to verify this or not…

    Thank you so much in advanced, and keep up the great work! Really happy with your plugin…

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.