When working with data in Clay, you can specify uniqueness fields to identify rows uniquely. If you don't select specific fields as unique identifiers, Clay will use the entire row content as the unique identifier. However, be cautious with this default approach as it may result in many duplicates in your table. It's recommended to select specific fields that can uniquely identify each row to avoid duplicate records.
Source:Salesforce Reports with Salesforce
Yes, you can create a unique ID column using Clay's formula feature. Here's how: 1. Add a new column to your table
2. Select "Formula" as the input type
3. Use the AI Formula Generator to create a formula that generates unique IDs or numbers
4. Click "Generate Formula" to create the formula
5. Review the sample output
6. Click "Save Formula" to apply itYou can set this column's data type to "Number" if you're generating numerical IDs, or "Text" if you're creating alphanumeric identifiers.
Sources:Table columns overview | Documentation | Clay UniversityFormulas
yeah you can just use a random number generator
you can use this formula
Return a random string/number of x length if /name is not empty
Where name is any column that will always be populated with some data
.png){kind=logo}
