Build a bot
Getting started
Basics and builder
Variables in Landbot - Getting Started
Builder's keyboard shortcuts and mechanics! 🏗
Builder Interface
How to "debug" (troubleshoot) your bot's flow to spot possible errors (for non coders)
Starting Point
How to disable a bot
Bricks
Bot's Settings
Bot General Settings
Second Visit Settings
Custom System Messages
Hidden Fields (Get params / UTMs from url and use it as variables)
Landbot native SEO & Tracking tools
Typing Emulation (Message Delay)
Build it for me!
Getting started - build a bot
Messages, Questions and Logic & Technical blocks
Messages
Media Block
Media block
How to display images with a variable URL source
How to embed a .gif file inside a message
Different ways to embed Videos in Landbot
Display video and hide button to continue until video has ended
Send a Message block - Simple Message
Goodbye block
Question blocks
Date Block
How to avoid visitors selecting specific days of the week
Question: Date block
How to calculate the number of days between two selected dates
Email Block
Form Block
Scale Block
Buttons block
How to set up Multiple Choice questions
Multi-Question block
Question: Address block
Question: Autocomplete block
Question: File block
Question: Name block
Question: Number block
Question: Phone block
Question: Picture Choice block
Question: Rating block
Question: Text block
Question: URL block
Question: Yes/No block
Logic & Technical blocks
Code Blocks
Dynamic Data
Dynamic Data (Arrays)
Get the array's index of the user selection and extract information from array
Formulas
How to Perform Basic Calculations
Get started with the Formulas block
Formulas Blocks Dashboard
Formulas - Regex
Formulas - Date
Formulas - String
Formulas - Logical
Formulas - Math
Formulas - Object
Formulas - Comparison
Formulas - Array
Persistent Menu
Trigger Automation
Webhook
Webhook Block Dashboard
Webhook block (External API REST)
How to TEST your Http Request (Webhook block)
Landbot System Variables
Set Variable
Any of the above Output
Global Keywords 🌍
Keyword Jump
Lead Scoring block
Jump To block
AB Test
Conditions block
Conditions block II (with Dates, Usage and Agents variables)
Close Chat block
How to ask a question based on a variable not being set (empty URL params)
Business Hours block
Custom Goals
Note block
Share & Embed
Redirect Users
How to open a new URL in another tab (window)
How to redirect visitors to a URL (web only)
Conditional Welcome (Non-embedded bots)
How to add a Click-to-Call/Email/WhatsApp button
Redirect User Based on Language Input (DeepL)
Generate a URL that has variables from user answers
Popup on Exit Intent
Share
Customized Embed Actions
How to redirect user to another url in your site with Livechat open to continue conversation
How to Detect Visitors Browser
Customize and embed your WhatsApp Widget
Modifying Embed Size
Conditional Welcome: Direct the Flow of Your Bot Based on External Parameters
Detect if bot was opened
Customized Behavior in Mobile Browsers
Load script and display bot on click button
Launch Bot On Exit Intent
Display Bot During Business Hours Only (Livechat & Popup)
Open / Close a Web bot (embedded)
Launching a bot depending on browser language
How to pass WordPress logged in user data to Landbot
Set the flow depending on the url path (for embedded landbots)
How to launch a Landbot by clicking a button
Open LiveChat bot as soon as page loads
Detect if a visitor is on Mobile/Tablet or Desktop
Embed
Embed the bot into your Website
Embed Landbot in an iframe
Landbot in Wix
Landbot in your web with Google Tag Manager
Landbot in Webflow
Embed in Sharetribe
Landbot in Shopify
Embedding Landbot in Carrd
Landbot in Wordpress
Landbot in Squarespace
Customizing the Proactive Message
Design section (web bots)
Verification & Security
Account Settings and Billing
Billing
Account Settings
Account Settings
Account Homepage
Dashboard
Common reasons for not receiving account activation email
Privacy and Security
Landbot's Privacy & Security Policies
Compliance with the GDPR - General Data Protection Regulation
Landbot's Abuse Policy - How to Report an Abusive Use of Landbot
Teammates
Agent Status and Log out
Roles & Permissions for Teammates
Teammates - Add extra agents (seats) to your Account
Notifications section
Startup Discounts
NGOs and Educational Organizations Discount
Human Takeover & Inbox
Integrations with Landbot
Native Integrations
Airtable
Airtable integration block
Get data filtered from Airtable with a Brick- Shop example
20 different ways to GET and filter data from Airtable
How to add/update different field types in Airtable (POST, PATCH & PUT)
How to Create, Update, Retrieve and Delete records in Airtable (POST, PATCH, GET & DELETE)
Get more than 100 items from Airtable
Insert Multiple Records to Airtable with a Loop
How to Get an Airtable Token
Advanced filters formulas Airtable block
Airtable usecase: Create an event registration bot with limited availability
Update Multiple Records in Airtable Using a Loop
Reservation bot with Airtable
Calendly
Dialogflow
Dialogflow & Landbot course
Dialogflow & Landbot intro: What is NLP, Dialogflow and what can you do with it?
Dialogflow & Landbot lesson 1: Create your first agent and intent in Dialogflow
Dialogflow & Landbot lesson 2: Get the JSON Key
Dialogflow & Landbot lesson 3: Setting up of Dialogflow in Landbot
Dialogflow & Landbot lesson 4: Training phrases and responses for a FAQ
Dialogflow & Landbot lesson 5: Entities and Landbot variables
Dialogflow & Landbot lesson 6: Redirect user depending on Dialogflow response parameters (intent, entities and more)
Learn more about Dialogflow - Courses and communities
Integrations > Dialogflow Block
How to extract parameters from Dialogflow response with Formulas
Dialogflow Integration Dashboard
Dialogflow in Unsupported Languages (& Multilingual)
Dialogflow - How to get JSON Key
Google Sheets
Google Sheets (Insert, Update and Get data)
How to use Google Sheets to create a simple verification system for returning visitors
How to Upload Document & store link
How to give unique Coupon Codes (with Google Spreadsheets)
Google Sheets Integration Dashboard
How to insert a new row with data and formulas in Google Sheets
How to use Google Spreadsheet as a Content Management System for your bot
Hubspot
MailChimp
Salesforce
Segment
SendGrid
Slack
Stripe
Zapier
Zapier block
Zapier Integration Dashboard
How to insert a row to Google Spreadsheet by Zapier
How to generate a document with PDFMonkey by Zapier
Send WhatsApp Message Templates from Zapier
How to send an email with Gmail by Zapier
Get Opt-ins (Subscribers) from Facebook Leads using Zapier
How to extract data from an external source with Zapier and use it in Landbot
Zapier trigger
How to complete a digital signature flow by Zapier
Make a survey with Landbot and display the results in a Notion table using Zapier
Zendesk
Non-Native Integrations
ActiveCampaign
Google Calendar
Google Fonts
Google Maps
Embed Google Maps
Google Maps API Key for Address block
Extract Data With Google Maps Geocoding API
Calculate Distances With Google Maps API
Google Meet
IFTTT
Integrately
Intercom
Make
Connecting MySQL with Make.com (formerly Integromat)
How to upload a file to Google Drive using Make.com (formerly Integromat)
Send WhatsApp Message Template from Make (ex Integromat)
Make.com (formerly Integromat) trigger
How to send an email through Sendinblue by Make.com (formerly Integromat)
Get Opt-ins (Subscribers) from Facebook Leads using Make (ex Integromat)
How to extract data from an external source with Make.com and use it in Landbot
OCR
Pabbly
Paragon
Pipedream
PDF Monkey
Store Locator Widgets
Xano
Zendesk
WhatsApp Channel
Getting started!
WhatsApp Testing
Build a WhatsApp Bot - Best Practices and User guide
Build a WhatsApp Bot - Best Practices for Developers
Types of Content and Media you can use in WhatsApp 🖼
1. WhatsApp Article Directory
2. WhatsApp Integration FAQ's
Adding & Managing your WhatsApp Channel
Facebook Business Verification - Best Practices 🇬🇧
WhatsApp Number Deletion (WA Channel management)
Adding a WhatsApp number to your account
WhatsApp’s Messaging Policy: New Accepted Industry verticals
Meta processes guide: FBM verification, Official Business Account (OBA) requests, Appeals
Additional Number integration: Limitations and Requirements (Number integration)
Existing WhatsApp Number Migration
Key Insights for Migrating to WhatsApp Business API Cloud
How to's, Compatibility & Workarounds
WhatsApp bots - Feature Compatibility Guide
WhatsApp - How to direct a user through a different bot flow on their second visit
WhatsApp - Get user out of error message loop
Getting Subscribers: Opt-in, Contacts
How to get Opt-ins (Subscribers) for your WhatsApp 🚀
WhatsApp Quality - Best Practices
Opt-In block for WhatsApp 🚀
Opt-in Check Block
WhatsApp Channel Settings
Parent Bot/Linked Bot - Add a main bot to your WhatsApp number
WhatsApp Channel Settings
Growth Tools for WhatsApp
Duplicating bots
Messaging and contacting your users
WhatsApp Campaigns 💌
WhatsApp's Message Templates
Audience block
WhatsApp Marketing Playbook: Best Practices for Leadgen
Audiences
WhatsApp for Devs
How to calculate the number of days between two selected dates (WhatsApp)
Creating a Loop in WhatsApp
Recognise the users input when sending a Message Template with buttons
Trigger Event if User Abandons Chat
Calculate Distances in WhatsApp
Send Automated Message Templates based on Dates
Trigger Event if User Abandons Chat Using AWS
reply from Slack: How to create an integration to allow agents reply WhatsApp users from Slack (with Node JS)
Set Up a Delay Timer in Bot
Notify Teammates of Chat via WhatsApp
Native blocks for WhatsApp
Other Channels - Messenger and APIChat
Facebook Messenger
The Facebook Messenger Ultimate Guide
Types of content you can use in Messenger bots 🖼
How to Preview a Messenger bot
Facebook Ad connected to Messenger Bot
API Chat (for Developers)
AI in Landbot
Non-native AI Features
Create a JSON format response from OpenAI in WhatsApp
Connect OpenAI Assistant with Landbot
AI in WhatsApp
How to build a FAQ chatbot with GPT-3
GPT-4 in Landbot
OpenAI
Prompt Engineering for GPT-3
Build a Customer Service Bot with ChatGPT and Extract Information
Native AI Features
Metrics and Data Management
Metrics Section
How to export the data from your bots
Export data: How to open a CSV file
Bot's Analyze Section
For Developers & Designers
JavaScript and CSS
CSS and Design Customizations
Design Customizations
Advanced (Custom CSS & Custom JS)
Components CSS Library Index
Background Class CSS
Identify Blocks CSS
Buttons Class CSS
Header Class CSS
Media Class CSS
Message Bubble Class CSS
Miscellaneous Classes CSS
CSS Customization Examples: "Back to School" Theme
Get started guide for CSS Design in Landbot
CSS Customization Examples: Call To Action: WhatsApp
CSS Examples: Lead Gen
CSS Customization Examples: "Translucid"
CSS Customization Examples: "Minimalist" Theme
Dynamic Data CSS
Form Block CSS
CSS for Typewriter Effect
CSS Customization Examples: Carrd Embed Beginner
Dynamically Change a Bot's Background
Proactive Message Customizations with Javascript and CSS
Landbot v3 - Web CSS - RTL
Multi Questions CSS
CSS Customization Examples: Video Bubble
Dynamically Change Any Style
CSS Customization Examples: CV Template
Change Landbot custom CSS dynamically from parent page onload
Widget/Bubble Customizations with Javascript and CSS
JavaScript
How to change Avatar dynamically (Landbot v3)
Javascript in WhatsApp
Javascript in Landbot v3
Different ways to format numbers with JS
How to display an HTML Table and a List in Landbot v3 web
Trigger a Global Keyword with JS (web v3)
Create Dynamic Shopping Cart with JS and CSS
Add a Chart (with Chart JS library) in your Landbot
Different ways to format numbers with JS (WhatsApp)
Pop up modal to embed third party elements
Landbot API
Send WhatsApp Messages with Landbot API
How to "send" a user to a specific point in the flow with Javascript and with the API
APIs
Create Contacts (Opt-ins) using Landbot API
MessageHooks - Landbot Webhooks
Resume flow based on external process with Landbot API (Request, Set, Go)
Tracking
Google Analytics - Track Events (Not embedded)
Google Analytics - Track Events (Embedded)
Meta Pixel - Track Events (only Embedded)
How Track Google Analytics Events in Landbot with Google Tag Manager (GTM)
Google Adwords - How to track Google Adwords in Landbot
Set a timer to get the time spent during the flow
Workarounds and How To's
Workflows
Simple cart v0.2
How to build an event registration Landbot (to be used in one screen by many attendees) (web only)
How to let user select a time of booking (with a minimum 45 minutes notice)
Send Files Hosted in Landbot to Your Google Drive with Make
Two-Step Email Verification
Skip the Welcome Message
Fixing Web Bot Loading Issues for iOS Devices in Meta Campaigns with Disclaimers
Progress Bar Workaround
How to set up questions with a countdown
Creating a Simple Cart in WhatsApp
More Topics
Table of Contents
- All Categories
- Integrations with Landbot
- Native Integrations
- Airtable
- How to add/update different field types in Airtable (POST, PATCH & PUT)
How to add/update different field types in Airtable (POST, PATCH & PUT)
Updated by Pau Sanchez
Airtable is a great tool where you can store the collected information. Below you will find the different steps to set up a Request with our Webhook block and a list of types of fields that can be updated (and how) via API with the POST, PATCH, and PUT methods.
Basics
Here we will explain step by step, how to set up the Webhook block
0. How to get URL (Airtable's App ID) and the Authorization (API Key)
We will get the information from the Airtable API Documentation, and set it in the Webhook according to the steps we will show in this article.
In Airtable, first we need to go to the API documentation option in the Help section:
Then, once in the API documentation, click on the Authentication option:
1. Webhooks URL and Method
You must get the App ID in Airtable to build the Webhook's URL. It should look like the following:
https://api.airtable.com/v0/<app_id>/<nameofthebase>
In the examples below we used the following URL:
https://api.airtable.com/v0/appzYrKqRzqbYCGi9/Furniture
This is how it will look in your Webhook:
It consists of 2 parts:
- The Base we are using is called Furniture, so the end of our URL is Furniture
- The Base App Id is appzYrKqRzqbYCGi9
2. Webhook's Header (Authorization)
To set up the Webhook's Header (Authorization), you must get the API Key in Airtable.
To get an Airtable API Key, repeat the same process to get to the API Documentation, but this time click on this option:
Then, under the line where you located the APP ID, you will see the API KEY just after "Authorization":
Please copy from "Bearer" until the end of the text:
This is how it should look in the Webhook block:
3. How to set up the body of the request (build the JSON)
Make sure is a valid JSON, you can use tools like https://jsonformatter.curiousconcept.com/
Fields need to be previously set up in Airtable and format and names must be consistent with the ones in such setup. Spelling mistakes, capitals, and lowercases or special formats must be equal in the JSON body and in Airtable. Any change will make the request invalid and stop working
Create a record (POST)
We use the POST method to create a new record.
Sample POST body:
{
"records": [
{
"fields": {
"email_field": "an@email.is",
"number_field": "@number",
"checkbox_field": "@trueorfalse"
}
}
],"typecast": true
}
Update a record (PATCH and PUT)
As Airtable explains:
- "PATCH request will only update the fields you specify"
So it will change or add all the values you use in the body
- "A PUT request will perform a destructive update and clear all unspecified cell values."
So it will update the fields that you add and delete all the fields not present in the body
Sample PATCH or PUT body:
It is important that if you are planning to update first, you need to know which recorded you are planning to. So the first thing to do is to find out the record id of such record.
{
"records": [
{
"id":"<recordid>"
"fields": {
"email_field": "an@email.is",
"number_field": "@number",
"checkbox_field": "@trueorfalse"
}
}
],"typecast": true
}
Force format: "typecast":true
Airtable forces us to use the correct type of formats (string, number, array, boolean...) otherwise the request will fail. However, if we use the "typecast": true method, even if we send the wrong type of format like a string when Airtable is expecting a number or a boolean value, will still accept it.
To do so here is an example of the body that has the typecast method:
{
"records": [
{
"fields": {
"email_field": "an@email.is",
"number_field": "@number",
"checkbox_field": "@trueorfalse"
}
}
],"typecast": true
}
With this setup, even if @number and @trueorfalse, are sent as Strings, Airtable will accept them and transform them to the correct format.
Be aware of the location of the "typecast" key, that is after the records array.
Setup by Field type (via API)
Link to another record
Required type of value: Array
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"link_to_another_record_field": [ "recFwClGZhOA34PrP" ]
Note: In this case, the value "recFwClGZhOA34PrP" is the record id of the record that is in the other table. You must have such value before in Landbot, by getting the record id previously via API request or as a static value.
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
There are 2 ways:
1. If the variable (@record_id) is a variable type String with the value of the record id:
"link_to_another_record_field": ["@record_id"]
Example of a Request Body to create a record (POST):
Example of a Request Body to update a specific record (PUT or PATCH):
2. If the variable (@record_ids) is a variable type Array that already contains the string (or strings) with the record id:
"link_to_another_record_field": "@record_ids"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Note that the length of the array depend on the field set up if it allows multiple records or not.
Single line of text
Required type of value: String
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"single_line_text_field": "single line text"
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@singlelinevariable) is a variable type String with a value:
"single_line_text_field": "@singlelinevariable"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Long text
Required type of value: String
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"long_text_field": "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, q..."
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@long_text) is a variable type String with a value:
"long_text_field": "@long_text"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Attachment
Required type of value: String (url where the file is hosted)
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"attachment_field": [{"url": "https://upload.wikimedia.org/wikipedia/commons/thumb/7/73/Leonardo_da_Vinci_-_Mona_Lisa_%28Louvre%2C_Paris%29.jpg/1200px-Leonardo_da_Vinci_-_Mona_Lisa_%28Louvre%2C_Paris%29.jpg"}]
How to set up in the JSON Body using Landbot variables
The variable (@url_picture) is a variable type String with a value:
"attachment_field": [{"url": "@url_picture"}]
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Checkbox
Required type of value: Boolean (true or false), you can use String in Landbot
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"checkbox_field": true
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@url_picture) is a variable type String with a value:
"checkbox_field": "@trueorfalse"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Multiple select
Required type of value: Array of string/s
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"multiple_select_field": [ "option1", "option2" ]
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@array_options) is a variable type Array with a value of string or strings inside, the value of @array_options for this example is: ["option1", "option2"]
"multiple_select_field": "@array_options"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Single select
Required type of value: String
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"single_select_field": "in progress"
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@single_option) is a variable type String with a value:
"single_select_field": "@single_option"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Date
Required type of value: String (ISO-8601 date)
- If you want to send Date only you can do it like this: 2020-08-05 (YYYY-MM-DD)
- If you want to send Date&time you have to do it like this: 2020-08-05T16:28:00.000Z
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"date_field": "2020-08-05T16:28:00.000Z"
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@datetime) is a variable type String with a value:
"date_field": "@datetime"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Phone number
Required type of value: String
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"phone_number_field": "(415) 555-9876"
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@phone) is a variable type String with a value:
"phone_number_field": "@phone"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Required type of value: String
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"email_field": "an@email.is"
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@email) is a variable type String with a value:
"email_field": "@email"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
URL
Required type of value: String
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"url_field": "https://landbot.io/"
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@url) is a variable type String with a value:
"url_field": "@url"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Number
Required type of value: Number
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"number_field": 12345
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@number) is a variable type Number with a value:
"number_field": "@number"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Currency
Required type of value: Number
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"currency_field": 123.45
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@amount) is a variable type Number with a value:
"currency_field": "@amount"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Percent
Required type of value: Number.
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"percent_field": 12.34
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@percent) is a variable type Number with a value:
"percent_field": "@percent"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Duration
Required type of value: Number
Depending on the set up of the field (if is by minutes or seconds) you will need to make adjustments of the units. For example in this set up:
Duration will be the amount of seconds. So 10 minutes, will be 10*60 = 600
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"duration_field": 45240
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@duration) is a variable type Number with a value:
"duration_field": "@duration"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Rating
Required type of value: Number
In the table:
In the Webhook Block (JSON Body):
The key and the value:
"rating_field": 3
Example in the JSON Body (using static values)
How to set up in the JSON Body using Landbot variables
The variable (@rating) is a variable type Number with a value:
"rating_field": "@rating"
Example of a Request Body to create a record (POST):
Example of a Request Body to update a record (PUT or PATCH):
Field types that CANNOT be edited via API
The following list are the type of fields that cannot be update via API:
- Formula
- Rollup
- Count
- Lookup
- Created time
- Last modified time
- Created by
- Last modified by
- Autonumber
- Barcode
- Button
How to add/update different field types in the Airtable block (POST, PATCH & PUT)
Here are the options we have with the Airtable block:
To use the POST method you just need to select 'Add a record', you will then be prompted to enter the information via dropdowns, so you won't need to create any new formulas.
If you select 'Update a record', you will have the chance to filter and select the record you want to update.
One thing to keep in mind is that only the first match will be updated:
For more complex methods you can use the 'Advanced' filter, which will allow you to enter formulas.
Here's more information on that