Remove "#" from field

[nkakad]

Hi all,

I am very new to this software so please bare with me!

I have created a table, and the data is getting populated through binding.  Although the values are coming in correctly, there is a series of '"###".  I am assuming there is a reason they are coming and would love to know the solution on how to remove them!

Thanks in Advance,

Niraj

[Former Community Member]

Niraj, It could be because the width of Column/Row is not enough to display the text. Increase the width and check.

[nkakad]

Hi Pavan,

I tried those things, but it wasnt the issue.

What I ended up doing is putting this in the script editor bar

Show: Calculate 

Input: $.rawValue=replace($.rawValue,"###"," ")

Language: FormCalc

This is something that someone told me to do and it worked.  I am not sure why though!

I do not fully understand the Language FormCalc.

Thanks for the reply though!

[SI_MSD7]

nkakad,

You might want to be careful removing those #. Your instincts may be correct in that they mean something. If I recall, often times binding (using schema) brings over # symbols. Have you tested the process, and is everything working OK re: being able to populate the form?

And just FYI..when you are working with FormCalc you do not need to use ".rawValue".  That's only for javascript (i.e. this.rawValue)...where $ is equivalent to "this" in FormCalc.