AIRTABLE ACADEMY QUIZZES - Study Guide

Question:
Which of the following statements about Airtable are true? (Select all that apply)

Answer:
Airtable's core is a relational database that allows for structuring and connecting business data.

Airtable is a no-code platform that allows builders to create apps without writing code.

Question:
Which of the following statements are true about Airtable apps?

Answer:

Interfaces are built on top of a base and can have multiple pages.

Question:

Which of the following statements about workspaces in Airtable are true? (Select all that apply)

Answer:

Moving a base to a different workspace will also move all related interfaces.

A workspace can have multiple owners.

Users with access to a workspace can access all apps within it.

Question:

True or False? End users build apps.

Answer:

False

Question:
What is a workspace?

Answer:

A workspace houses a collection of bases and interfaces between a group of collaborators

Correct. A workspace houses a collection of bases and interfaces between a group of collaborators

Question:

True or False: The features available to your app, is based on the pricing plan and add-ons that the workspace is on.

Answer:

True

The right answer is true - Pricing plans are set on a workspace level and all bases and interfaces within the workspace will have access to whatever the workspace pricing plan offers. If you move a workspace from a Free workspace to an Enterprise workspace, your base will suddenly have more features available as a result.

Question:

True or False: Workspace collaborators have access to all bases and interfaces within the workspace

Answer:

True

True: Workspace collaborators automatically have access to all bases and interfaces that reside in that workspace. If you want to avoid this, you can invite collaborators to a specific base or interface within a workspace.

Question:

True or False: An interface can have multiple bases.

Answer:

False

An interface can only have one base. A base, however, can have multiple bases built on top of it, which in turn can include multiple interface pages. The base holds all the data that the interface uses. If you need data from a different base, it is possible to sync a table from another base to the underlying base.

Question:

Can you move an interface to another workspace without the underlying base?

Answer:
No, you can only move bases to other workspaces. All interfaces built on top of the base will follow to the new workspace.

You can only move bases to other workspaces. All interfaces built on top of the base will follow to the new workspace. Interfaces cannot exist independently of their underlying base, however, you can invite users to collaborate with you only on the interface and they will not be able to see the underlying base.

Question:

Which user persona are you? You might identify with more than one, in which case, list your primary persona.

Answer:

Your response:Builder

Question:

If you have commenter access to an interface, can you share the interface with somebody else and give them editor permission level?

Answer:

No, you can only set a commenter or read-only permission level when sharing the interface with somebody else. If your permission level is 'commenter', then you can only set commenter or read-only permission level when sharing the interface with somebody else.

Question:

Which of these surfaces might the builder use?

Answer:

Workspace settings

Base (creator access)

Interface Designer
Automations panel

Builders with Owner permission level would use the workspace settings. All builders need creator access to the base which automatically grants them access to the automations panel and Interface Designer. While Builders have access to the published interfaces, they do not interact with the data here. The same user, however, might both be a builder and an end user in the same app and interact in the published interface in their capacity as an end user.

Question:

How can you tell which permission level you have been granted to a specific base or interface?

Answer:
If you click to share the base or interface in question, you can tell what your own permission level is by looking at what permission level you can offer to others. The highest level available is the one you have.

If you click to share the base or interface in question, you can tell what your own permission level is by looking at what permission level you can offer to others. The highest level available is the one you have.

Question:

Which of these permissions could an end-user have?

Answer:

Editor

Commenter

Read-only

An end user can either have editor, commenter or read-only permission depending on what their role is. Some end-users will need the ability to edit the data in the app, whereas others will just need the ability to comment or view the data.

Question:

If a user is in charge of designing interfaces, which type of permission privileges should they have?

Answer:

Creator - It’s in the name, they ‘create’ the interface for other users

Creators have creator access to the interface and can therefore access interface designer which allows them to create, design and delete interfaces for end users.

Question:

Can a user have a lower permission level on the base than what they have on the interface? Ie. can a user have editor permission to the interface but only commenter access to the underlying base?

