Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • BigCommerce
  • FreshBooks
  • Magento
  • QuickBooks
  • Salesforce
  • Service Now
  • Xero
  • Zendesk

To use Reference or Lookup function:

  1. On the Mapping page of your Transaction, clickcorresponding to the reference field for which you want to use Reference or Lookup function and then click Expression and Variables, for example, parent_id. 



  2. On the Reference Selection window, select the way you want to choose your reference field. The available options are Select from list and Lookup.

    • If you choose Select from list, select the value from the Select Reference category, and click Save.

      Image Modified

    • If you select Lookup, select the criteria based on which the reference field value will be fetched and click Save.

      Image Modified

      1. Select the destination field for which you want to match value at source from the Target Field.
      2. Select Equals

     from
      1.  operator from the Condition

        Info
        You will find other operators in case of Service Now application only. Depending on the selected Target Field type (integer, boolean, string, date/time, reference, and GUID) the operators will differ.
      2. Select the source field that should match the value of the selected destination field from the Source Field

        Info
        You can select multiple fields if you have selected is one of or is not one of operator in the Condition drop-down list. You can select two fields only if you have selected between operator in the Condition drop-down list.
      3. Click Save.