Skip to main content
Solved

how to add dashes to a text GI?

  • Aug 14, 2024 11:19 PM UTC
  • 3 replies
  • 112 views
  • Translate All

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

3 replies

dcomerford
Captain II
Forum|alt.badge.img+16
  • Captain II
  • Answer
  • Aug 15, 2024 10:32 AM UTC

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.

 

Translate

andriitkachenko
Jr Varsity III
Forum|alt.badge.img+6

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.

Translate

  • Author
  • Freshman I
  • Aug 15, 2024 11:26 PM UTC

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.

Translate