topic Re: Updating HubDB table in CMS Development

Updating HubDB table

ChrisChiha — Wed, 21 Sep 2022 17:23:30 GMT

Hello,

Is there any way i can connect my HubDB table to some sort of a page that enables users to view the rows and update/add rows to the table?

I would like to enable users to update the HubDB table without getting direct access to the table it self inside HubSpot. Would this work?

Thank you!
@ChrisChiha

Re: Updating HubDB table

BarryGrennan — Wed, 21 Sep 2022 19:31:12 GMT

Sounds like it's probably a job for the HubDB api

How exactly you'd go about it I've no idea, really not an API guy (yet? 😛)

Barry Grennan

Freelance HubSpot CMS Developer

Website | Contact

Re: Updating HubDB table

Jnix284 — Wed, 21 Sep 2022 23:43:08 GMT

@ChrisChiha If the page can make changes to the HubDB without an approval mechanism, what difference would this serve over providing direct acces to the HubDB table itself?

my question is essentially "why" do you want to do it this way?

Re: Updating HubDB table

ChrisChiha — Thu, 22 Sep 2022 01:59:14 GMT

Hello @Jnix284 ,

Thanks for your reply!

Two reasons actually:
- For users who are outside of our organization and can't access our CRM
- HubDB permissions are not fragmnented. The permission will enable all hubdb features to all involved users. (We can't restrict creating/deleting, which might cause some inconveniences)

Thank you!
@ChrisChiha

Re: Updating HubDB table

Jnix284 — Thu, 22 Sep 2022 02:12:47 GMT

Hi @ChrisChiha

Thanks for sharing, it is so helpful to understand use cases to learn more about requirements and capabilities... and I am a huge fan of HubDB!

1 - With permissions, it is possible to create a user role that limits access entirely except to HubDB. This wouldn't count against any of your seats for paid users.

You can also limit to "view" for those that need to provide input and "edit" for those that need to make changes. As long as you don't give "publish" permissions, you can always revert to the last published version to remove any changes made.

2 - yes, I agree the permissions could be more nuanced, especially when it comes to deleting columns or rows. Again, IF someone deleted a column or row, it could be restored by reverting to the last published version (tested and verified).

In this case, you would want to restrict the users who can "publish" to the critical few.

I'm not saying you shouldn't proceed with your plan to use an API on a website page, but it is possible to do this entirely within the backend if you wanted to, without the added expense of the customization.

Hope this helps! If you do decide to go forward with the customization, I would add a post to the jobs board or join the developer slack to post the job there.

If you are a HubSpot Super Admin, I also recommend joining the Sprocketeer Community at Sprocketeer.community to connect with other Super Admins and find solutions there. 🙂

Re: Updating HubDB table

ChrisChiha — Thu, 22 Sep 2022 06:24:54 GMT

I totally agree @Jnix284 ! I've done some complex yet interesting projects with HubDB.

For me even if i can manage to link the hubdb to a google sheet, that would do the job. But i guess i will have to use the APIs anyway.

Re: Updating HubDB table

Jnix284 — Thu, 22 Sep 2022 11:19:00 GMT

Hi @ChrisChiha you could manage it in google sheets using export to CSV and then import the updated CSV. I had someone on my team who was just quicker with spreadsheets than HubDB and they preferred to make the changes that way.

It still requires a handoff in your situation though and isn't as elegant as an API.

Best of luck getting the API set up and running!