Loading

Airtable + Cascade Strategy

Update measure historical values in Cascade Strategy with new or updated records in Airtable

Whenever a new record is added, or an existing one is updated, in Airtable, this Zap will automatically update the connected measure's historical and current data (up to 10 rows) in Cascade Strategy. Keep your data on target without having to leave your Airtable base!

Whenever a new record is added, or an existing one is updated, in Airtable, this Zap will automatically update the connected measure's historical and current data (up to 10 rows) in Cascade Strategy. Keep your data on target without having to leave your Airtable base!

  1. When this happens...
    AirtableAirtable
    New or Updated Record

    Triggers when a record is created or updated.

    TriggerScheduled
  2. automatically do this!
    Cascade StrategyCascade Strategy
    Update Measure Historical Values

    Updates historical values of a measure

    ActionWrite
Try this template
Free 14-day trial
5,000+ supported apps

Supported triggers and actions

What does this mean?
    • BaseRequired

    • TableRequired

    • Limit to View

      (Optional) Limit to records added to a specific View, and return records in the View order.

    • Include file contents?

      Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.

    Trigger
    Scheduled
    Try It
    • BaseRequired

      Base in which to create the record.

    • TableRequired

    Action
    Write
    • BaseRequired

      Pick the Airtable base containing the records you wish to update.

    • TableRequired

      Pick the Airtable table containing the records you wish to update.

    • RecordRequired

      Pick the Airtable record that you wish to update.

    Action
    Write
    • BaseRequired

      Base to search for a record.

    • TableRequired

      Pick an Airtable table that you want to search.

    • Search by Field

      Pick a field from the base to match against the search value.

    • Search Value

      The value of unique identifier for the record.

    • Search Formula

      (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.

    • Limit to View

      You can optionally limit the search to a specific view id.

    Action
    Search
    • BaseRequired

    • TableRequired

    • Help Text

      You must have at least one "Last Modified Time" type column in your Table in order to use this Trigger. Learn more about those here.

    • Which timestamp field should this Zap use to check for updates?Required

      When this column changes to a new timestamp, your Zap will trigger on the corresponding record. Note: Must be a Last Modified Time column type.

    • Limit to View

      Filter on updates to a specific View in your Table.

    • Include file contents?

      Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.

    Trigger
    Scheduled
    Try It
    • BaseRequired

      Base in which to create the record.

    • TableRequired

    Action
    Write
    • BaseRequired

      Base to search for a record.

    • TableRequired

      Pick an Airtable table that you want to search.

    • Search by Field

      Pick a field from the base to match against the search value.

    • Search Value

      The value of unique identifier for the record.

    • Search Formula

      (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.

    • Limit to View

      Limit the search to a specific view. Useful for sorting results.

    • Include file contents?

      Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.

    Action
    Search
    • BaseRequired

      Base in which to create the record.

    • TableRequired

      Pick an Airtable table that you want to search.

    • Search by Field

      Pick a field from the base to match against the search value.

    • Search Value

      The value of unique identifier for the record.

    • Search Formula

      (ADVANCED) Alternatively, you can use an Airtable search formula to find records based on advanced conditions and any number of fields. Learn more.

    • Limit to View

      Limit the search to a specific view. Useful for sorting results.

    • Include file contents?

      Returns an extra File field with file contents. Set this field to Yes if you have trouble with Airtable file URLs expiring. File contents greater than 100MB will cause an error.

    Action
    Search or write
airtable logo
airtable logo

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.
Learn more

Related categories

  • Databases

Similar apps

Quick Base integrations

Quick Base

Databases
Zoho Creator integrations

Zoho Creator

App Builder, Zoho
Smartsheet integrations

Smartsheet

Spreadsheets
cascade-strategy logo
cascade-strategy logo

About Cascade Strategy

Cascade helps organizations plan, execute, measure, and adapt their strategies in one place so they see business results faster.

Related categories

Get started for free

You can't add more hours to the day. Zapier is the next best thing.


OR

By signing up, you agree to Zapier's terms of service and privacy policy.