Action Buttons are
- real buttons
- with two states “enabled” and “disabled”
- which are generated by a cell-based definition (statically or dynamically)
- which support 7 different action types
Fields of Applications
The new action buttons are generated in the size (but not the format) of the target cell and look like “normal” buttons. You can use them e.g. for page navigation …
… and you can use them also as trigger for actions like Drillthrough documents or Iterate Sheet processes:
And here see them in “action” 🙂
Definition of action buttons
The definition of an action button consists of two parts:
- Named Range beginning with “data1_Button“
- JSON like definition of the button:
{ "Title": "Existing Contracts", "Action": "Navigation", "Action Parameter": "HR Contracts", "Status": "Automatic", "Rounded Corners": true, "Background Color Enabled": "#FFC000", "Text Color Enabled": "#000000", "Border Color Enabled": "#FFC000", "Background Color Disabled": "#595959", "Text Color Disabled": "#000000", "Border Color Disabled": "#000000" }
These are the parameters, the order of the parameters does not matter for the functionality and can be set arbitrary:
- Title = text on the button
- Action = action type (see next topic)
- Action Parameter = parameter like sheet name (see next topic)
- Status = Automatic or Disabled
- Rounded Corners = true or false
- Background Color Enabled = color code (hex or text)
- Text Color Enabled = color code (hex or text)
- Border Color Enabled = color code (hex or text)
- Background Color Disabled = color code (hex or text)
- Text Color Disabled = color code (hex or text)
- Border Color Disabled = color code (hex or text)
These are the available action types:
That means you can use the buttons also to trigger the Read and/or Write process.
Sheet Navigation
The target sheet can be hidden, it is made visible automatically when the navigation button is pressed and it will be hidden again, as soon as you leave the sheet (e.g. by clicking the Back button).
This is the same functionality that we delivered with the prior hyperlink based navigation.