Clay Icon

Creating Unique GUIDs for Table Rows: Best Methods and Practices

ยท
ยท

Hi Team, I'm trying to create a unique guid for each row in a table. Whats the best way to do that?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Paul L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You have a couple of options to handle unique identifiers for your rows:1. Use Auto-dedupe with a specific column: โ€ข Enable automatic deduplication from the Auto-dedupe icon at the bottom right of your table โ€ข Select a column that contains unique values to serve as your identifier โ€ข This will maintain uniqueness based on that column 2. For Salesforce data specifically: โ€ข You can select specific "Uniqueness Fields" to use as unique identifiers โ€ข If no unique identifier is selected, the entire row will be used as the identifier (though this may cause duplicates)If you need a more specific solution for generating GUIDs, you may want to request help from our support team for guidance on custom implementations. Sources: Salesforce Reports with Salesforce Auto-update and Auto-dedupe Table

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.