@all of title .lenght

Follow

Teresa Cutrona

• December 01, 2016 09:16

I use 3 different app for manage this process:
Customers - Opportunities - Meetings
I Need to export data to determinate how much Opportunity and Meeting that the customers do.
At the moment I do the report in every single app, but I miss the general overview of the customers. I can see just the element related in the app but I can't do the export with all the data retated.

I tried to use the formula @All of Title.length but it show me no result 

It will be great if I can show all the opportunity and sales meeting divided to year

It can be possible?

Thank you in advance.

0

• 

  Teresa Cutrona

  • December 01, 2016 09:33

  I solved put + 0 at the end of formula

   

   

  0

  Comment actions Permalink
• 

  Adrien BLAISE

  • December 02, 2016 16:17

  You can use `@All of Title.length || 0`.

  0

  Comment actions Permalink
• 

  Teresa Cutrona

  • December 05, 2016 09:10

  Yes , thank you.. it works.

  Now I would like to filter calculation , for example:

  I used this :@All of address.join("\n") , but I Need that the calculation give me only city and not  other information, how can I do it?

   

   

  0

  Comment actions Permalink
• 

  Adrien BLAISE

  • December 05, 2016 09:39

  What's the address field type?

  0

  Comment actions Permalink
• 

  Teresa Cutrona

  • December 05, 2016 11:46

  

  I just want to show: città
  
  

  0

  Comment actions Permalink
• 

  Adrien BLAISE

  • December 05, 2016 13:13
  • Edited

  There must be a cleaner way, but you can try:

   

  `@All of Sede Legale.join().split(",")[1].replace(/[0-9]/g, '"").trim()`

  0

  Comment actions Permalink
• 

  Teresa Cutrona

  • December 05, 2016 13:20

   not works.

  

  Why? 

  0

  Comment actions Permalink
• 

  Adrien BLAISE

  • December 05, 2016 13:34

  Post the full screenshot. Did you remove the final back tick?

  0

  Comment actions Permalink
• 

  Teresa Cutrona

  • December 05, 2016 13:55

  
  what am I doing wrong?

  0

  Comment actions Permalink
• 

  Adrien BLAISE

  • December 05, 2016 14:57

  Remove the final back tick.

  0

  Comment actions Permalink
• 

  Adrien BLAISE

  • December 05, 2016 15:00

  Use this:

   

  @All of Sede Legale.join().split(",")[1].replace(/[0-9]/g, '"").trim()

   

  (I thought markdown was supported here, but it seems it's not anymore)

  0

  Comment actions Permalink
• 

  Teresa Cutrona

  • December 05, 2016 15:24

  nothing!

  :(

  0

  Comment actions Permalink
• 

  Adrien BLAISE

  • December 05, 2016 15:33
  • Edited

  What do you mean “nothing”?...

  Post a screenshot please...

  Use the last line of code I provided:

   

   

  @All of Sede Legale.join().split(",")[1].replace(/[0-9]/g, '"").trim()

   

   

  0

  Comment actions Permalink
• 

  Teresa Cutrona

  • December 05, 2016 15:35

  
  still not works. 

  0

  Comment actions Permalink
• 

  Adrien BLAISE

  • December 05, 2016 16:03

  There was a typo in there.

   

  Use this:

   

  @All of Sede Legale.join().split(",")[1].replace(/[0-9]/g, "").trim()

   

   

  0

  Comment actions Permalink
• 

  Teresa Cutrona

  • December 06, 2016 15:15

  I use this formula:

  var stringa = @All of Sede Legale.join();
  var array = stringa.split(",");
  array[2].trim();

  so now this is the result: 
  I can't take just "città", I don't know why

  
  
  

  0

  Comment actions Permalink
• 

  Adrien BLAISE

  • December 06, 2016 15:31

  
  @All of Sede Legale.join().split(",")[1].replace(/[0-9]/g, "").trim()

  0

  Comment actions Permalink
• 

  Adrien BLAISE

  • December 06, 2016 16:57

  It works here:

   

  

  0

  Comment actions Permalink
• 

  Teresa Cutrona

  • December 06, 2016 17:27

  he give me, Italy not city.

  0

  Comment actions Permalink
• 

  Adrien BLAISE

  • December 06, 2016 17:32

  Post a screenshot of your Location field.

  Try this:

  @All of Sede Legale.join().split(",")[2].replace(/[0-9]/g, "").trim()

  0

  Comment actions Permalink

Please sign in to leave a comment.