Pull text with calculation

Follow

Jeremy Caunt

• October 31, 2018 13:58
• Edited

Hi there, 

First of all thanks for all the help with Podio in the past, this forum has been so helpful!

However, this problem has got me stumped and I think it should be possible (my javascript knowledge is very limited).

I need to create a master app with product information that can then feed other apps in our company workspace. Any change in a field in that app would change any related fields.

Something along the lines of:

 

Field name "software version".

If the product code in new app = product code in the referenced master app (i.e. GMS310) then copy the software version from that field into this field.

 

Any help much appreciated and please let me know if this is the wrong approach.

Jeremy

 

0

• 

  Kareem Ahmed Asfour

  • November 01, 2018 11:38

  Hey,

  I think i got your point.

  you can create a relationship field in your new app. ( referenced to master app ) .

  then you can create calculation field. @all of software version+" ";

   

  if you need any help just pm me kareem-asfour@hotmail.com

  0

  Comment actions Permalink
• 

  Jeremy Caunt

  • November 03, 2018 13:24

  Thanks for your reply, kareem, 

  I've tried adding the calculation as suggested and get the following response:

  Preview: invalid value null (null): must be a string.

  Do you know what I might be doing wrong?

  Thanks again.

  0

  Comment actions Permalink
• 

  Jeremy Caunt

  • November 06, 2018 13:25

  Hi,

  I have also tried: 

  @All of Software.join()

  but this returns the same error - Preview: invalid value null (null): must be a string.

  Any thoughts of what I might be doing wrong?

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • November 06, 2018 17:48

  Hi Jeremy, 
  
  the preview notification simply says that nothing was found. Either the called field is empty or no item is related to the item where you are in the calculation field. Try it in an item where you are sure it's related and where the related item has a value in that field.
  Also: If you have a relationship from Master to the apps and relationship from the other app to the Master too you have 2 tokens for @all of Software Version - be sure to pick the right one, incoming or outgoing. 
   
  If the problem can't be solved please share a screenshot of the calculation.

  Rainer

  0

  Comment actions Permalink
• 

  Jeremy Caunt

  • November 08, 2018 17:40
  • Edited

  Thanks for your help guys, still not getting it quite right.

  I've had partial success in pulling a number into one calculation field, however, I'm not doing something right to get text across.

  Here are a couple of screenshots showing two versions of the calculation fields and one showing the result.

  In each screenshot, the top calculation (Version No.) is working correctly and pulling the correct number across.

  However, I can't get text to come across into Description. Example 1 and example 2 are different calculations I've tried to do this. I'm hoping it's something simple I'm doing/missing.

  I've tried deleting the calculation field and making a new one and have looked through the forum for the code but can't find it.

  Any help, much appreciated.

  Jeremy

  
  
  
  

  0

  Comment actions Permalink
• 

  Riky Silverio

  • February 22, 2022 00:43

  Did anyone solve this issue? I am having the same problem at the moment.

  0

  Comment actions Permalink

Please sign in to leave a comment.