How to create an alert Panel

From Tygron Support wiki
Jump to navigation Jump to search

Panels form a (custom) interface element for the end-user. When backed by an Excel, a Panel can perform calculations and affect the project, including the visualization of the Panel's own Popup.

The instructions below will create a Panel which appears only when the amount of lotsize in the Project changes during a Session.

Editor → Current Situation (Ribbon tab) → Panels (Ribbon bar)
How to add a Panel:
  1. Create a new Excel file.
  2. Add a "SELECT_LOTSIZE_WHERE_MAP_IS_CURRENT" cell to the Excel file.
  3. Add a "SELECT_LOTSIZE_WHERE_MAP_IS_MAQUETTE" cell to the Excel file.
  4. Add an "UPDATE_PANEL_VISIBLE_WHERE_PANEL_IS_ID" cell to the Excel file.
  5. Add an "EXPLANATION" cell to the Excel file.
  6. Set the formula of the "UPDATE" cell and the "EXPLANATION" cell to "=IF(SELECT_LOTSIZE_WHERE_MAP_IS_MAQUETTE - SELECT_LOTSIZE_WHERE_MAP_IS_CURRENT=0;0;1)".
  7. In the Editor, add a new Excel Panel.
  8. Upload the created Excel file for the added Panel.
  9. Place the Panel somewhere in the project area.
  10. Now, when a user performs any Action which changes the amount of lotsize in the project, the Panel will appear.

Notes

  • If the Project is set to automatically recalculate, the Panel's Popup should start off invisible. Otherwise, the Panel's Popup will become invisible when a calculation has been run.
  • The described formula may differ based on language settings for your particular version of Excel.
  • Besides dynamically changing the visibility of a Panel, it is also possible to change the popup type used to display the Popup.

How-to's