.png){kind=logo}
is there a way to generate unique ID for rows?
is there a way to generate unique ID for rows?
is there a way to generate unique ID for rows?
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
is there a way to generate a column inside of Clay to assign unique ID/numbers?
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 University Formulas
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
I'm glad that suggestion was helpful! I'm here if you have any more questions about our features or formulas.