Update a Ref Field
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
-
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
-
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).
Please sign in to leave a comment.
Comments
10 comments