Jump to content
  • 0

Values displays as ??? in Caspio Table


ArthurLeywin
 Share

Question

Hello,

I am trying to make a school project, creating a simple enrollment app but while testing I encountered thisimage.png.38850bc5364c7b863c82999dd02ec235.png

As you can see, some of the values in my table contains "??". I am not sure if that is because I am using chinese and korean characters for those values? I am using formula field for the Subjects and I want to use it for display in a Reports DataPage.

Anyone knows why this is happening and if there is something I can do about it?

Thanks!
AL

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 1

Hi Arthur.

I found this in Caspio's HowTo Articles: https://howto.caspio.com/function-reference/

I thought it might help you. Check under "Text Functions".  Basically, you will just need "N" before the single quotes that wrap your values in the formula field.

For example:
image.png.2d721f4cbc37bc52c48b94ae7d64e982.png

This way, your values will be converted to NVARCHAR which allows Unicode characters which most other language characters are. This will not affect your normal English characters.

Here is a sample output on the table and on a report datapage:

image.png.45a6d0b70522679f1faf70565db27cd0.pngimage.thumb.png.1414a957cfd960608de516a6c777139e.png


It even works with emoticons/emojis. 

I hope this helps you. Good luck on your project.

~Tubbs

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...