How to create an alert Panel: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Panels 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 P...") |
No edit summary |
||
| (3 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 [[ | [[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]]. | |||
{{editor location|Panels}} | {{editor location|Panels}} | ||
| Line 7: | 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 " | | 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 " | | 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 [[ | | Place the [[Panel]] somewhere in the [[project area]]. | ||
| Now, when a user performs any [[Action]] which changes the amount of lotsize in the [[ | | Now, when a user performs any [[Action]] which changes the amount of lotsize in the [[project]], the [[Panel]] will appear. | ||
}} | }} | ||
{{clear}} | {{clear}} | ||
{{article end | {{article end | ||
|notes=* If the [[Project]] is set to automatically recalculate, the [[Panel]] should start off invisible. Otherwise, the [[Panel]] will | |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 [[Visible (Panel Attribute)|visibility]] of a [[Panel]], it is also possible to change the [[Popup type (Panel Attribute)|popup type]] used to display the [[Popup]]. | |||
|howtos=* [[How to add a 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.
How to add a Panel:
- Create a new 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 an "UPDATE_PANEL_VISIBLE_WHERE_PANEL_IS_ID" 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)".
- In the Editor, add a new Excel Panel.
- Upload the created Excel file for the added Panel.
- Place the Panel somewhere in the project area.
- 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.