Updating HubDB table

[ChrisChiha]

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 

[Jnix284]

@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?

[ChrisChiha]

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 

[Jnix284 · Accepted solution]

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. 🙂

[ChrisChiha]

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.

[Jnix284]

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!

[BarryGrennan]

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