Skip to main content
Solved

how to add dashes to a text GI?


Hi everybody.

I’m trying to modify a GI but i cannot get it to work the way i want.

what I want is for this column to be displayed as the "mold" column (with dashes)

 

Best answer by dcomerford

You can use the Concat and Substring to do it by clicking on the pencil on the data field. Example below I am taking 1st 2 characters of InventoryCD and then adding 2 dashes then remainder of the code.

 

View original
Did this topic help you find an answer to your question?

3 replies

dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 596 replies
  • Answer
  • August 15, 2024

You can use the Concat and Substring to do it by clicking on the pencil on the data field. Example below I am taking 1st 2 characters of InventoryCD and then adding 2 dashes then remainder of the code.

 


andriitkachenko
Jr Varsity I
Forum|alt.badge.img+5

If I remember correctly, InputMask property of the PXDBStringAttribute not only validates provided values, but also allows you to form how it is shown.

Apart from that - you could create a DAC Extension with a custom field:

        [PXString]
        [PXUIField(DisplayName = "Mondrel")]
        public virtual string UsrMondrel
        {
            get
            {
                return "modified Mondrel value";
            }
        }
        public abstract class usrMondrel : BqlString.Field<usrMondrel> { }

Then use it in your GI.


  • Author
  • Freshman I
  • 8 replies
  • August 15, 2024
dcomerford wrote:

You can use the Concat and Substring to do it by clicking on the pencil on the data field. Example below I am taking 1st 2 characters of InventoryCD and then adding 2 dashes then remainder of the code.

 

Thank you for your help, now the info is displayed as i needed it.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings