Categories
article

Upgrade Your Workflow with APITable’s Latest Feature Releases: ChatGPT, Cascader, Zapier etc.

With the trend of ChatGPT’s popularity, have you incorporated AI or ChatGPT assistance into your work management? As the number of software tools for work increases, have you considered building an automated workflow to connect them and save a lot of meaningless time?

As a simple and powerful work management OS, the APITable Cloud Edition has significant enhancements to AI (ChatGPT-related) and automation in its latest update, and some surprises related to work efficiency are waiting for you to discover.

In summary, the key updates in the APITable Cloud Edition this time include:

  • GPT Content Creator
  • Zapier integration
  • New robot action: Send mails
  • New robot action: Send message to Slack
  • New field type “Cascader”
  • Script Widget
  • Enterprise Plan can be subscribed online

You can learn more about this product update and more information in the detailed introduction below.

GPT Content Creator from ChatGPT

APITable widget center has added the “GPT Content Creator”, which is a new attempt by APITable to access AI capabilities. The widget can help you create content effectively by generating structured prompts through smart formulas and then utilizing the results from AI conversations of the GPT-3.5-turbo model.

For example, it can intelligently output promotional copy for different social media based on the characteristics of different products.

apitable work management integrate with ChatGPT
List the elements in the question
apitable work management integrate with ChatGPT
Using formulas to organize questions
apitable work management integrate with ChatGPT
Ask ChatGPT questions and output copy

We have already open-sourced this ChatGPT-related widget on GitHub, and we hope that capable developers can develop more ChatGPT-related widgets by referring to it.

APITable already supports self-built widgets. You are welcome to read our technical documentation for more information or quickly experience the complete development process through our widget template.

Zapier integration

APITable now supports Zapier integration. You can connect your commonly used SaaS applications with APITable to simplify your workflow and automate your data management more easily.

Over 5,000 applications and services can be connected to APITable through Zapier to automatically transmit data without code, achieve work automation, and free you from manual and repetitive work tasks.

If you are not sure how to use Zapier to build APITable-related workflows, we have prepared 10 templates for you to use directly, such as:

  • Add new MailChimp subscribers to APITable
  • Send emails in Gmail when new records are created in APITable
  • Create Google Calendar events from new APITable records
  • Send messages to Discord/Slack for new APITable records
  • Add new customers in Stripe to APITable
  • Add new Salesforce records to APITable
  • Create APITable records for new WordPress posts
Zap: Add new MailChimp subscribers to APITable

For more templates, please visit APITable’s homepage on Zapier.

New robot action: Send mails

APITable robot has added the action “Send mails”. In marketing and work communication, email is a very important means of communication, and now you can use the robot in APITable to achieve automated email sending.

For example, when a new sales lead is added in APITable, an email can be automatically sent to notify relevant personnel of the latest work information.

New robot action: Send message to Slack

APITable robot has added a new action “Send message to Slack”. Many companies and teams use Slack for instant work communication, and with the help of the robot, your team members can be promptly notified on Slack when there is a change in data in APITable.

For example, when the task status of a project in APITable changes, a message can be automatically sent to a Slack channel, notifying the next responsible person and completing a workflow. For detailed usage, please refer to the relevant help documentation.

Please refer to the relevant help documentation For detailed usage.

New field type “Cascader”

APITable has added a new field type “Cascader” which can help you input data more quickly and accurately.

You need to use a configuration table to configure the hierarchical relationship, such as “Province-City-District” or “Company Organizational Hierarchy”, and using Cascader, when you select an option, its sub-level options will be automatically updated, greatly improving input efficiency and accuracy.

Script Widget

The APITable widget center has added the “script” widget. It supports online programming and data interaction with datasheets through built-in script APIs. With this capability, you can extend various code logic according to business requirements and implement a series of operations such as customized data extraction, cleaning, sorting, and conversion.

If you are not sure how to use this widget, we have provided 5 code samples to demonstrate its power:

  • Find and replace
  • Data matcher: verify data in the table according to custom rules, such as validating email addresses, finding ID numbers or mobile phone numbers that meet the rules
  • Link records with duplicate values
  • Extract URL from attachment
  • Generate latitude and longitude from IP address
