Actions
complete
Tom Johnson
Actions would allow you to execute a JS script or a SQL query against your database using values from a record.
As an example, if you have an "email" column on a "Users" table in your database, you could create an action called "Send onboarding email" which would execute a JS script that uses the "email" value for a record to send an email to a user (e.g. by making an API request to the ConvertKit API).
Max Musing
complete
Actions are now live! You can connect both internal and third-party APIs, which let you set up actions for things like:
- Refunding a user on Stripe
- Sending an email through SendGrid
- Updating a lead on HubSpot
Official launch: https://www.producthunt.com/posts/basedash-apps-actions
Docs: https://docs.basedash.com/actions
Josiah Richards
Waiting for this!
Robert Cooper
Josiah Richards: they're now officially released. Looking forward to hearing what you think.
Robert Cooper
We're making progress on Actions internally. Here's an update:
[x] Prove out the concept of executing and handling a user-defined web request
[x] Design the layouts and flow in the UI for users to define web requests and execute them on/with table records
[x] Reorganize certain parts of our UI to accommodate action creation and execution.
[x] Revise the structure of a "Data source" so that a Data source can be not only a SQL Database, but also a Web API (actions will be user-defined requests to endpoints of a user-defined "Web API data source")
[x] Server-client wiring in the Basedash app for creation/update/deletion/execution of API data sources and Actions.
Update: as of July 20th, we've completed all the items in this list. Stay tuned, we're preparing to launch Actions soon.
Robert Cooper
Actions are officially in development. We've gone through and planned together as a team, and here's roughly what we're setting out to build for the first iteration:
- A kind of webhook, with user-defined requests to a Web API (either one the user's team controls, or a 3rd party one)
- These Web requests can be created by Basedash Admin users and can be triggered from a View.
- The request can be run "on a record", that is, taking information from a record in a table as input. For example, on a usertable, you could define a request to an email service, so when you trigger the action on a particular user, the value from theuser.emailfield is taken and formatted into the request that gets sent.
Tom Johnson
in progress
C
Courtney Rogers
Is this CRUD on the DB through a basedash api?
Robert Cooper
Courtney Rogers: Currently we are thinking of actions as a button you can click to trigger a JavaScript script or SQL query that uses values from a database record.
Tom Johnson
planned