Pulling data out of a relation field

Follow

Michaël Struelens

• October 18, 2017 19:40
• Edited

Hi,

Can anybody tell me if it's possible to pull data out of a relationship field and group it?

I have a relationship field to my contact app but when I pull the data for multiple contacts it just lists what I want to pull.

Is it possible to group the data from contact A and after a brake line the data form contact B like so:

E-mail.: Jane@chilly.com
Tel: 123456789
E-mail.: Jhon@willy.com
Tel: 987654321

Kind regards,

Michael 

 

0

• 

  Rainer Grabowski

  • October 21, 2017 13:07

  Hi Michaël,

  var a = @All of Telefoon;
  var b = @All of E-mail;
  var list = [];
  for(var i = 0; i < a.length; i++){
  list.push("E-mail: " + b[i].map(function (obj) { return obj.value }).join() + "\nTel: " + a[i].map(function (obj) { return obj.value }).join());
  };
  list.join("\n\n")

  Rainer

  0

  Comment actions Permalink
• 

  Michaël Struelens

  • October 21, 2017 20:05

  Hey Rainer, 

  thanks for the reply. 
  
  I've tried the code but my calculation field is giving an error.

  

  Kind regards,

   

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • October 22, 2017 07:01

  The code works correctly only if all phone fields have the same number of phone numbers (e.g. all 1) and all email fields the same of email addresses (e.g all 1). If one  field has 2 entries or is empty the code doesn't work. The following code should cover all cases:

  var a = @All of Telefoon with nulls;
  var b = @All of E-mail with nulls;
  
  var list = [];
  for(var i = 0; i < a.length; i++){
  
  aCheck = a[i][0] != null ? a[i].map(function (obj) { return obj.value }).join() : "--";
  bCheck = b[i][0] != null ? b[i].map(function (obj) { return obj.value }).join() : "--" ;
  
  list.push("E-mail: " + bCheck + "\nTel: " +aCheck);
  };
  
  list.join("\n\n")

  Rainer

  0

  Comment actions Permalink
• 

  Michaël Struelens

  • October 22, 2017 09:51

  Hi Rainer,

  Thanks! It works like a dream now. 

  have a nice weekend.

  Kind regards,

  Michael

  0

  Comment actions Permalink
• 

  Gus H.

  • March 12, 2018 03:57

  Hi Rainer. I was playing with you code and at the same time adding another field. Your two field entry works like a charm, but once I try inserting a third one, I get a script error. Any suggestions? Thanks as always.

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • March 12, 2018 15:31

  Hi Gus, 
  
  you can't use .map(function()) for var a (Full Name).  Instead of .map(function())  simply use .join() for var a.

  Rainer

  0

  Comment actions Permalink

Please sign in to leave a comment.