UK currency £ sign not showing
Hello,
This stopped working after a system upgrade a couple of years ago. I can type a £ into a field, but when I save the record it shows as £ (not good) or Ł (acceptable, although not quite ...
Forum Discussion
Hi Mark,
Rich text seems to be working perfectly, thank you. Ideally, I would prefer to change field type from multi-line text to multi-line rich text. When I do this, QB comes up with the warning about data loss during conversion.
Can I loose data in this conversion? If so, is duplicating the original field enough?
Thanks again,
Arkady
------------------------------
Arkady
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendYou are likely to loose carriage returns. Suggest that you first copy the multiline text field text field. When you copy a field not only do you copy the field properties but you copy all the data and all the records in your table for that field. So you have a nice way to get a preview of what would happen if you were to change your main field tips in production now.
If there is a pattern where based on the nature of your data you lose certain characters like for example carriage returns then I work around that is to make a formula rich text field which will look for those characters such as
\n (the new line character)
and using SeachAmndReplace change those to <br><br>
So, you keep reworking that search and replace until you like it and then change probably make a COPY of that field the field and then change the formula field to a Rich Text field type.
The main thing that you want to protect is your existing data just in case something goes wrong or doesn't work right the first time so make sure that you never convert your actual production field but only convert a copy of it.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thank you!
------------------------------
Arkady
------------------------------Hi Mark,
This works, thank you. SearchAndReplace does not reliably replace Ł with £, but this doesn't matter as £ shows in exact forms that clients see. And I can now use £ throughout, which is huge help - we had to copy and paste it from other part of the app.
For some reason new multi-line rich text fields ignore specified height and width, but this is not important.
Thanks again,
Arkady
------------------------------
Arkady
------------------------------