Update a Ref Field

Comments

10 comments

  • Henrik Huhtinen

    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

    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

    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

    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é

    You could try Globiflow

    0
    Comment actions Permalink
  • Rainer Grabowski

    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

    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

    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

    Thank you once again Rainer .. That is perfect !

    0
    Comment actions Permalink
  • Henrik Huhtinen

    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.

Powered by Zendesk