Caulculation - Show the first result only

Follow

James Hertan

• June 29, 2016 05:09

Hi All

We have a 'client contact' field in App1 that a separate contacts app.
In App1 we have a calculation field that displays a variety of data from App 1 in the one field (Name + date + organisation etc)
We often add multiple clients to the contact field in App1, as the one item will have 2-3+ client contacts.

Currently, the calculation field in App1 displays the name of all contacts added to the contact field.  

Is there a way of having this calculation field display only the name of the first contact, and not any of the others?
I would like to avoid having two contact fields in the App.

Thanks!

0

• 

  Rainer Grabowski

  • June 29, 2016 05:22

  Hi James,

  instead of getting the names by @all of name.join() use @all of name[0]. 

  Rainer

  0

  Comment actions Permalink
• 

  James Hertan

  • June 29, 2016 06:03

  Hi Rainer - Thank you as always! the @all of name[0] is returning the last entry added. Is it possible to return the FIRST entry added? Thank you again

  0

  Comment actions Permalink
• 

  James Hertan

  • June 29, 2016 06:12

  Managed to find a solution.
  
  For anyone interested - this will display the name of the first contact added to a contact field.
  
  @all of name[@all of name.length - 1]
  
  
  

  0

  Comment actions Permalink

Please sign in to leave a comment.