clearRowData := db_clear_row_data(Args{
database_id: "...",
row_id: "abc123xyz",
columns: "name, points",
})
send_text_message(Args{
channel_id: trigger.channel_id,
message_content: "Row Updated: " + clearRowData.updated,
})
Clear Row Data
BlockDatabases
Clear selected columns from a database row. Does nothing if the row does not exist.
Inputs
DatabaseRequired
Select the database containing the row.
Row IDRequired
The unique ID of the row to clear.
Example: abc123xyz
ColumnsRequired
Comma-separated column names or column IDs to clear. System columns cannot be cleared.
Example: name, points
Outputs
Row Updated
Whether the row was updated (true/false). False if the row does not exist.
Example: true
Build a bot using blocks like Clear Row Data
Use this block in our visual flow editor. Bots are hosted 24/7 for free on inventor.bot.
Advanced Documentation
This documentation can be useful when using code mode. View as Markdown
ID:
db_clear_row_dataInputs
| Field | InventScript name | Value |
|---|---|---|
| Database | database_id | |
| Row ID | row_id | e.g. "abc123xyz" |
| Columns | columns | e.g. "name, points" |
Outputs
| Field | InventScript name | Value |
|---|---|---|
| Row Updated | updated | e.g. "true" |
Example InventScript
More databases blocks
Database Lookup (Single)Find a single row from a database matching your query. Returns the first matching row.Database Lookup (Iterator)Find multiple rows from a database and iterate over each one.Database Create RowCreate a new row in a database with the specified values.Database Duplicate RowDuplicate an existing row in a database by its ID.Database Update RowUpdate an existing row in a database with new values.Clear Matching Row DataFind rows matching a query and clear selected columns from all of them.Update Matching RowsFind rows matching a query and update them all with the specified values.Delete Matching RowsDelete rows matching a query and return how many were deleted.Database Delete RowDelete a row from a database by its ID.