Is there a way to hide the first 4 characters of a field in a portal using conditional formatting?
You can try making them white or the color of the backgroung(if the field is not editable) or you can create a calculation field with cases to match your requests when you want to hide/show first 4 characters
Yea, thought about changing their color but then the rest of the data in the field looks like its almost middle justified.
can you have two field objects, where both of them have hide object statements reflecting your conditional. maybe for the object that meets your condition you can adjust the layout right padding to "push" the text over.
though I am not sure if you can push the text out of the left side bounds
edit** nvm you want color changes. same idea but layer the conditionally formatted field object over top of the normal object and hide when it is false.
I needed to do something similar, showing the last four of a number for verification. I found the easiest approach is a second field that is a calculation that presented the last four characters. In your case, have the calculation strip the first four characters. Then it will present properly (not looking justified) without any other trickery. Note, this isn't an unstored calculation.
Something like this: Middle ( field ; 5 ; 100 )
Will give it a try.
Short answer: no. Conditional formatting is applied to layout objects, not to individual characters in a field.
You could have a calculation field returning all but the first 4 characters of the field, and hide/show either the real field or the calculation field, based on the condition. There is probably a better solution to be found, if you tell us what the purpose of this exercise is. Offhand, it sounds like those 4 characters belong in a separate field to begin with.
Maybe this way would work (attached)?
Michael said, "Offhand, it sounds like those 4 characters belong in a separate field to begin with." I agree though ... the answer might be best to split that data.
You would want to disallow entry into that PLACEHOLDER as well as set its style to black like the regular text.
Retrieving data ...