Wednesday, November 10, 2021

Combination of some fields in a formula where some fields are null

 If IsNull({X_MONEY_RECEIPTS_REP.ORDER_CODE}) Then

    {X_MONEY_RECEIPTS_REP.IDENTITY}

Else

    {X_MONEY_RECEIPTS_REP.IDENTITY}+" / "+{X_MONEY_RECEIPTS_REP.ORDER_CODE}

No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...