Profile

VPellicano
Member
Member since ‎Jul 18, 2022
Message
  • solutions
    1
  • Replies
    5
  • Upvotes Given
    0
  • Upvotes Received
    1
  • Ideas
    0

about

Please sign in to the Community or get HubSpot free to view user profiles

Following

    Friends list is empty

Vito Pellicano

This user hasn't created a bio yet. Edit your own profile here!

Activity

VPellicano on February 13, 2023
case insensitive in hubdb query
I'm creating a drop down filter from cities in a hubdb table and getting duplicates because of some are all uppercase and some are lowercase. How do I search for and group by city without case sensitivity? If I change them all to group.grouper|upp read more
Reply Discussion
0 upvote
2 Replies
VPellicano
Member
February 21, 2023
Hi @Jaycee_Lewis , do know of anyone else that might be able to help me? Thank you
VPellicano on February 13, 2023
case insensitive in hubdb query
I'm creating a drop down filter from cities in a hubdb table and getting duplicates because of some are all uppercase and some are lowercase. How do I search for and group by city without case sensitivity? If I change them all to group.grouper|upp read more
Reply Discussion
0 upvote
2 Replies
VPellicano
Member
February 21, 2023
Hi @Jaycee_Lewis , do know of anyone else that might be able to help me? Thank you
VPellicano on January 31, 2023
hubdb filter for last month/year
How do I get last month as a filter for a HubDB? {% set current_month = local_dt|datetimeformat("%m") %} {% set current_year = local_dt|datetimeformat("%y") %} {% set previous_month = ????|datetimeformat("%m") %} {% set previous_year = ??? read more
Reply Discussion Free
0 upvote
1 Reply
Solved
VPellicano on January 27, 2023
Group by not showing row value
Ugh. What am I doing wrong? <hr> <ul> {% for row in hubdb_table_rows(dynamic_page_hubdb_table_id,'orderBy=region')|groupby("region") %} <li>{{ row.region }}</li> <!--<li>{{ row.name }}</li>--> {% endfo read more
Reply Discussion
0 upvote
1 Reply
VPellicano
Member
January 27, 2023
figured it out {{row.grouper}}
Solved
VPellicano on January 27, 2023
Group by not showing row value
Ugh. What am I doing wrong? <hr> <ul> {% for row in hubdb_table_rows(dynamic_page_hubdb_table_id,'orderBy=region')|groupby("region") %} <li>{{ row.region }}</li> <!--<li>{{ row.name }}</li>--> {% endfo read more
Reply Discussion
0 upvote
1 Reply
VPellicano
Member
January 27, 2023
figured it out {{row.grouper}}
Solved
VPellicano on October 03, 2022
Delete rows not working
https://api.hubapi.com/cms/v3/hubdb/tables/ my_tableID /rows/draft/batch/purge/?hapikey= my_apiKey { "inputs": [ " myIds , myids , myids " ] } I get the following error: {"status":"error","message":"resource not found","correlationId read more
Reply Discussion Free
0 upvote
3 Replies
VPellicano
Member
October 05, 2022
That did it! thank you
View latest posts
Bookmark content for quick access to your most helpful threads.
Get started
Everyone has to start somewhere! Why not kick-start your journey by telling us a bit more about your interests.
Introduce yourself

Following

Connecting with fellow members is one of the best ways to get the most out of your experience. Here are some folks to get you started:
Community Badges

My Groups

Find your people by joining Groups based on shared interests. Check out some of our current faves, and feel free to
  • badge
    Content Marketing

    A place for content marketers to share ideas, learn, network, and be inspired.

  • badge
    Social Media

    A place for social media professionals to share ideas, learn, network, and be inspired.

  • badge
    HubFans

    A spot for HubSpot fans to connect and grow.