Allow lookup fields to show text value, not just ID

When using the "Salesforce Entity" macro, we'd like for the macro to pull the value from a lookup field, not just the ID. For example, in the attached screenshot, the "Account ID" field shows the value "0013600001iHLFnAAO" but it should say "Raymond James," which is what it says if I'm viewing the field in the details of the object in Salesforce.

We're using the macro to pull data from the "Opportunity" object, and the "AccountID" field is a lookup to the "Account" object, where we'd like to show that account's Name.

  • Guest
  • Mar 3 2020
  • Needs review
  • Attach files