Discussions

Expand all | Collapse all

Text fields behavior with quotes and other symbols

  • 1.  Text fields behavior with quotes and other symbols

    Posted 01-22-2020 08:10
    I have a text field and I can't quite figure out when this happens, but sometimes it changes a quote (") symbol to &#65533. And sometimes if I have a lookup field, it changes it to a little square.

    I can't get it to happen consistently, so I am not sure exactly the combination of things needed to make this happen. Also, these seem to be unrelated. Meaning, sometimes a quot enters just fine, other times it comes through as the &#...

    Sometimes it looks up fine, and sometimes it comes through as a little square. 

    Anyone know what is happening? I'm unclear so far if it only happens with the quote, or if something else triggers it.

    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: Text fields behavior with quotes and other symbols

    Posted 01-22-2020 08:18
    There are different kinds of quotes.   There are straight quotes and curly quotes.  Quick Base may not be able to handle some kinds of quotes quotes copied and pasted in (ie not typed) or imported.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Text fields behavior with quotes and other symbols

    Posted 01-22-2020 08:47
    Hmmm. Thinking in that direction, it's possible it happens when loaded from phones and maybe phones use different default keyboards with different fonts... will try to troubleshoot and report back.

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 4.  RE: Text fields behavior with quotes and other symbols

    Posted 01-22-2020 09:29
    Confirmed. Mobile devices must all use different fonts, most of which are not compatible when typing a ". Most notably, the Ipad Mini which we distributed to our techs to use, lol. Maybe there is an IPAD setting where you can choose a more standard font. Ill look into it.

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 5.  RE: Text fields behavior with quotes and other symbols

    Posted 01-22-2020 09:40
    right, you I realize that you would never be able to train the users, but if they hold down the " they get all the different flavors of quotes.  

    We can probably make a formula or an Automaton to substitute the correct quotes for the bad quotes.  maybe contact me off line.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------