Update a Ref Field

Follow

Stuart Frodsham

• December 06, 2015 09:27

Hi

I have three apps "Clients" "Suppliers" and Bookings
In Clients It references all suppliers used to date (Manual selection)

The "Bookings" app references both apps

I would like to have the Clients app show all the Suppliers based on the bookings made (so we don"t manually up date the suppliers ref field in the client app )

Is this possible ?

TIA

0

• 

  Henrik Huhtinen

  • December 07, 2015 11:18

  Sort of. You can't access "second level" relations directly in a calculation, but you can show field content from Suppliers if you add a calculation field in Bookings that gets the content from the related fields and then access that calculation field in a calculation in Clients.

  0

  Comment actions Permalink
• 

  Stuart Frodsham

  • December 07, 2015 11:58

  Hi Henrik - Thank you I had tried this and achieved a text list but in an ideal world I would like to have the clickable relationship field as the list - Would you know if this can be done using the API and if so is that a complex thing to do ?

  Thanks for the input :)

  0

  Comment actions Permalink
• 

  Henrik Huhtinen

  • December 07, 2015 12:38

  Well, via API you could of course do this - you could use a webhook in Bookings on item.create and item.update which would add/remove relationships to Clients as they are added/removed from Bookings. But you would have to decide also how to handle the case of someone editing the relationships directly in Clients.. should you then propagate that back to Bookings? ;D

  0

  Comment actions Permalink
• 

  Stuart Frodsham

  • December 07, 2015 12:44

  Ok sounds like its time to figure out how a web hooks work - then I'll try figure out the issues that causes - Thank you again !!

  0

  Comment actions Permalink
• 

  Jean-Claude Massé

  • December 07, 2015 21:14

  You could try Globiflow

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • December 09, 2015 10:28

  Hi Stuart,

  the text list you've got in the calculation field can be made clickable (without webhooks and API). Just let the calculation add the URLs of the listed items. You would need an additional calculation field for the URL in the app where the items are in.

  Rainer

  0

  Comment actions Permalink
• 

  Stuart Frodsham

  • December 09, 2015 10:31

  Hi Rainer - That sounds perfect please could you elaborate a bit for me !!

  What do I need to put into this new calc field

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • December 10, 2015 16:41

  Hello Stuart,

  open an item in the app and copy the url except the number (= unique item ID) at the end. Then paste the url into the additional calculation field (e.g. named "itemURL") and add `@unique ID", like this

  "https://podio.com/delos-consultingcom/testing/apps/dashboard/items/"+@unique ID
  

  In the app where you create the list in a calculation field:

  var title = @all of title field;  
  var url = @allof itemURL; 
  
  list = [];
  for(var i =0; i < title.length; i++){
  list.push("[" + title[i] + "](" + url[i] + ")");
  };
  list.join("\n")
  

  But be careful: If you change the workspace url in the workspace setting (maybe afte you have renamed the workspace) or the app name the link breaks.
  If you have defined your own unique id (in app settings) with a prefix and/or leading zeros like "test_007" you have to clean the id cause you only need the 7 (in this case).

  2

  Comment actions Permalink
• 

  Stuart Frodsham

  • December 11, 2015 08:25

  Thank you once again Rainer .. That is perfect !

  0

  Comment actions Permalink
• 

  Henrik Huhtinen

  • December 11, 2015 09:24

  I like Rainer's approach, I didn't think of utilizing the Unique ID in the "in between" app. Actually, you could even make the calculations include your own "relationship" badges as pictures since calculations can use markup ;)

  0

  Comment actions Permalink

Please sign in to leave a comment.