Skip to content
Notis

Keep AppDrag content statuses up to date

Set a clear status rule, schedule a review, and let Notis call the AppDrag update action for qualifying records.

Trigger

Recurring schedule

Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.

Action

Visual SQL Update

Update rows in a database table.

Why this helps

Status fields become unreliable when updating them depends on remembering a separate cleanup task.

  • Make a recurring status maintenance task easier to remember.
  • State the update criteria in plain language.
  • Get a report after each run.

Setup

Build it in a few focused steps.

  • 1Connect Agility CMS and AppDrag once in the Notis portal.
  • 2Create an automation in Automations, New Automation, and name the status refresh.
  • 3In one instruction, state the status criteria and ask Notis to call the AppDrag Visual SQL UPDATE action for qualifying records.
  • 4Choose a recurring schedule and report channel.
  • 5Test with one real example and check the resulting record.

Questions about this workflow

What determines which records get updated?

Your instruction and the available data determine the criteria. The AppDrag Visual SQL UPDATE function must be configured to perform the intended update.

Can the workflow use missing content history?

Only if that history is available to Notis or supplied by you. Otherwise the workflow cannot reliably evaluate it.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

Notis builds workflows that link Agility cms to Appdrag. A trigger fires from one place; an action lands in another.

Agility cms triggers

Appdrag actions

Recurring trigger

Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.

TriggerScheduled

Execute Cloud Backend function via DELETE

Executes a cloud backend function in the default environment.

ActionInstant

Webhook trigger

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

TriggerInstant

Execute Preprod Function (DELETE)

Executes a backend function in the preproduction environment for testing or validation.

ActionInstant

Execute PROD API Function (GET)

Executes a backend function in the production environment.

ActionInstant

Execute Dev Function (PATCH)

Executes a backend function in the development environment.

ActionInstant

Execute Cloud Backend function via POST

Executes a cloud backend function in the default environment.

ActionInstant

Execute Function POST (Preprod Env)

Executes a cloud backend function in the preproduction environment.

ActionInstant

Execute Cloud Backend function via PUT (default)

Executes a cloud backend function in the default environment.

ActionInstant

Execute Cloud Backend function via PUT (preprod)

Executes a cloud backend function in the preproduction environment.

ActionInstant

Connect any two apps with Notis in the middle.

Agility cms and Appdrag, or any other combination from 1,000+ integrations.

When this happens · Trigger

Do this · Action

Save your first hour today.

7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Appdrag.