Discover why creators build their business critical applications with Triggre.
Build applications the easy way using our drag-and-drop Triggre Designer.
Create a relational database with the ease of setting up a spreadsheet.
Use advanced business rules to automate processes in a heartbeat.
Use your application effortlessly on any device, styled to your needs.
Connect Triggre applications to the world in just a few clicks.
Start building and stop worrying with our built-in automatic testing.
Active monitoring and built-in security protects applications against threats.
Get a head start in 6 simple steps!
See what others have made with Triggre
Get inspired by the stories of Triggre Creators
Browse all available templates at your own leisure
Take a look at the Triggre Designer to see how it works
Learn all the ins and outs of the Triggre methodology. From ideation and building to selling your application!
Need some help? This is where to find the answers!
Get in-depth information about cases, digitalization and Triggre
Connect with the Triggre Creator community
Good to know before you start: different calculations with dates result in different formats. The format of the result of a calculation with days depends on the type of calculation.
In a flow part, a calculation with dates might result in a date-time value. If you include this in an email, it will look like this: pay before 09/02/2022 03:22. This doesn’t look great, so how to fix this? Convert the result to a text. From there on, you can isolate the date and use that in the data flow.
For some calculations you need an assisting data item. The steps below explain how to create an assisting data item.
It can be smart to use one flow part for all date conversions: you have all calculations at hand and a user flow needs to call only one flow part.
InputThe input is a Date.
Convert the date to a textThe first calculation in the Flow part converts this date to a text.This is the source of most of the calculations “downstream”.The result will be dd/mm/yyyy, name it Date as a text.
When you isolate the day, the result will be a text. Using data item Month, find the matching number of the day. Subtract (this number – 1) from the input. This will give you the first day of the month. Add one month, subtract one day and you get the last day of the month.
Add a month to the first day of the month and then add -1 day to it. That will give you the last day of the month as a date.
When you want to display or email a calculated year, Triggre will show it as a number (y,yyy). This doesn’t look nice. Just convert the number to a text and use the result.
First isolate the month number as a text. Then look up the month in data item Month. This will provide you with the name of the month.
You need the data item Year to find the year.
If you need to know how many days have passed since something happened, you can use this calculation. The result is a number with 6 decimals.
Number as a text:
Make sure that you enter nothing in the specific value behind WITH.
Determine the amount of digits to the left of the decimal point (n)
There are six decimals behind the decimal point.
This means that if you delete the (1 decimal point + 6 decimals) = 7 most right characters from the length of the text, you get the number as an integer.
The calculation of n:
Isolate the number (the integer):
Copyright © 2020 - Triggre. All rights reserved.
Get started for free and experience the power of the Triggre platform.
By signing up for your free account, you agree to receive e-mails from Triggre.