Skip to main content
Version: Streamsheets 2.5

TIMESTORE

Stores key-value pairs over a specified time period. To query stored values use TIMEQUERY. This function only stores data in memory. As soon as the app stops and restarts again the data collection starts over. To store data persistent use a Stream function connecting to a data base (e.g. TimescaleDB).

Syntax

=TIMESTORE(Json, [Period], [TimeSerial], [Limit])

Arguments

NameDescription
JsonA JSON object which contains the key-value pairs to store.
Period (optional)The time period in seconds over which data is collected. Older data is dropped. Defaults to 60 seconds.
TimeSerial (optional)A serial number to use as key for each stored value. Note: data is always sorted according to its corresponding timestamp. Defaults to now.
Limit (optional)Specifies the maximum number of values stored. If limit is reached the function returns a #LIMIT error. Defaults to 1000.

Return

TRUE, if successful.

Examples

Example Sheet

AB
1v1=A1+1
2v2=RANDBETWEEN(0,100)
FormulaResultComment
=TIMESTORE(JSON(A1:B2))
Stores the values for v1 and v2 on each step.
=TIMESTORE(JSON(A1:B2), 100, , 10)
Same as before but stores only over a period of 100 seconds and limits number of stored values to 10

TS

Storing data from Berlin, Paris and London. Now a TIMEQUERY can be used to access the stored values