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
How to connect ClickUp to Albato for seamless Integrations | ClickUp Integrations Guide
4 min. read

How to connect ClickUp to Albato for seamless Integrations | ClickUp Integrations Guide

Learn how to set up ClickUp integrations with Albato in our step-by-step guide. Unlock powerful ClickUp integrations & automate workflows to boost productivity.

Connect Zendesk with Popular Apps | Streamline Your Support Workflow with Albato
4 min. read

Connect Zendesk with Popular Apps | Streamline Your Support Workflow with Albato

Zendesk offers a comprehensive customer service solution, designed for ease of use and scalability. See how Albato can help you enhance the app’s usability!

How to use Claude Artifacts: 7 Ways with examples | Guide 2025
Claude AI
10 min. read

How to use Claude Artifacts: 7 Ways with examples | Guide 2025

Learn how to use Claude Artifacts with our detailed guide. Explore 7 best ways with real Artifact examples: web pages, prototypes, presentations and visualizations.

Connect Gumlet with Your Favorite Apps | Optimize Your Media Management with Albato
3 min. read

Connect Gumlet with Your Favorite Apps | Optimize Your Media Management with Albato

Gumlet is best way to stream ad-free videos on internet. It has powerful CMS to organise videos and hollywood grade DRM. See how Albato can help you enhance the app’s usability!

Connect Octopush with Albato | Elevate Your SMS Marketing Strategy
3 min. read

Connect Octopush with Albato | Elevate Your SMS Marketing Strategy

With Octopush, businesses are well equipped to propel their brand, promote their offers and services at scale. See how Albato can help you enhance the app’s usability!

Connect DocuSign with 800+ Apps | Simplify Document Management on Albato
3 min. read

Connect DocuSign with 800+ Apps | Simplify Document Management on Albato

DocuSign is a top electronic signature and digital transaction management platform, helping organizations manage contracts and agreements securely and efficiently. See how Albato can help you enhance the app’s usability!

Chili Piper Alternatives 2024: Top 6 Scheduling & Lead Management Tools
CalendarHero
4 min. read

Chili Piper Alternatives 2024: Top 6 Scheduling & Lead Management Tools

Discover the top 6 Chili Piper alternatives for scheduling and lead management. Compare features, pros & cons of Calendly, Dashly, Cal.com & more. Find the best fit for your business.

Customer Service Skills: Essential Guide to Handling Discount Requests
1 min. read

Customer Service Skills: Essential Guide to Handling Discount Requests

Learn essential customer service skills for handling different types of discount requests. Discover proven strategies for maintaining customer loyalty while protecting your business interests.

Passion.io Alternatives: 5 Better Options for Video Apps
2 min. read

Passion.io Alternatives: 5 Better Options for Video Apps

Looking for Passion.io alternatives? Explore 5 powerful platforms: Gurucan, Mighty Networks, Thinkific, Bettermode & FlutterFlow. Compare features, pricing & choose the best app builder for your needs.

5 Powerful Mobile App Marketing Strategies You Haven't Tried Yet | 2024 Guide
5 min. read

5 Powerful Mobile App Marketing Strategies You Haven't Tried Yet | 2024 Guide

Discover 5 powerful mobile app marketing strategies to boost downloads and user retention. Learn how to leverage automation, A/B testing, analytics, and cross-promotion tools to grow your app effectively. Perfect for developers and small teams.

How to Start an Affiliate Marketing Store
4 min. read

How to Start an Affiliate Marketing Store

Step-by-step guide to creating a profitable affiliate marketing store. Learn how to choose programs, build a site, and monetize your audience.

Top content automation tools in 2024
4 min. read

Top content automation tools in 2024

Maximize your reach in 2024 with tools designed for every content channel. Find out how top automation platforms can transform your workflow