Skip to main content
Version: Streamsheets 2.4

SHOWVALUES

To display values from a querey in a boxed table use the SHOWVALUES() function in an event. Select the source and the size of your table, a event should trigger. The tablebox can be scrolled through and closed again.

Syntax

SHOWVALUES(Datasource,Targetrange)

Arguments

NameDescription
DatasourceA cell with a querey (e.g. TIMESCALE.SELECT(), TIMEAGGREGATE())
TargetrangeA range to display the data over.

Return Value

TRUE.

Example

FunctionComment
DRAW.BUTTON("100285020360",,"Button1",22066,9182,7250,5794,,,,EVENTS(ONCLICK(SHOWVALUES(C6,K2:N7))),,,"Button",,FALSE)If the user clicks on the button, queried data from C6 will be shown in a table covering K2:N7.