Answer:
Yes, a user with commenter permissions to the base will automatically be given commenter permission to the interfaces as well, but it is possible to upgrade them to editor on the interface while keeping the lower level of commenter in the base. However, if the user has creator privileges in the base, their interface privileges are locked at creator.

Question:

Can a user have access to a workspace and only the interfaces within the workspace?

Answer:
No, when you share a workspace with other users they automatically inherit access to everything within the workspace which includes all bases and interfaces.

There is no way to choose whether workspace collabor ators should have access to either interfaces or bases. All bases within the workspace will be accessible by all workspace collaborators.

Question: Describe a workflow in your own words

Answer: A system that is a collection of data and processes

Question:

What persona types are Felicia, Bailey and Jac?

Answer: End-users. They are end users, because they don’t decide how the app should look but they know how to use the part of the app that is relevant to them and their steps in the workflow

Question:

What permission level do Felicia, Bailey and Jac have?

Answer:

With editor privileges they can edit data in the interfaces but not change the overall design of the interface.

Question:

How come Felicia, Bailey and Jac can’t see each others interfaces?

Answer:

They are part of the same app, but the different interfaces have only been shared with the relevant people, ie. IT Coordination has not been shared with Felicia or Jac because it is not relevant to their roles.

That's right, the different interfaces have been shared only with those who need to see them.

Question:

Which layer is this the definition for?
"This is the automations and formulas added to the data to add efficiency to the workflow"

Answer:

Logic layer

Question:

What makes a table different from a sheet in a spreadsheet document?

Answer:

That's right, it is all of the above.

Question:

What is the primary field?

Answer:
The name of the record which cannot be deleted and it ought to be unique.

That's right, the primary field is the name of the record which cannot be deleted and ought to be unique.

Question:

As an end user, which data layer components do you interact with when editing the data?

Answer:

The data in the fields and the creation and deletion of records

That's right. As an end user you would interact with the data in the fields and the creation and deletion of records. Only the builder can create and delete fields and tables.

Question:

What is the difference between a page and an Interface?

Answer:

The interface is just the holder of the pages. Permission settings are determined by the interface. Users with access to the interface has access to all the pages within it.

That's right, the interface is the holder of pages.

Question 6:

What is the difference between having editor permission and creator permission to an interface?

Answer:

End users have editor permission and that means they can edit the data in the interface according to how the creator has designed it. Creators have access to Interface Designer and can design the interface pages according to a workflow map, determining which data the end user with editor permission should be able to change.

That's right, end users have editor permission and that means they can edit the data in the interface according to how the creator has designed it.

Question:

In which layout can end users move records from one stack to another?

Answer:

Kanban layout

The kanban layout lets end users move records from stack to another (if this action has been enabled by the builder).

Question:

What option does the user have when deciding who can access the interface under "General Access"?

Answer:

Share the interface with the entire organization at either commenter or read-only permission levels.General Access allows users (who are members of the organization) to share the interface with the entire organization at either commenter or read-only permission level.

Question:

True or False: Even if you are an end user with editor permissions to an interface you won't necessarily be able to edit all the fields. The builder determines what can and cannot be edited through 'user actions' that are set in Interface Designer.

Answer:

True

Question:

What action can a user with creator access take if they want to give another user creator permission to an interface?

Answer:

Navigate to the underlying base and share the base with the user and picking 'Creator' as permission level.

It it not possible to share just an interface with another user and give them creator permission. If you want to give another user creator permissions to your interface, you need to invite them as creator to the underlying base.

Question:

What can end users do when the builder enables the search option?

Answer:

Search within the records shown

Question:

True or False: If another user has requested access to an interface, it is only possible to grant them read-only access, even if you have editor access yourself.

Answer:

False

If you have a permission level higher than read-only, you will be able to grant other users a higher permission level - although requests do default to 'read-only'.

Question:

What does the builder determine when designing a page in the interface?

Answer:

