New files in Affinity — Updating records in Microsoft SQL

The scenario catches new files in Affinity and updates records in Microsoft SQL, reshapes the data along the way. Runs on its own, no manual copying.

  • A new file in Affinity updates the related record in Microsoft SQL right away.
  • The database shows where a file is attached and where it isn't.
  • You don't mark file receipt by hand.

How it works

To keep Affinity and Microsoft SQL in sync, connect them with a ready-made scenario — changes flow automatically.

  1. Starts when: Microsoft One Drive
  2. Then: Set
  3. Then: Redis

You can launch this Affinity + Microsoft SQL integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.