Forum Discussion

Qrew Captain

5 years ago

Text fields behavior with quotes and other symbols

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. ...

Tables and fields

Qrew Captain

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
------------------------------

Qrew Captain

5 years ago

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
------------------------------

MarkShnier__You
Qrew Legend
5 years ago
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
------------------------------
- MikeGerrity1
  Qrew Member
  2 years ago
  Does anyone have a formula for stripping out "curly quotes" from text.
  
  A basic searchandreplace does not work because quickbase can't search for curly quotes - but perhaps there is a way to search for the ASCI Character.
  
  This has become an issue for me within Pipelines which fail when transfering text that includes curly quotes or other disallowed characters. I have tried using the jinja "escape" feature ie {{a.content_clean|escape}} but that has not made a difference...
  
  Thanks for any suggestions
  
  ------------------------------
  Mike Gerrity
  ------------------------------