Table lookup

Table lookup
Tools
·
3/16/2022
·
3 min. read

Albato Table lookup tool allows you to replace incoming data from a sending app.

Let’s suppose you receive order from store with Paid status. Then you want to update this order status in your CRM. But you cannot send Paid status from online store to CRM system, as it can receive only codes (e.g. 1234). To avoid errors, you need to transform word Paid into a code, i.e, make a table replacement using Albato tool.

We will consider the example with AliExpress and Bitrix24 automation.
First, we create a scenario that responds to order status changes in AliExpress and automatically change statuses in Bitrix24. Our task is to track the cancellation of orders by customers.

AliExpress order statuses

  • PLACE_ORDER_SUCCESS
  • PAYMENT_PROCESSING
  • RISK_CONTROL
  • WAIT_SELLER_SEND_GOODS
  • SELLER_PART_SEND_GOODS
  • WAIT_BUYER_ACCEPT_GOODS
  • IN_CANCEL
  • FINISH
  • ARCHIVE

Bitrix24 funnel stages:

  • NEW
  • PREPARATION
  • PREPAYMENT_INVOICE
  • 1 — Yandex.Go delivery
  • 2 — Send track number
  • EXECUTING
  • FINAL_INVOICE
  • WON
  • LOSE
  • APOLOGY

As you can see, they don’t match. You can easily solve this problem using Table lookup tool.

How to set up

Open the Automation builder section, click + button between steps and select the tool.

Table lookup.png

Then set up Table lookup fields.

  1. Name. We create name for new variable. Further in the automation settings we will use this name.
  2. Value. Select the value from the list to check if the condition is met.
  3. Add a condition. By clicking this button, you add conditions for the tool.
  4. Otherwise. Specify the value that will be transferred if the system failed to find a value corresponding to the condition written above.

ISring&PandaDoc.png

Here is what we have done:

  1. Enter the name for new variable (Test).
  2. Select variable from AliExpress directory (Order status)
  3. Set up the condition: «If the data from the Value field is equal to IN_CANCEL , then change this value to LOSE«. IN_CANCEL is a system status that AliExpress sends when an order is cancelled. LOSE is a system value for the status of a lost deal in the funnel in our CRM Bitrix24.
  4. We specified the value to transfer if the system failed to find a value corresponding to the condition. EXECUTING is a system value of the In Progress funnel status in Bitrix24.

For a note

Open the Apps section to find the system values. Select the app and check the value in the directories. Screenshot shows page with values ​​for Bitrix24.

2022-08-16_19-31-02.png

The tool is set up! You can use its value in next steps.

How to use

Let’s use the duplicates processing feature when creating a new deal in Bitrix24. For the New deal step to work, which actually updates the status of an existing deal, it is necessary to pass the order ID from AliExpress to the Deal title.

Table lookup (1).png

Click the Save button. Then set up duplicate processing.

Select Update record if a duplicate is found as a rule and Deal title as a value to search the duplicate.

Table lookup (2).png

All fields contains Current value, which means that the field will save the existing data. To update data, we need to specify a new value. click on the Stage field, delete the Current Value and select the variable from Albato Table Lookup tool in other values.

Table lookup (3).png

Click Save button. Ready! You have learned how to set up table lookup tool in Albato.


Tools

Related articles

Show more
What Are White-Label Integrations for SaaS
7 min. read

What Are White-Label Integrations for SaaS

In this article, we explain what white-label integrations for SaaS are, explore their benefits and drawbacks.

Smarter Triggers, More Actions & Seamless Integrations
2 min. read

Smarter Triggers, More Actions & Seamless Integrations

Explore what’s new in Albato: features, apps, and improvements

In-house vs. Unified API vs. Embedded iPaaS: Key Differences & Best Use Cases
8 min. read

In-house vs. Unified API vs. Embedded iPaaS: Key Differences & Best Use Cases

In this article, you will learn the key differences between in-house integration development, Unified APIs and Embedded iPaaS to choose the best strategy for your SaaS product.

What the Ansoff Growth Matrix Is and How to Use It
8 min. read

What the Ansoff Growth Matrix Is and How to Use It

In this article, you will learn the definition of the Ansoff Growth Matrix, how it works, and how to use it for strategic planning in your business.

White-Label Albato Embedded vs. Zapier Embed: Solution Comparison
6 min. read

White-Label Albato Embedded vs. Zapier Embed: Solution Comparison

In this article, you will learn about the features and pricing fo Albato Embedded vs Zapier to help you find the best white-label integration solution for your needs.

Big News for AI Enthusiasts
2 min. read

Big News for AI Enthusiasts

Explore what’s new in Albato: features, apps, and improvements

Top 15 Tools for Outreach 2025
20 min. read

Top 15 Tools for Outreach 2025

In this article, you will find 15 top tools for outreach that help with contact enrichment, lead scoring, and more.

Product Updates We're Excited About
3 min. read

Product Updates We're Excited About

Explore what’s new in Albato: features, apps, and improvements!

How to Automate Repetitive Tasks in Your Business with No-Code Automation
8 min. read

How to Automate Repetitive Tasks in Your Business with No-Code Automation

In this article, you will learn about the benefits of no-code automation for business, which tools to use, and how to implement automation in your company.

Product-Led Growth: 4 Strategies and Implementation Guide
Embedded
13 min. read

Product-Led Growth: 4 Strategies and Implementation Guide

In this article, you will learn what product-led growth (PLG) is and how it drives user acquisition, retention, and scalability on real-life examples.

DeepSeek Overview: Features, Benefits, Use Cases, and Alternatives
Tools
7 min. read

DeepSeek Overview: Features, Benefits, Use Cases, and Alternatives

DeepSeek overview covering key features, benefits, and use cases. Compare top alternatives to find the best AI-powered solution for automation and efficiency.

Zapier vs. Albato Embedded: Which One Is Right for Your SaaS
5 min. read

Zapier vs. Albato Embedded: Which One Is Right for Your SaaS

In this article, you will learn the differences between Zapier and Albato Embedded and in which use cases each of these tools works best.