Skip to main content
Question

Connected Table pulling strange characters

  • September 28, 2022
  • 0 replies
  • 129 views
Does anyone know if there is a fix for this, or should I recreate my connected table?

I have a master app containing our customer information. I pull information from this into other apps via connected tables.
The connected table in one of my apps has added extra characters into the middle of the name field for some customers. My other apps are all OK.
The P2P on the end is supposed to be there.

Should read: FAIR FAMILY FARMS         P2P
Reads: 
FAIR FAMILY FARMS LLC                  P2P

This customer is ok:
WES SOLLENBERGER       P2P


------------------------------
Anne Martin
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    If all else fails, you can use SearchAndReplace to make a new formula field and strip out he funny character or replace them with spaces.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Forum|alt.badge.img+5
    • OanaWhalen
    • Registered
    • September 29, 2022
    Did you happen to enter the information on an iPhone/iPad? We've had a lot of issues with importing text entered on iOS apps into QB, as most special characters (including some spaces, tabs, even some normal letters occasionally, etc.) are encoded differently on iOS. Our typical solution has been a long string of SearchAndReplace functions to swap out the odd characters (must copy paste, not retype them) for the intended ones.

    There is also an option under App Properties to toggle UTF-8 encoding, we've had some limited success with changing this setting in the past, but I vaguely recall it causing other issues for us as well.

    ------------------------------
    Oana Toma
    ------------------------------
    Terms & ConditionsAccessibility statement