Clay Icon

Help Needed: Updating Multi-Checkbox Company Property in HubSpot

Β·
Β·

Hi hoping for help with this exact same issue, looking to update a multi-checkbox company property in HubSpot via the Update Object HubSpot enrichment. The thread was broken so I can't see the resolution. I've tried Ignore blank values as true or false. I've tried entering the property IDs with a comma. Please advise. https://clayrunhq.slack.com/archives/C025KSBLPGX/p1735916294090779

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    To update a multi-checkbox company property in HubSpot using the Update Object HubSpot enrichment: 1. Select the HubSpot account you want to use. 2. Choose "Company" as the Object Type to update. 3. Enter the HubSpot Object ID for the company you're updating. 4. For "Ignore Blank Values": β€’ Set to "True" to prevent overwriting existing values with blanks. β€’ Set to "False" if you want blank values to overwrite existing data. 5. Map the multi-checkbox field from your Clay table to the corresponding HubSpot property. 6. For property IDs, enter them as a comma-separated list in the mapped field. Remember to ensure your data types and formats align with HubSpot's requirements. If you need further assistance, please request human support by clicking "Talk to a person".

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    I tried running this in separate columns with "Ignore blank values" set to True and it still overwrites what was there previously. Both columns do work independently, however.

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    hello?

  • Avatar of George D.
    George D.
    Β·
    Β·

    Hey Harris - I just checked that thread on our backend - we actually don't currently support multi-checkboxes in Clay. The only option we have is a select column where you can select a single option. Sorry to be the bearer of bad news here, but let me know if I can maybe help you set this up another way.

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    hm that's frustrating, okay thank you for the update i appreciate it

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    It's a bit of a pain to do through manual imports as well which i just tried a few moments ago so i'm going to have to think about this. there may be a better way of doing it via workflows but i still need to do a one-time import/catchup

  • Avatar of George D.
    George D.
    Β·
    Β·

    Sorry about that - let me know if we can help unblock you here. Totally get the multi-select would be helpful and ill make sure to relay it to our product team as well!

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    i'm not sure what else to do about it to be honest, i really appreciate the help and a multi-select is definitely the property type i should be using... it just doesn't seem to be very easy to work with

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    even when i tried a manual import, it would just overwrite what was there before

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    hm i wonder if i write an API call

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    through HTTP API and the connected app i already have

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    i think that'll do it actually

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    ugh okay will deal with this next week

  • Avatar of George D.
    George D.
    Β·
    Β·

    Sorry Harris - let us know if the HTTP API option works for you or if we can help any further.

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    no apology necessary!

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    perhaps updating the docs on this would be helpful because the AI thing is apparently unaware that this isn't supported

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    would have def saved some time

  • Avatar of George D.
    George D.
    Β·
    Β·

    Good call - I'll mention that to our team now.

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    it's also tricky when chats get pulled out of here, idk if anything can be done about it

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    but then you see the old thread an it's like, what happened?

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    see also:

  • Avatar of George D.
    George D.
    Β·
    Β·

    Ya so the reason that happens is we use one support system for Slack and the in-app message. If someone starts the message in slack, but then responds again in-product, we stop syncing to slack because the expectation of privacy has shifted (we wouldn't someone to post a message in the in-product chat thinking its private, but its actually pushing that data to a public slack channel too). Totally get its not ideal when you're scanning for answers though.

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    that totally makes sense

  • Avatar of Harris K.
    Harris K.
    Β·
    Β·

    appreciate you george, have a nice weekend!

  • Avatar of George D.
    George D.
    Β·
    Β·

    You too!

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·