Examples

Use these ready-to-use scripts to automate repetitive tasks, clean up data and do more in your NocoDB workspace.

Find and Replace

Find a specific value in a field and replace it with a different value. Use it to correct inconsistent data or to rename many entries at once.

Convert Attachments to URLs

Convert attachment fields into comma-separated lists of URLs. External services can then use these URLs.

Randomize Values

Fill empty fields with random data. It supports many data types, and you can set ranges and constraints.

Validate Emails

Find and list all invalid email addresses in email fields. Use it to check data quality.

Select Options

List all options that your records use in a single or multi-select field. Use it to analyze how a select field is used, or to clean up unused options.

Save View Ordering

Save the current record order of a view into a numeric field. Use it to keep a manual sort order or to create custom rankings.

Link Records by Field

Link records in two tables when the values in the selected fields match. It supports pagination and shows a summary of the results.

Unique Field Values Summary

Scan a field and show a summary of all unique values and how often each occurs. Use it for audits, cleanup or to analyze field usage.

Import CSV

Import data from a CSV file into a table that you select. Use it to quickly fill your database with external data.