Various ways to show a Date field

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 […]

Read full story · Comments { 0 }

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 […]

Read full story · Comments { 0 }

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 […]

Read full story · Comments { 0 }

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 […]

Read full story · Comments { 0 }

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 […]

Read full story · Comments { 0 }

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 […]

Read full story · Comments { 0 }

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 […]

Read full story · Comments { 0 }

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:; […]

Read full story · Comments { 0 }

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 […]

Read full story · Comments { 2 }