How to Create an ID Column with Row Numbers in Your Database

I have a very small doubt but I am not able to figure out how do I achieve this. So actually I want a column(let's say ID) which should be equal to the row number of the record. Example , it should output 1 for the first record , 2 for the second one and so on.

7 comments

Channeled
APP
·
·
To create a column with row numbers in Clay, you can use the "Add Column Using AI" feature. Here's how: 1. Open your table 2. Click "Add Column" > "Add Column using AI" 3. In the description, enter something like "Generate a sequential number for each row, starting from 1" 4. Click "Continue" 5. Set up the parameters as needed 6. Click "Save" After creating the column, you can set its data type to "Number" for proper formatting: 1. Right-click the new column 2. Click "Edit Column" > "Select Data Type" 3. Choose "Number" as the data type 4. Click "Save Settings" This should create a column with sequential numbers for your records.
Sources: Select Column Data Type Add Column Using AI & Add New Rows Table columns | Documentation | Clay University
Piyush K.
·
·
Do we need to use credits for this?
Piyush K.
·
·
Since you are asking to use AI
Mark L.
·
·
Hello Piyush, can you tell me more about your use case? Today, Clay doesn't have any concept of "row number" or "row ID", nothing that is fixed. Depending on what you need to do, we may be able to think of alternative paths.
Piyush K.
·
·
I was building a workflow in which we were logging company domains and then the domains were responsible for triggering another Clay tables . To keep a track of how early these domains were logged, I thought of assigning them a number which would be the same as their row number.
Bo (.
·
·
Hi Piyush, Instead you can create a formula in each table that returns both the table name and date, then add this information alongside the data you're sending. For example, use a formula like: If /data is present, return "your table name" and "/date" This gives you a reliable way to track when domains were logged across your workflow.
Channeled
APP
·
·

How to Create an ID Column with Row Numbers in Your Database | Clay