Xano
Databases & spreadsheets
Read and write Xano backend records from your workflows.
Overview
The Softr Xano integration lets your app create, find, update, and delete records in your Xano database as part of a workflow. Trigger a new record from a form submission, update records when a status changes, or look up existing data to display or use in the next step — all driven by what your users do in Softr.
Whether you're building a customer portal, an internal admin tool, or a member dashboard, Xano becomes the backend your Softr app writes to and reads from, so your existing backend stays the single source of truth while Softr handles the front end and the automations. Xano connects to your workflows through Softr's SQL / Database action, using Xano's Data Connector.
Available actions
- Find recordLook up the first record that matches your conditions — perfect for fetching a customer, order, or profile to display in your app or use in a later step.
- Find multiple recordsReturn every record that meets your criteria, so you can power a live list, dashboard, or digest from your Xano data.
- Add recordCreate a new record whenever a workflow runs — turn a form submission or sign-up into a record in your database instantly.
- Update recordChange a single record automatically as things happen in your app, such as updating a status or contact detail.
- Update multiple recordsUpdate many records at once — ideal for bulk status changes or applying the same update across a set of records.
- Delete recordRemove a single record that's no longer needed as work is cancelled or cleaned up.
- Delete multiple recordsClear out a batch of records at once to keep your database tidy.
Example use cases
Usecase
Description
- Form-to-database intakeA Softr form submission adds a new record to your Xano table with all the submitted details.
- User provisioning on sign-upWhen a new member signs up, create their record in Xano so their data is ready across your app.
- Status syncWhen a record moves to "In progress" in your Softr app, update the matching Xano record automatically.
- Live data dashboardUse Find multiple records to power a Softr list block that always reflects your latest Xano data.
- Bulk updatesUpdate multiple records at once — for example, mark a batch of orders as shipped from an admin action.
- Automated cleanupDelete records that are cancelled or expired to keep your database tidy without manual work.
Key benefits
- No-code database access: Read from and write to your Xano backend visually inside Softr — no SQL or backend code required.
- Your data stays the source of truth: Keep your existing Xano backend and let Softr handle the front end and automations on top of it.
- Always-current pickers: Databases, schemas, tables, and fields load live from your connected instance, so your options stay up to date.
- Real-time two-way sync: New submissions become records the moment they arrive, and record changes flow back into your app instantly.
- Custom queries when you need them: Drop in a custom SQL query for anything the standard actions don't cover.
