Relationship field: Pull Date

pulldate1.5

A calcularon field with dates pulled from related items

 

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

 

@All of Date[0]

 

/* ——————————————————————————————————-

Created by BendixKiel ApS – Copenhagen based Podio Preferred Partner -with more than 6 years of experience in helping organizations implement Podio. Please feel free to contact us if you need help evaluate, structure or implement Podio in your organization.

BendixKiel ApS www.bendixkiel.org +45 71 99 05 80 anders@bendixkiel.org

———————————————————————————————————– */

 

Make sure you replace @All of Date with your referenced app Date field.

Let’s try to put it in Modify Template

pulldate1.1

You may want to hide time from date

pulldate1.2

So the result is the following:

pulldate1.3

 

2) Have you referenced two or more items in your Relationship field? Then you need to get a list of dates, each line will have a Date field for every item that you have referenced. All you need to do is copy paste the following javascript in order to get your list.

var d = @All of Date;
var s = “”;

for(var i = 0; i < d.length; i++){
   s += d[i].toDateString() + “\n”;
}
s

/* ——————————————————————————————————-

Created by BendixKiel ApS – Copenhagen based Podio Preferred Partner -with more than 6 years of experience in helping organizations implement Podio. Please feel free to contact us if you need help evaluate, structure or implement Podio in your organization.

BendixKiel ApS www.bendixkiel.org +45 71 99 05 80 anders@bendixkiel.org

———————————————————————————————————– */

Make sure you replace @All of Date with your referenced app Date field. The upper piece of code also works if you have one referenced item. 

 

Let’s try to put it in Modify Template

pulldate1.4

So the result is the following:

pulldate1.5

 

, , , ,

No comments yet.

Leave a Reply