Skip to main content

Get view action

Collect all records of a saved view while an automation runs. Pick the database app and view, limit the number, and use them in reports, emails, or updates.

Written by Leo

Get view is an action that collects the records that a saved view of a database app shows (the trigger decides when the automation runs, and the action decides what happens). It's meant to help you reuse the filters you already built in a view, instead of building them again in the automation.

You can use this action for many things, including:

  • Collecting all overdue invoices every Monday to send one summary email.

  • Updating every task in the "This week" view at the end of the week.

The action Get records of a view in Expenses from Table in the automation editor

Note:

  • The action only collects records. Use the collected records in later actions, like Send email to collected, Update collected, or Loop actions.

  • A view collects up to 1,000 records. If the view has more, the result is cut at 1,000, and no error appears. Learn more about limits →

  • Pick the view carefully. If you delete the view later, this step fails when the automation runs.

Who can use the Get view action?

  • Automations are available on the Free, Plus, and Premium plans. The number of automation actions per month depends on your plan. See the limits for your plan on our pricing page.

  • To add or change this action, you need to be a workspace admin of the workspace the database app is in. You also need full access to every database the automation uses.

Add the Get view action

To collect the records of a view from an automation:

  1. Open the database app and click the automations icon at the top right (Create and view automations).

  2. Open an automation, or select New automation and choose a trigger.

  3. Select Add action → Get view. The step appears as Get records of a view.

  4. Open the app dropdown after in and select the database.

  5. Open the view dropdown after from and select the view.

  6. Add actions below that use the collected records.

  7. Select Create automation for a new automation, or Save changes for an existing one.

Adding Get view in an Expenses automation: Add action, selecting Get view, which reads Get records of a view in Expenses from Table, then choosing Expenses in the app list after in and Table under Team views after from

Get view settings

  • App: the database app that holds the view. It can be any database app. The dropdown lists the database apps of every workspace where you're a workspace admin and have full access to the app.

  • View: the view to collect from. Team views appear under Team views, your private views under Private views. Both the database and the view are required.

  • Limit results: in the ••• menu of the action. It sets the maximum number of records to collect. Without Limit results, the action collects every record of the view, up to 1,000. When you switch on Limit results, the action reads and limit results to, followed by the number. It starts at 1.

  • Continue on error: keeps the run going if the action fails.

The action collects the records the view shows when the action runs. It uses the filters and the sort order of the view at that time. Dates like "this week" are calculated when the action runs. If you collect from the same database twice, the records are added to the same list.

Use the collected records

The records you get are called collected records. They stay available for the rest of the run:

  • Send email to collected sends one email per record.

  • Update collected and Comment on collected change or comment on all of them.

  • Loop actions runs actions for each record, for example to build an HTML table.

  • Rollup collected combines their values, for example into a total.

Let's look at an example

Let's say your property team wants a Monday list of overdue rent payments. Here's how:

  1. Set the trigger to On a scheduled time or interval and choose every Monday at 8:00 AM.

  2. Select Add action → Get view, choose the Payments database app and the view Overdue.

  3. Select Add action → Send email.

  4. In To, enter [email protected].

  5. In Subject, enter "Overdue rent this week".

  6. In the message, add a table of the collected records. Learn more about building an HTML table →

  7. Select Create automation.

Every Monday, the finance team gets the list of overdue payments from the view.

Get view errors

  • If the view is empty, the list is empty, and the run continues. Actions that use the list do nothing.

  • If the view was deleted, the step fails with a message like App view with ID 123 not found. Open the step and choose another view, then select Save changes.

  • If the step fails, the run shows the step and its message. Open the automation and click ▷ (View all runs) at the top, or use cmd/ctrl + 1. Each run shows its status, for example Success; select a run to see every step. For all automations, open Runs in the Automation Center and filter by App, Automation, or Status.

Test, pause, or edit the Get view action

  • Manual run runs the automation once right away. With the trigger On a scheduled time or interval, you don't select records: the panel shows Run by skipping schedule. Select Start run, or Save and start run if you have unsaved changes.

  • To stop only this action, select ••• → Deactivate.

  • To change the view, open the automation, select the step, make your changes, then select Save changes.

Learn more

FAQs

Can I use a view from another database app?

Yes! Open the app dropdown after in, select the database, then choose one of its views.

How many records can Get view collect?

Up to 1,000. If the view has more, the result is cut at 1,000 and you don't see an error. Learn more about updating many records in batches →

What's the difference between Get view and Search for records?

Get view reuses the filters of a saved view. Search for records lets you build the filter in the automation itself. Learn more about Search for records →

Can I choose a personal view?

Yes! You can choose a team view or one of your private views.

Are there other actions I can use?

Yes! Actions can create and update records, add comments, send emails, create PDFs, call other services, and more. See every action in Automation actions →

Are you a developer using the Tape API for automations?

The automation API has its own documentation for developers. Full reference: collect_app_view_records in the developer docs →

Still have questions? Find answers and get help from community experts in the Tape community →

Did this answer your question?