Skip to Content

How to convert a control to all uppercase in Jitterbit App Builder

Configuration

  1. Navigate to the panel containing the control you want to modify
  2. Go to **Action Drawer > Live Designer **
  3. Click the panel's Business Logic gear icon
  4. Click the Columns tab
  5. Locate the Column you wish to modify. For example: CompanyName

  6. In the Column or Expression field, insert UPPER() around the existing Table.Fieldname. For example:

    UPPER(C.CompanyName)

  7. Enter an Alias for the Column. For example: UpperCompanyName

  8. Click the checkmark icon to Save
  9. Return to the application view and confirm the update

Step-by-step guide

  1. Navigate to the Panel containing the Control you want to modify, and go to **Design this Page **
  2. Select the Panel you are making this change to, and click on the corresponding **Business Logic ** icon
  3. Under the Rules ** heading, you want to click on the *SQL *icon for the Data Object containing the field you're modifying
  4. Under the *Columns ** heading, locate the Column you wish to modify and click on the corresponding pencil *Edit ** icon
  5. In the Column or Expression field, insert UPPER() so that it appears around the existing Table.Fieldname. For example:
UPPER(C.CompanyName)
  1. Click the check icon to Save

2018 04 02 16 18 32 business SQL customers allcaps App Builder IDe

When you refresh your web browser, you should be able to see the change to the Control on the Panel.