View related items in a different App

Follow

Jason Moore

• June 01, 2022 09:50

I have 3 apps Campaigns, Expenditures and Suppliers.

When I create an expense I set a relationship with a supplier.

I would like to be able to see all the suppliers from all the expenditures in the campaign in the Campaign App without having to reattach them manually in the Campaign App.

Is this possible? 

0

• 

  Jason Moore

  • June 01, 2022 13:47
  • Edited

  So I have solved this in a curious way.
  
  

  1. I create a table in the expense from the supplier 

   

  var company = @All of Company name;
  var contact = @All of Contact name;
  var phone = @All of Phone;

  var tableContent = [];
  for(var i = 0; i < company.length; i++){
  tableContent.push(company[i] + " |  " + contact[i] + " | " + phone[i]);
  };

  tableContent.join("\n")

  2. I then pull the individual suppliers in a table from the expense 

  var company = @All of Suppliers to campaign;

  
  var tableContent = [];
  for(var i = 0; i < company.length; i++){
  tableContent.push(company[i]);
  };

  "Company | Contact | Phone \n" +
  "--- | --- | --- \n"+
  tableContent.join("\n")

   

   

  0

  Comment actions Permalink

Please sign in to leave a comment.