The source data for the interface page

The layout to visualize the data

When designing a page in the interface the builder needs to pick the source data and a layout to visualise it in the page. The builder can also change the color scheme of the interface, but that is not part of the page design specifically.

Question:

If 'add/delete record inline' has been enabled by the builder, how can end users add new records in a timeline layout?

Answer:

By clicking and dragging to create a new record

Question:

True or False? The order of records within a table in a relational database does not matter.

Answer:

TRUE

One of the key differences between relational databases and traditional spreadsheets is the flexibility it provides when it comes to how data can be displayed. You can reorder records, look at a specific filtered subset of records, or even visualize your records in numerous formats.

Question:

You oversee a project management team at your organization, and when mapping your workflow to Airtable, you define your goal as the following:

"...we want to track progress and streamline collaboration, when we manage projects, so we can save time and improve visibility for our team and our leaders..."

Which of the following refers to the component: "save time and improve visibility for our team and our leaders"?

Answer:

Positive Business Outcome. Defining your workflow goal comes down to three components in a singular statement: your goal, your workflow, and your positive business outcome.

Question:

When building your stakeholder register, which of the following labels refers to your super users who both engage with this workflow daily and have the knowledge and experience required to review your Airtable app at specific points to provide feedback?

Answer:

Workflow End User Tester(s)

Your end user testers are the ones knowledgeable enough to be able to thoroughly review your Airtable app, provide actionable feedback, and ultimately sign-off on what you've created.

Question:

You're setting up an Airtable base to track your team's product feature release workflow and you want to track the status of each feature that gets added to the roadmap—which includes "Research", "In Development", "Testing", "In Review", and "Released".

Which field type should you choose?

Answer:

Single select

Single select fields are ideal for when you need to select a single option from a preset list of options.

Question:

What is the purpose of the Data Library in Airtable?

Answer:

To manage and sync verified datasets across the organization

The purpose of the Data Library is to manage and sync verified datasets across an organization.

Question :

What does Airtable Sync allow you to do?

Answer:

Sync records from other sources into your Airtable base

Airtable syncs records from other sources into your Airtable base.

Question:

What is Airtable Community?

Answer:

The Airtable Community is an online platform where users can engage with each other, ask questions, share knowledge, showcase their work, and collaborate on projects related to using Airtable.

Question:

What is the benefit to managed apps and components within the App Library?

Answer:

Components and Managed Apps enable process standardization, process visibility and management at scale, and accelerated building within an organization, optimizing workflow efficiency and collaboration.

Components and Managed Apps enable process standardization, global process visibility, app management at scale, and accelerated building within an organization, optimizing workflow efficiency and collaboration.

Question:

True or False: You can only add one condition to a filter when setting up a filter for a view in your table?

Answer: False. You can add multiple conditions (and even condition groups) when setting up filters.

Question:

What are workflow templates?

Answer:

Bundles of Airtable functionality, including automations that help boost the efficiency of workflows

Workflow templates are bundles of Airtable functionality, including automations that help boost the efficiency of workflows by providing pre-configured setups for common processes

Question:

Where can you find the option to add new interfaces and pages?

Answer:

In the Pages panel

You can click the plus sign in the Pages panel to add new interfaces and pages to your app.

Question:

True or False: You can prevent external users from seeing each other in the interface settings (the three buttons next to the interface in the Pages panel).

Answer:

True

Question:

Which of these options are NOT available for the builder under 'User actions' in the page properties panel for a visualization layout (ie. List, Gallery, Kanban, Calendar or Timeline)?

Answer:

Edit records inline

It is the 'Edit records inline' that is only available when clicking on the visualization, not when looking at the properties panel for the whole page.

Question:

True or False: In a visualization layout, you can edit a field directly from the Field properties panel. You don't have to go to the data layer.

Answer:

True

You can edit a field directly in Interface Designer by going to the field's properties panel or clicking on the three dots that appear next to the field when hovering over it directly on the canvas.

Question:

