Dynamically Add Buttons

If you want to set buttons dynamically along with data records or login user group, you can set button via action.
There is an example about the action to set 'Details' button along with data records.
../../../_images/img_01.en236.png

Get Data

  1. Create action set to get data like this. Here is setting to be executed at sheet displaying.
../../../_images/img_02.en221.png

Set 'Details' button along with data count.

Set 'Details' button along with data count got by created action in Get Data.

  1. Create a 'Details' button.
../../../_images/img_03.en185.png
  1. Copy formula of the created 'details' button.
../../../_images/img_04.en157.png
  1. Add the following action to action created by Get Data.
  • Action to set 'Row to set button' into cell.
  • Loop action to 'Set button along with data count into cell'.
../../../_images/img_05.en142.png

As the condition of loop function, refer cell of row to set button, set 'Up to end value of cell set by data getting' condition by INDIRECT function.

Tip

There is a utility (UTIL.CELLV function) to get the cell value by specifying the row number and column number (number or column name) in CELF.
You can also use the UTIL.CELLV function to reference a cell as follows.
../../../_images/img_15.en43.png
  1. Add action to set button in loop action created in No.3.
  • Action to set 'Button formula' into cell (formula of 'Details' button copied in No.2)
  • Action to add 1 count into cell to set 'Row to set button'.
../../../_images/img_06.en111.png

Hint

If you want to set a formula in an action, enclose the whole in "(double quotes) and specify it in the form " ="formula" ". To include "(double quote) in the character string, it is necessary to describe two "(double quotes) consecutively, such as "".

../../../_images/img_14.en49.png

See also

How to dynamically set formulas like SUM, VLOOKUP, COUNTIF etc, refer Set formulas in action

  1. Run the test and Check button to be set along with data count.
../../../_images/img_08.en96.png

Set action of 'Details' button.

Create action of 'Details' button created by Set 'Details' button along with data count.
Here is to get a record as search condition of data ID and to pop-up to display contents.
../../../_images/img_09.en83.png
  1. Get a record data of the selected ID(Column B) where the button was clicked, and set the data into the cells(Column I)
../../../_images/img_10.en73.png

See also

Regarding the way to get clicked button row, refer Get Current Row Column.

  1. Create the action to display the data in the pop-up message.
../../../_images/img_11.en67.png

Hide Management Cells

Hide the columns for the manegement cells.

../../../_images/img_12.en61.png

Tip

When run the sheet, the data and the buttons will be displayed, and the pop-up message with the detail data will be opened by clicking Detail button.

../../../_images/img_13.en55.png

Related keywords

Control, list, check buttons, BUTTON, LIST, CHECK