Find and replace

In addition, you can also quickly call any API, supporting various methods such as GET and POST, enabling you to achieve more automation and efficiency in data processing and business process optimization.

Enterprise Plan can be subscribed online

APITable supports self-service subscription upgrade for the Enterprise plan. If you have a higher demand for functional usage, seats, or other value-added services, you are welcome to complete the subscription upgrade in “upgrade” from the space section.

apitable work management integrate with ChatGPT

In addition, after this update, new registered users of APITable can get a 14-day free Pro Trial Plan. You are welcome to experience and make your consumption decision after comparison.

Join the Community

Welcome to read our product changelog and developer documentation for more details about this update.

Join our Discord community to discuss more topics about this update.

Categories
article

How to migrate data from Airtable to APITable in one click

It is very important to choose the right software tools because once you begin to use them, it is almost impossible to switch to another tool, regardless of how much education the team members receive.Data migrate is a scary thing.

However, you don’t have to worry about data migration when you consider switching from Airtable to APITable. Not only because the interface and usage habits are similar, but also because APITable offers a seamless migration experience for users who transfer their data from Airtable to APITable.

With just one click, you can effortlessly move all of your information from Airtable to APITable, saving you time and ensuring a smooth transition. This unique feature eliminates the need for manual data entry and reduces the risk of errors, making it easy for you to switch to APITable and take advantage of its advanced features.

Here, we will outline the general workflow and the steps that should be taken to ensure this process runs smoothly.

What you need

  • An APITable account
  • Widget in APITable: Import Data from Airtable
  • An Airtable account

Step-by-step guide

1. Install the widget

Log in to your APITable account,open widget center and click the widget 「Import Data from Airtable」.

migrate data from Airtable

2. Open the widget

Open the widget, You will find that you need to fill in the API key, base ID, table ID and view ID (optional) of your Airtable account. As a next step, we will do the following.

widget

3. Get Airtable Credentials

Retrieve API Key

You can look through Airtable’s official documentation or click to this website Airtable Account to directly get it.

Retrieve base ID , Table ID and View ID

Base ID, Table ID and View ID (optional) can usually be obtained from the Airtable link.

4. Run the widget

After filling in the corresponding parameters, run the widget to migrate data easily.

Common problems

In the process of data migration, you may encounter the following common problems:

1. Authentication failed

If you receive the following error messages while running the widget:

  • unauthorized, invalid authentication token
  • authentication_required

It means that you provide invalid API key. The solution is to check if the API key used is the same as the API key provided on the Airtable Account page.

2. Permission issues

If you receive the following error messages while running the widget:

  • invalid_permissions
  • Invalid_permissions (field or table operation limits)

It means that you don’t have related permission to import data. The solution is to check if your account is configured with all permissions needed to import the table.

3. Data souce problems

If you receive the following error messages while running the widget:

  • NOT FOUND
  • BASE NOT FOUND
  • MODEL ID NOT FOUND
  • TABLE NOT FOUND:Could not find table tblxxxxxxxx in application appxxxxxxxx
  • VIEW NAME NOT FOUND

It means that corresponding base, table or view are not found. The solution is to check if the base ID, view ID, table ID used are correct.

4. Field types supported for importing

Not all field types are supported for migration.

There are only slight differences between most of the field types in APITable and Airtable. Before importing the data, you have the option of changing the field type. These fields can be modified in Airtable and imported into APITable as text or number.

In APITAble, the following Airtable field types will not be imported:

  • Formula
  • User
  • Lookup
  • Rollup

In contrast, the following Airtable field types will be imported:

  • Attachment
  • Single line text
  • Long text
  • Multiple select
  • Number
  • Rating.Default rating symbol is star.
  • Checkbox
  • Date.Default format is ‘YYYY/MM/DD’
  • URL
  • Currency
  • Percent, with retained 2 decimal places.
  • Phone number
  • Email
  • Single select

Bottom Line

The one-click migration from Airtable to APITable offers a fast, easy, and reliable way to transfer your data, so you can get up and running on APITable in no time.