For instance, you get {{text}} field (type of string) from a Telegram bot in several lines, and you want to process the lines separately. Here is the way:
1
'{{text}}'.replace(/\n/g,',')
2
// this is string with lines, separated by commas (you may use any other character)
3
// in this way arrays in the platform are stored
4
// e.g.
5
// {{text}} =
6
// Good fortune? The fact is
7
// The more that you practise
8
// The harder you sweat
9
// The luckier you get
10
//
11
// result will be:
12
// Good fortune? The fact is,The more that you practise,The harder you sweat,The luckier you get
13
14
'{{text}}'.replace(/\n/g,',').split(',')// this returns js-array
15
16
'{{text}}'.replace(/\n/g,',').split(',')[0]// this returns the first line
17
'{{text}}'.replace(/\n/g,',').split(',')[1]// this returns the second line
JS iterators are more applicable in JS SDK step. However, .map iterator can be useful in regular steps as well. This method adits all the elements of a given array.
1
// e.g. we want to add ' is the best' to every element of {{array}}.
2
// Here is the expression for that:
3
'{{array}}'.split(',').map(function(element)
4
{return element +' is the best'}).join(',')
5
6
// let {{array}} was "Jhon,Ivan,Anna"
7
// the expression will return
8
// Jhon is the best,Ivan is the best,Anna is the Best
Copied!
Applying array iterator reduce() for calculating average
JS iterators are more applicable in JS SDK step. However, .reduce iterator can be useful in regular steps as well.
1
"{{array}}".split(",")
2
.reduce(function(acc, curr)
3
{returnparseInt(acc)+parseInt(curr)})
4
/"{{array}}".split(",").length
5
6
// e.g. for {{array}} == 1,2,5,0,-4,12
7
// that expression returns 2.666667
Copied!
📅 Dealing with dates
In Advanced section of App settings you can choose your Time zone — if affects your operations with date functions like today or now
Setting up a time zone for your app
Getting current time
The method (new Date()).toISOString() returns a JS-date-object with current time. This method is more useful than now, because we can compose complex JS-expressions in a one step using (new Date()).toISOString()
1
(newDate()).toISOString()
2
// returns current Coordinated Universal Time (UTC)
3
// (new Date()).toISOString() === now === moment().toISOString()
You may need to aggregate some statistics during the day in a single object (for example, count the quantity of orders or users). The simple way to have such an object is to create it with ID = date of the day in some format. Here is the example of an expression for generating such day-unique ID:
1
$D.date.format($D.date.new(),'dd-MM-YYYY')
2
// for todays object
3
4
$D.date.format('{{today_date}}','dd-MM-YYYY')
5
// where {{today_date}} is a type of date field
Copied!
An example of 'Create object' step for creating a 'daily-unique' object
Don't forget to Save a link (write a link in the field) to the new object in order to be able to edit it. Note, that if you create an object with ID while there is an object with such an ID, nothing will be broken. You'll just create a link to that existing object.
Calculating the number of days between two dates
For solving that we have to apply getTime() JS-function. It deals with Date JS-object and returns Milliseconds since Epoch time. The steps are the following:
Getting a Date JS-object applying new Date('{{date}}') to the field {{date}} type of date
Getting the value in milliseconds since Epoch time applying .getTime()
Calculate the difference between two dates in milliseconds;
Convert milliseconds into days, dividing the result to (1000*60*60*24)—1000 milliseconds in a one, second; 60 seconds in a minute; 60 minutes in an hour; and 24 hours in a day.