Which of these is NOT an option for button action for Page buttons (as opposed to Record Detail buttons)?

Answer:

Delete record

Only record detail buttons can have the 'Delete record' button action.

Question :

True or False: You cannot click into a second Record Detail for a linked record in a Record Detail.

Answer:

False.

You can click into a second Record Detail for a linked record in a Record Detail if this has been enabled in the Record Detail Layout properties panel.

Question:

Which of the following are available triggers for Airtable automation? Select all that apply.

Answer:

When a record matches conditions

When a form is submitted

When a record is updated

When a button is clicked

These are all available triggers for Airtable automations.

Question:

True or false? While an automation can have multiple actions, it can only have one trigger.

Answer:

True

Each automation can only have one triggerr.

Question:

You oversee the field marketing function at your organization and you're using Airtable to track RSVPs for an upcoming event. You want to set up an automation to send a confirmation email to attendees when their status is manually changed to 'Confirmed' by their sales rep.

Which of the following actions will be added to your automation?

Answer:

Send email

Correct! Based on the use-case, you want to use the "Send an email" action in your automation.

Question:

Which of the following platforms does NOT have an integrated action available for Airtable automation?

Answer:

HubSpot

Although not the full list, the apps you've selected all have integrated actions available for Airtable automation.

Question:

You run classroom-style bootcamp events for your company and use Airtable to track student enrollment in various classes. You want to quickly see how many students are enrolled in each bootcamp without having to tally them manually.

Which field type would be most appropriate to use for this purpose?

Answer:

Count

A count field simply counts the number of records in a linked record field.

Question:

You're managing a sales team and using Airtable to track sales data. Each salesperson has multiple sales records, each with a dollar amount. You want to calculate the total revenue generated for each salesperson without having to add up the sales manually.

Which field type would be most suitable for this task?

Answer:

Rollup

Remember, you want to use the field that enables you to apply functions to this data—like the SUM() function.

Question 3:

You're on your company's Field Marketing team and you use Airtable to manage your customer events. For each event, you have multiple vendors providing services—and each vendor record includes the name of the vendor's contact person. You want to display this contact person's name in the event record without having to type it in manually.

Which field type would be best to use in this scenario?

Answer:

Lookup

Which field type is most useful when you want to cross-reference information that's stored in separate tables?

Question 1:

You want to create a simple expression that alerts your team when the total price of an item is greater than, or equal, to, $100. Which of the following operators would you use in your formula?

Answer:

The operator >= allows you to compare if one number is greater than or equal to another.

Question:

True or False? To reference another field from your table in your formula field, you should use (Parentheses).

Answer:

FALSE

You should use {Curly Brackets} when referencing a field name in your formula.

Question:

All of the following are common mistakes to look out for when encountering an #ERROR message output from your formula EXCEPT:

Answer:

An emoji included in a text string output

Remember, you want to review the structure of your formula for any mistakes.

Question:

True or False? The NOW() function is preferred over the TODAY() function for optimizing base performance due to its frequent updates.

Answer:

FALSE

The TODAY() function is preferred for base optimization and minimized load times because of the more frequent updates being performed by the NOW() function.

Question:

True or False? You can use multiple operators within each logical argument in nested IF() statements.

Answer:

FALSE

Each logical argument can only have one operator.

Question:

True or False? An IF() statement can only perform comparisons between numerical values using 'greater than' or 'less than' operators.

Answer:

FALSE

IF() statements can use a range of operators beyond just 'greater than' and 'less than'.

Question:

What is the primary benefit of using the SWITCH() function over nested IF() statements?

Answer:

SWITCH() is easier to read and maintain due to less nesting.

The SWITCH() function can be a significant time-saver when you’re working with conditional-heavy formulas (like nested IF() statements).

Question:

What does the AND() function return when all its conditions are met?

Answer:

'1'

Although the AND() function returns true if all the arguments are true, it's represented by a '1' (whereas false is represented by a '0').

Question:

Which statement best describes the OR() function's behavior in formulas?

Answer:

It returns "1" if at least one condition is true.

Whereas the AND() function returns '1' if all evaluated conditions are true, the OR() function only needs one of the conditions to be true to return a '1'.

Question:

What is the primary use of the BLANK() function in Airtable?

Answer:

To identify or output an empty value in a field.

The BLANK() function is used to identify an empty value in a field or output an empty value in a formula.

Question:

True or False? Using empty quotes ("") and the BLANK() function in a formula will yield the same result.

Answer:

TRUE

Both empty quotes and the BLANK() function will yield the same result—a blank value.

Question:

Fill in the blank: the __________ function joins together arguments and/or field values from any number of fields into a single text value

Answer:

CONCATENATE()

Question:

From a data hygiene and uniformity perspective, you want to ensure that all of the emails captured in your {Business Email} field (via an Airtable form) are all lowercase.

Which of the following formulas would you use to accomplish this?

Answer:

LOWER()

Question:

True or False? Whereas the REPLACE() function will replace a single instance of a defined amount of text, the SUBSTITUTE() function will replace all examples of the defined text.

Answer:

True

Question:

What is the main purpose of repeating groups in Airtable automations?

Answer:

To loop through a set of actions for each item in an input list.

Question:

What is the primary benefit of using conditional groups in Airtable automations?

Answer:

They enable you to change the course of your automation based on previous triggers or actions.

Question:

Which of the following best describes the use of conditional logic in Airtable automations?

Answer:

It allows you to create rules and conditions to determine actions based on specific criteria.

Question:

They centralize data that can update multiple base locations at once

They help reduce content sprawl by providing a single source of truth?

Answer:

Editor

With editor privileges they can edit data in the interfaces but not change the overall design of the interface.

Question:

How come Felicia, Bailey and Jac can’t see each others interfaces?

Answer:

That's right, the different interfaces have been shared only with those who need to see them.

Question:

Which layer is this the definition for?
"This is the automations and formulas added to the data to add efficiency to the workflow"

Answer:

Logic layer

Question:

What is the primary field?

Answer:

The name of the record which cannot be deleted and it ought to be unique.

That's right, the primary field is the name of the record which cannot be deleted and ought to be unique.

Question:

As an end user, which data layer components do you interact with when editing the data?

The data in the fields and the creation and deletion of records

Answer:

As an end user you would interact with the data in the fields and the creation and deletion of records. Only the builder can create and delete fields and tables.

Question:

What is the difference between a page and an Interface?

Answer:

The interface is just the holder of the pages. Permission settings are determined by the interface. Users with access to the interface has access to all the pages within it.

The interface is the holder of pages.

Question:

What is the difference between having editor permission and creator permission to an interface?

Answer:

End users have editor permission and that means they can edit the data in the interface according to how the creator has designed it.

Question:
In which layout can end users move records from one stack to another?

Answer:

Kanban layout

The kanban layout lets end users move records from stack to another (if this action has been enabled by the builder).

Question:

What option does the user have when deciding who can access the interface under "General Access"?

Answer:

Share the interface with the entire organization at either commenter or read-only permission levels.

General Access allows users (who are members of the organization) to share the interface with the entire organization at either commenter or read-only permission level.

Question:

Answer:

True

Question:

What action can a user with creator access take if they want to give another user creator permission to an interface?

Answer:

Navigate to the underlying base and share the base with the user and picking 'Creator' as permission level.

Question:

What can end users do when the builder enables the search option?

Answer:

Search within the records shown

Question:

True or False: If another user has requested access to an interface, it is only possible to grant them read-only access, even if you have editor access yourself.

Answer:

False

if you have a permission level higher than read-only, you will be able to grant other users a higher permission level - although requests do default to 'read-only'.

Question:

What does the builder determine when designing a page in the interface?

Answer:

The source data for the interface page

The layout to visualize the data

Question:

If 'add/delete record inline' has been enabled by the builder, how can end users add new records in a timeline layout?

