Table lookup

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

In this article

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

Join our newsletter

Hand-picked content and zero spam!

Related articles

Show more
Best Accounting Apps to Manage Your Business Finances
7 min. read

Best Accounting Apps to Manage Your Business Finances

In this article, you will learn about the top accounting apps like Sage, QuickBooks, Zoho Books, and more to simplify bookkeeping, automate workflows, and grow your business.

Grok AI Use Cases: Gmail, WhatsApp, CRM & More
5 min. read

Grok AI Use Cases: Gmail, WhatsApp, CRM & More

In this article, you will learn some practical Grok AI automation use cases, from Gmail and WhatsApp to CRM queries and Google Home integration.

HubSpot vs. Pipedrive: Which CRM to Use
7 min. read

HubSpot vs. Pipedrive: Which CRM to Use

In this article, you will find a comparison between HubSpot and Pipedrive CRM tools in features, pricing, and usability for sales and marketing teams.

Best AI Automations with Albato: ChatGPT, Claude, Gemini
10 min. read

Best AI Automations with Albato: ChatGPT, Claude, Gemini

In this article, you will find some examples of powerful AI automations with ChatGPT, Claude, and other LLMs you can set up with Albato to boost productivity and streamline your business processes effortlessly.

Grok 4, GPT-5, Gemini, and Claude Opus 4.1―All the Recent Updates
13 min. read

Grok 4, GPT-5, Gemini, and Claude Opus 4.1―All the Recent Updates

In this article, you will find an in-depth comparison of Grok, ChatGPT, Gemini, and Claude. Discover their strengths, weaknesses, and which AI chatbot fits your business needs best.

Testing Steps Tool
5 min. read

Testing Steps Tool

Testing Steps tool allows you to run a test on each individual step and view Samples of incoming data

Branching Tool
5 min. read

Branching Tool

A new tool in Albato allows you to run different scenarios within a single automation depending on specific conditions.

How AI Is Changing SaaS Product Design
7 min. read

How AI Is Changing SaaS Product Design

In this article, you’ll learn how to design SaaS products in the age of AI. We’ll discuss UX patterns and practical tips to help you create better products.

Can AI Help Me Design Smarter Workflows in Albato?
3 min. read

Can AI Help Me Design Smarter Workflows in Albato?

In this article, you will learn how AI is starting to shape workflow design, how Albato is preparing to lead the way with its upcoming Superagents, and why this matters for businesses looking to scale automation without technical expertise.

How to Connect Microsoft Excel to Albato
4 min. read

How to Connect Microsoft Excel to Albato

Connect Microsoft Excel with Albato to integrate it with over 800+ apps, including AI tools like ChatGPT and Gemini.

How to Connect VKontakte to Albato
4 min. read

How to Connect VKontakte to Albato

Connect VKontakte with Albato to integrate it with over 800+ apps, including AI tools like Grok and Claude.

How to Connect Acuity Scheduling to Albato
4 min. read

How to Connect Acuity Scheduling to Albato

Connect Acuity Scheduling with Albato to integrate it with over 800+ apps, including AI tools like Grok and Claude.