jonhs

A zip code can look like any of these:
00123
01234
12345

A phone number can be:
09 12345
+3585012345
0501234567

Therefore we can’t predict if the number has any zeros or 1 or 2.

Thanks Abdullah, but I tried all those with no luck.

Plain text format works when typing into the Sheet cell, but stops working when the plugin saves into info the same cell.

Custom number format: I tried different settings, but nothing worked.

The zeros are saved in the sheets-document only if I type ‘00123 in the contact form. Can’t have the apostrophe pre-filled in my forms.

Can’t do anything with Pro version if it has the same problem. Idea is to save all forms into 1 sheet.

Any updates/ideas how to save phone numbers and zip codes without losing the leading zeros when saved in Sheets? Major problem, isn’t it?

Thank you. Can you advice how to insert shortcode in the below code. See placement where it says “SHORTCODE HERE” here:

function square_boxes_shortcode( $atts, $content = null ) {

  $ret = "<p>Text</p>
  <p>Text</p>
<p><strong>Text</strong><br />
<div class='btn-varaa'><a href='https://xxx'>Text</a></div>
<br />
text</p>

  <p><a href='https://xxx'>Text/a></p>

INSERT SHORTCODE HERE

<div class='square-boxes'><div class='square-boxes-wrapper'>";

  $k=0;
  while(the_repeater_field('square_boxes', 'options')) {
    $k++;
    $text = get_sub_field('text');
    $lines = 1;
    $lines += substr_count($text, "<br/>");
    $lines += substr_count($text, "<br />");
    $lines += substr_count($text, "<br >");
    $lines += substr_count($text, "<br>");

    $ret .= "<div class='square-box box-nth-".($k%3)."'><a href='".get_sub_field('link')."'><span class='text lines-count-".$lines."'>".$text."</span></a></div>";
  }

  $ret .= "<div class='clearer'></div></div></div>";

  return $ret;
}

• This reply was modified 7 years, 1 month ago by jonhs.
• This reply was modified 7 years, 1 month ago by jonhs.

Thank you very much!

I have done successful imports in the past, but not anymore.