User Tools

Site Tools


An Excel Client EASAP stub

  • Right-click USER INTERFACE→TABBED PANE LIST→tabbed_pane1
    • Select Child→Add CASE VIEWER
  • Right-click case_viewer1
    • Select Sibling→Add LAYOUT PANEL
      • Rename it layout_panel_buttons
        • Set→Layout: HORIZONTAL
          • Right-click layout_panel_buttons
            • Select Child→Add BUTTON, four times
              • Rename the first one button_new
                • Set→Label: New Case
              • Rename the second one button_open
                • Set→Label: Modify Selected Case
              • Rename the third one button_delete
                • Set→Label: Delete Selected Case
              • Rename the fourth one button_exit
                • Set→Label: Exit
  • Right-click button_new
  • Right-click database_to_excel_desktop1
    • Select Sibling→Add REFRESH OBJECTS
      • Rename it refresh_case_viewer
        • Set→Objects: case_viewer1
  • Right-click button_open
    • Select Child→Add DATABASE TO EXCEL DESKTOP
      • Set:
        • Action: Open
        • Case Id: %case_viewer1%
          • (case_viewer1 takes value of a User selected 'case id')
  • Set: USER INTERFACE→Results Time: 1
  • Set: USER INTERFACE→TABBED PANE LIST→tabbed_pane1→case_viewer1→Refresh on Save: TRUE
  • Right-click button_open
    • Select Sibling→Add BUTTON
      • Rename it button_delete
        • Set→Label: Delete Selected Loan
  • Right-click button_delete
    • Select Child→Add SET CASE STATUS
      • For it set:
        • Status: Deleted
          • (this is actually mapped to the string DELETED)
        • Case Id: %case_viewer1%
  • Right-click tabbed_pane1→layout_panel_buttons→button_new→refresh_case_viewer1
    • Select Copy
  • Right-click button_delete→set_case_status1
    • Select Paste (Sibling)
      • (This will update case_viewer1 in the EASAP GUI just as with button_new)
  • Right-click case_viewer1
    • Select Child→Add FILTER
      • Rename it filter_not_deleted
        • Set:
          • Value: DELETED
          • Static Operator: NOT_EQUAL
          • Case Data to Compare: status

Finally we want an exit button so a User may confidently close the EASAP.

  • Right-click button_delete
    • Select Sibling→Add BUTTON
      • Rename it button_exit
        • Set→Label: Exit
  • Right-click button_exit
    • Select Child→Add MENU ACTION
      • Rename it menu_action_exit
        • Select menu_action_exit
          • Set→Action:Exit
            • (Equivalent to a User clicking the grey X in an EASAP)
  • Right-click USER INTERFACE
    • Select Child→Add USER INTERFACE STYLE LIST
      • Right-click USER INTERFACE STYLE LIST
        • Select Child→Add USER INTERFACE STYLES
          • Right-click USER INTERFACE STYLES
            • Select Child→Add USER INTERFACE STYLE
              • Rename it button_style1
  • Right-click button_style1
    • Select Child→Add TEXT STYLE
      • Set:
        • Font Size:12
        • Weight: bold
  • Right-click TEXT STYLE
    • Select Sibling→Add MARGIN
      • Set:
        • Top: 5px
        • Right: 5px
        • Bottom: 5px
        • Left: 5px
  • Right-click MARGIN
    • Select Sibling→Add PADDING
      • Set:
        • Right: 5px
        • Left: 5px
  • For each of the following buttons:
    • button_new
    • button_open
    • button_delete
    • button_exit
      • Set→ Style: button_style1
  • Right-click USER INTERFACE→USER INTERFACE STYLE LIST→USER INTERFACE STYLES→button_style1
    • Select Sibling→Add USER INTERFACE STYLE
      • Rename it label_style1
        • Right-click label_style1
          • Select Child→Add TEXT STYLE
            • Set:
              • Font Size:10
              • Weight: bold
              • Alignment: right
        • Right-click TEXT STYLE
          • Select Sibling→Add PADDING
            • Set:
              • Right: 5px
              • Left: 5px
  • Right-click tabbed_pane1
    • Select Child→Add SUB PANE
      • Rename it sub_pane_filters
        • Set→Layout: HORIZONTAL
  • Right-click sub_pane_filters
    • Select Child→Add INPUTBOX
      • Rename it Status
        • Set:
          • Label: Status:
          • Label Style: label_style1
  • Right-click Status
    • Select Child→Add DATA VALIDATION
      • Set:
        • Allow:List
        • Ignore Blank:FALSE
        • Source: ,NEW, IN_PROGRESS, FINISHED
          • (note the intial comma, we allow a blank option which accepts all status possibilities)
  • Right-click Status
    • Select Copy
      • Right-click Status
        • Select Paste (Sibling)
          • Rename it Term
            • Set→Label: Term:
  • Set: Term→DATA VALIDATION→Source: ,15,20,25,30
    • (note the intial comma, we allow a blank option which accepts all term possibilities)

Via a FILTER each INPUTBOX will generate a SQL query that will narrow the results set displayed in our CASE VIEWER.

  • Right-click case_viewer1→filter_not_deleted
    • Select Child→Add FILTER
      • Rename it filter_status
        • Set:
          • Value:%Status%
          • Static Operator: EQUAL
          • Case Data to Compare: status
    • Right-click filter_status
      • Select Copy then Paste (Sibling)
        • Rename it filter_term
          • Set:
            • Value: %Term%
            • Excel Value To Compare: term
  • Right-click sub_pane_filters
    • Select Sibling→Add EVENT PROCESSING
      • Rename it event_processing_filters
        • Expand it with the plus box
          • Right-click event1
            • Select Child→Add VALUE CHANGED
              • Rename it value_changed_filters
                • Set→ Objects: Status, Term
          • Right-click tabbed_pane1→layout_panel_buttons→database_to_excel_desktop1→refresh_case_viewer
            • Select Copy
          • Right-click action_group1
            • Select Paste (Child)
  • Set case_viewer1→Height: 200
    • (in a real application this number should be slightly less than the vertical display height in pixels)

CASE VIEWER→Count: gives us the size of the results set.

Declare a new SCALAR, total_cases, in Count: then display this number in a LABEL to show the current results set length.

  • Select case_viewer1
    • Set→Count: total_cases
  • Right-click event_processing_filters
    • Select Sibling→Add LABEL
      • Set:
        • Label: Number of Loans: %total_cases%
        • Style: label_style1
  • Right-click USER INTERFACE→tabbed_pane1
    • Select Child→Add DATA PROCESSING
      • Expand it
        • Right-click SCALAR
          • Select Child→Add EXPAND
            • Rename it Selected_loan
              • Set:
                • Value: %case_viewer1%
                • Value On Error: 0
  • Select USER INTERFACE→tabbed_pane1→layout_panel_buttons→button_open
    • Set→ Enable If: Selected_loan>0
  • Select USER INTERFACE→tabbed_pane1→layout_panel_buttons→button_delete
    • Set→ Enable If: Selected_loan>0
  • Click the Tree tab
    • Select EASAP→PROPERTIES→APPLICATION
      • Set→Selection Image: mort_calc.jpg
    • Right-click EASAP→SPREADSHEET LIST
      • Select Child→Add SPREADSHEET
        • Set:
          • File: MortgageCalculatorEDC.xls
          • Desktop: TRUE