Timer

This article describes the Timer function and each of its properties.

All Squirrel365 plans include the Timer function.

For more details, see our pricing comparison matrix.

The Timer function allows an interval or recurring interval to be added between events in a Squirrel project.

Add a timer to your project by opening the FUNCTIONS drawer in the object browser, selecting Timer from the dropdown box, and clicking the plus button. The Timer function will appear in the FUNCTIONS drawer of the Object Browser. Select it from there to access its properties in the property panel.

Timer Function Properties

DATA INSERTION:

  • Delay in milliseconds – This is the time it will take from the timer being triggered to timer completion.

  • Trigger when:

    • Cell changes – The timer will be triggered when the content of the cell bound to the Trigger cell property is changed.

Cell changes are selected by default, but until a value is added to the Trigger cell (and the Equals property if the Cell equals option is selected), the timer will not trigger.

  • Cell equals – The timer will be triggered when the content of the cell bound to the Trigger cell is equal to the value of the Equals property (this value can be typed into the Equals property or bound to another cell in the spreadsheet).

If the content of the Trigger cell changes between the timer being triggered and before the Delay in milliseconds has elapsed, the timer will restart.

  • Trigger on load – Checking this will start the timer as soon as the Squirrel project is loaded. This can be used on its own, or in addition to one of the Trigger when options listed above.

  • Insertion Type:

    • Block – This option will cause the timer to execute once only, after which (if values have been added to the Source and Destination properties), a further event can then be initiated.

    • Loop – This option can be selected if the timer needs to be executed more than once.

  • Loop Counter – A counter will be incremented each time the timer executes, and this number will be inserted into the cell bound to this property.

  • Loop options:

    • Loop for:

      • Stop after n loops – Add a numerical value into this property (or bind to a cell containing a numerical value), and the timer will execute this many times.

    • Loop until:

      • Bind cell property to a cell in the spreadsheet, then either add a numerical value to the equals property or bind to a cell in the spreadsheet that contains a suitable value.

Last updated

Logo

Copyright Β© 2019 - 2024 InfoSol Ltd. All rights reserved.