By clicking and dragging to create a new record
True or False? The order of records within a table in a relational database does not matter.

Answer:

TRUE

Question 2:

Which of the following refers to the component: "save time and improve visibility for our team and our leaders"?

Answer:

Positive Business Outcome

Defining your workflow goal comes down to three components in a singular statement: your goal, your workflow, and your positive business outcome.

Question

Answer:

Workflow End User Tester(s)

Your end user testers are the ones knowledgeable enough to be able to thoroughly review your Airtable app, provide actionable feedback, and ultimately sign-off on what you've created.

Question:

Which field type should you choose?

Answer:

Single select

Single select fields are ideal for when you need to select a single option from a preset list of options.

Question:

What is the purpose of the Data Library in Airtable?

Answer:

To manage and sync verified datasets across the organization

The purpose of the Data Library is to manage and sync verified datasets across an organization.

Question:

What does Airtable Sync allow you to do?

Answer:

Sync records from other sources into your Airtable base

Airtable syncs records from other sources into your Airtable base.

Question:

What is Airtable Community?

Answer:

The Airtable Community is an online platform where users can engage with each other, ask questions, share knowledge, showcase their work, and collaborate on projects related to using Airtable.

Question:

What is the benefit to managed apps and components within the App Library?

Answer:

Question:

True or False: You can only add one condition to a filter when setting up a filter for a view in your table?

Answer:

False

you can add multiple conditions (and even condition groups) when setting up filters.

Question:

What are workflow templates?

Answer:

Bundles of Airtable functionality, including automations that help boost the efficiency of workflows

Workflow templates are bundles of Airtable functionality, including automations that help boost the efficiency of workflows by providing pre-configured setups for common processes

Question:

Where can you find the option to add new interfaces and pages?

Answer:

In the Pages panel

You can click the plus sign in the Pages panel to add new interfaces and pages to your app.

Question:

True or False: You can prevent external users from seeing each other in the interface settings (the three buttons next to the interface in the Pages panel).

Answer:

True

Question:

Which of these options are NOT available for the builder under 'User actions' in the page properties panel for a visualization layout (ie. List, Gallery, Kanban, Calendar or Timeline)?

Answer:

Edit records inline

It is the 'Edit records inline' that is only available when clicking on the visualization, not when looking at the properties panel for the whole page.

Question:

True or False: In a visualization layout, you can edit a field directly from the Field properties panel. You don't have to go to the data layer.

Answer:

True

You can edit a field directly in Interface Designer by going to the field's properties panel or clicking on the three dots that appear next to the field when hovering over it directly on the canvas.

Question:

Which of these is NOT an option for button action for Page buttons (as opposed to Record Detail buttons)?

Answer:

Delete record

only record detail buttons can have the 'Delete record' button action.

Question:

True or False: You cannot click into a second Record Detail for a linked record in a Record Detail.

Answer:

FALSE.

You can click into a second Record Detail for a linked record in a Record Detail if this has been enabled in the Record Detail Layout properties panel.

Question:

Which of the following are available triggers for Airtable automation?

Answer:

When a record matches conditions

When a form is submitted

When a record is updated

When a button is clicked

These are all available triggers for Airtable automations.

Question:

True or false? While an automation can have multiple actions, it can only have one trigger.

Answer:

True
Each automation can only have one triggerr.

Question:

Which of the following actions will be added to your automation?

Answer:

Send email

Based on the use-case, you want to use the "Send an email" action in your automation.

Question 4:

Which of the following platforms does NOT have an integrated action available for Airtable automation?

Answer:

HubSpot

Although not the full list, the apps you've selected all have integrated actions available for Airtable automation.

Question:

Which field type would be most appropriate to use for this purpose?

Answer:

Count

A count field simply counts the number of records in a linked record field.

Question:

Which field type would be most suitable for this task?

Answer:

Rollup

Remember, you want to use the field that enables you to apply functions to this data—like the SUM() function.

