For Each look up on Related Item



  • Rainer Grabowski

    Hi Jeff,

    yes possible if all the B-items are related to the A-item: 

    var string_to_match = "whatever you want"
    var title = @all of title;
    var field1 = @all of field1;
    var field1 = @all of field2;

    var result = [];
    for(var i = 0; i < title.length; i++){
    if(title[i].indexOf(word_to-match) > -1){
    result.push(field1[i] + "\n" + field2[i]);

    If the B-items are not directly related to the A-item you need a workaround , e.g. all B-items and all A-items are related automatically by Globiflow to a third app C which has only one item. That C-item has a calculation field which holds the title and all the other fields from B. Then your calculation in A searches in the C-item's calc field content and pulls the needed data. 

    I use that way very often so I'm able to search for the contents from thousands of items in many different apps in many different workspaces. 


    Comment actions Permalink
  • Jeff Dougherty

    Hi Ranier,

    I have a similar issue, but not sure how to do it. I have app A, which links to multiple items in app B. I would like to have a for each in A that will lookup a field in B and return all results for the related items for that field. No Match Required as per original question.

    Comment actions Permalink
  • Jeff Dougherty

    Hi Ranier,

    I found the solution HERE.


    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk