Display Zero in Portal Form Field

Sort:
You are not authorized to post a reply.
Author
Messages
Woozy
Veteran Member
Posts: 709
Veteran Member
    I have a custom form that includes a numeric field where zero is a valid value.  I'd like Portal to display a zero, but it only displays a blank even though the underlying table actually shows a value of zero.

    Is there a way to do this without using Design Studio?

    Thanks!
    Kelly Meade
    J. R. Simplot Company
    Boise, ID
    Ragu Raghavan
    Veteran Member
    Posts: 468
    Veteran Member
      Is this 4GL code ?
      Mayhe change the screenfield to alpha right justified amd have an edit in the code for numeric and then convert to numeric before saving in the DB ?
      John Henley
      Senior Member
      Posts: 3348
      Senior Member
        You can do it with some creative CSS and JavaScript, but it would be a modification to Portal.
        Thanks for using the LawsonGuru.com forums!
        John
        Woozy
        Veteran Member
        Posts: 709
        Veteran Member
          OK - thanks guys.  I'm not very exited about either approach.  I guess it can just be a training issue on the new program.

          Thanks anyway!
          Kelly Meade
          J. R. Simplot Company
          Boise, ID
          Steven Gray
          Advanced Member
          Posts: 21
          Advanced Member
            If the custom form was designed in pgmdef, try using the Field Type edit value N1 or N2 in the screen definition Transaction Data section. The Workbench Manual says either of these codes will allow for the display of leading zeros.
            Woozy
            Veteran Member
            Posts: 709
            Veteran Member
              Hi Steven - Yep, that's what I tried first.  It seems to work in LID, but it doesn't appear to have any impact in Portal.  I tried both N1 and N2 without success.  Thanks for the thought, though.
              Kelly Meade
              J. R. Simplot Company
              Boise, ID
              You are not authorized to post a reply.