Question:

Which field type would be best to use in this scenario?

Answer:

Lookup

Which field type is most useful when you want to cross-reference information that's stored in separate tables?

Question:

You want to create a simple expression that alerts your team when the total price of an item is greater than, or equal, to, $100. Which of the following operators would you use in your formula?

Answer:

The operator >= allows you to compare if one number is greater than or equal to another.

Question :

True or False? To reference another field from your table in your formula field, you should use (Parentheses).

Answer:

FALSE

You should use {Curly Brackets} when referencing a field name in your formula.

Question:

All of the following are common mistakes to look out for when encountering an #ERROR message output from your formula EXCEPT:

Answer:

An emoji included in a text string output

Remember, you want to review the structure of your formula for any mistakes.

Question:

Which of the following best describes the use of an OR() statement within an IF() formula?

Answer:

To check multiple conditions where if any condition is true, the same result is returned.

An OR() statement returns 'true' if any one of the multiple arguments included is true.

Question:

You oversee the project management function at your organization and are interested in tracking which projects have been moved to the 'Complete' status.

Which formula would correctly handle a project status of either 'Not Started' or 'In Progress' to output a red X emoji?

Answer:

IF(OR({Status} = "Not Started", {Status} = "In Progress"), "❌", "✅")

Question:

True or False? The NOW() function is preferred over the TODAY() function for optimizing base performance due to its frequent updates.

Answer:

FALSE

The TODAY() function is preferred for base optimization and minimized load times because of the more frequent updates being performed by the NOW() function.

Question:

True or False? You can use multiple operators within each logical argument in nested IF() statements.

Answer:

FALSE

Each logical argument can only have one operator.

Question 6:

True or False? An IF() statement can only perform comparisons between numerical values using 'greater than' or 'less than' operators.

Answer:

FALSE

Correct! IF() statements can use a range of operators beyond just 'greater than' and 'less than'.

Question:

What is the primary benefit of using the SWITCH() function over nested IF() statements?

Answer:

SWITCH() is easier to read and maintain due to less nesting.

The SWITCH() function can be a significant time-saver when you’re working with conditional-heavy formulas (like nested IF() statements).

Question:

What does the AND() function return when all its conditions are met?

Answer:

'1'

Although the AND() function returns true if all the arguments are true, it's represented by a '1' (whereas false is represented by a '0').

Question:

Which statement best describes the OR() function's behavior in formulas?

Answer:

It returns "1" if at least one condition is true.

Incorrect. Whereas the AND() function returns '1' if all evaluated conditions are true, the OR() function only needs one of the conditions to be true to return a '1'.

Question:

What is the primary use of the BLANK() function in Airtable?

Answer:

To identify or output an empty value in a field.

The BLANK() function is used to identify an empty value in a field or output an empty value in a formula.

Question:

True or False? Using empty quotes ("") and the BLANK() function in a formula will yield the same result.

Answer:

TRUE

Both empty quotes and the BLANK() function will yield the same result—a blank value.

Question:

Fill in the blank: the __________ function joins together arguments and/or field values from any number of fields into a single text value

Answer:

CONCATENATE()

Question:

From a data hygiene and uniformity perspective, you want to ensure that all of the emails captured in your {Business Email} field (via an Airtable form) are all lowercase.

Which of the following formulas would you use to accomplish this?

Answer:

LOWER()

Question:

True or False? Whereas the REPLACE() function will replace a single instance of a defined amount of text, the SUBSTITUTE() function will replace all examples of the defined text.

Answer:

True

Question:

What is the main purpose of repeating groups in Airtable automations?

Answer:

to loop through a set of actions for each item in an input list.

Question:

What is the primary benefit of using conditional groups in Airtable automations?

Answer:

They enable you to change the course of your automation based on previous triggers or actions.

Question:

Which of the following best describes the use of conditional logic in Airtable automations?

Answer:

It allows you to create rules and conditions to determine actions based on specific criteria.