How to create an alert Panel: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
mNo edit summary
No edit summary
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Panel]]s form a (custom) interface element for the end-user. When backed by an [[Excel]], a [[Panel]] can perform calculations and affect the [[3D World]], including the visualization of the [[Panel]]'s own [[Popup]].
[[Panel]]s 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]].
The instructions below will create a [[Panel]] which appears only when the amount of lotsize in the [[Project]] changes during a [[Session]].
Line 9: Line 9:
| Add a "SELECT_LOTSIZE_WHERE_MAP_IS_CURRENT" cell to the [[Excel]] file.
| Add a "SELECT_LOTSIZE_WHERE_MAP_IS_CURRENT" cell to the [[Excel]] file.
| Add a "SELECT_LOTSIZE_WHERE_MAP_IS_MAQUETTE" cell to the [[Excel]] file.
| Add a "SELECT_LOTSIZE_WHERE_MAP_IS_MAQUETTE" cell to the [[Excel]] file.
| Add an "UPDATE_VISIBLE_WHERE_PANEL_IS_ID" cell to the [[Excel]] file.
| Add an "UPDATE_PANEL_VISIBLE_WHERE_PANEL_IS_ID" cell to the [[Excel]] file.
| Add an "EXPLANATION" cell to the [[Excel]] file.
| Add an "EXPLANATION" cell to the [[Excel]] file.
| 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)".
| 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)".
| In the [[Editor]], add a new Excel [[Panel]].
| In the [[Editor]], add a new Excel [[Panel]].
| Upload the created [[Excel]] file for the added [[Panel]].
| Upload the created [[Excel]] file for the added [[Panel]].
| Place the [[Panel]] somewhere in the [[3D World]].
| Place the [[Panel]] somewhere in the [[project area]].
| Now, when a user performs any [[Action]] which changes the amount of lotsize in the [[3D World]], the [[Panel]] will appear.
| Now, when a user performs any [[Action]] which changes the amount of lotsize in the [[project]], the [[Panel]] will appear.
}}
}}
{{clear}}
{{clear}}
Line 26: Line 26:
* [[How to add a spatial Panel]]
* [[How to add a spatial Panel]]
}}
}}
[[Category:How-to's]]

Latest revision as of 14:01, 30 January 2024

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