Find your favorite way to show a Date field by looking at the following image: In order to achieve this, just copy paste one of the following Javascripts in a Calculation field. 1) moment(@Date).tz(“Europe/Copenhagen”).format(“dddd DD/MM/YYYY, hh:mm A”) 2) moment(@Date).tz(“Europe/Copenhagen“).format(“ddd DD/MM/YYYY, hh:mm A”) 3) moment(@Date).tz(“Europe/Copenhagen“).format(“ddd DD/MM/YYYY, HH:mm”) 4) moment(@Date).tz(“Europe/Copenhagen“).format(“ddd DD/MM/YYYY”) 5) moment(@Date).tz(“Europe/Copenhagen“).format(“DD/MM/YYYY hh:mm A”) 6) moment(@Date).tz(“Europe/Copenhagen“).format(“DD/MM/YYYY”) Make sure […]
Add Duration field to Start Date field
If you want to add a Duration field to a Date field, that is possible. Just copy paste the following Javascript code to a Calculation field: var sd = @Start Date and Time; var d = @Duration; var h = Math.floor(d); var m ; var s ; var r = d – h; r *= 600000; r […]
Create a Date field from Text fields
Let’s say you have a date separated into three Text fields and you want to merge all of them into one Date field. That is possible, you can create Date fields with your information. Just copy paste the following code to a Calculation field: var d = new Date(); d.setDate(@DD (Text)); d.setMonth(@MM (Text) – 1); d.setFullYear(@YYYY (Text)); d /* ——————————————————————————————————- Created […]
Create a Date field by using Number fields
You can create a Date field using three different Number fields, which of course will contain the day of the month, the month, and the year. Just copy-paste the following code to a Calculation field: new Date(@YYYY, @MM – 1, @DD, 0, 0, 0 ) /* ——————————————————————————————————- Created by BendixKiel ApS – Copenhagen based Podio Preferred Partner -with […]
Adding days to a Date field
Given a Date field, and a Number field with the number of days to be added, you can create a Date field with the a new date. Just copy paste the following code to a Calculation field: moment(@Date).add(@Days to add:, ‘days’).toDate() /* ——————————————————————————————————- Created by BendixKiel ApS – Copenhagen based Podio Preferred Partner -with more than 6 years of experience […]
Relationship field: Pull Date
Let’s say you have used a Relationship field in your app for referencing another app, and you want to pull a Date from the second app. 1) Have you referenced just one item in your Relationship field? That means you will get only one date. All you need to do is copy paste the following javascript in order to get your Date field […]
Count the referenced items in the Relationship field
Let’s say you have used a Relationship field in your app for referencing another app, and you want to count how many items reference to the second app. All you need to do is find a field name of the referenced app, it can be any field. Then you should copy paste the following javascript in order to get your item number. @All of […]
Filter referenced items with Text field
Let’s say you have used a Relationship field in your app for referencing another app, and you want to filter items by choosing a word and then show a specific field of the referenced app. Then you should copy paste the following javascript: var s = @All of Status; var d = @All of –; var st = @Select Status:; […]
Show your referenced item fields in a table
Let’s say you have used a Relationship field in your app for referencing another app, and you want to show a nice table with specific fields of each referenced item. Then you should copy paste the following javascript to a Calculation field: var fn = @All of First Name; var ln = @All of Last Name; var oc = @All […]