Does this work when using tables of data will each row be considered on

  • Mazvita
    Asked on December 14, 2021 at 9:11 PM

    Does this work when using tables of data will each row be considered one contact?

  • Ahmed_S
    Replied on December 15, 2021 at 2:52 AM

    Hello Mazvita,

    Thank you for reach out to Jotform Support.

    If you mean the submissions table then yes, each added entry or row via the form is considered as an individual contact when integrated with HubSpot.

    Please let us know if you need further assistance, we are happy to help.

  • mazvi
    Replied on December 15, 2021 at 8:33 AM

    Thank you so much for your response.

    So I just tried connecting Jotform and HubSpot and the problem starts when I'm trying to match fields because the whole table is coming out as one option it did not break down the columns to each represent a field. My table is the one that has the instruction to include the details of leads being referred. See below

    1639575015 61b9ede7a8193  Screenshot 10

    Here is an image of my fillable table.


    1639575194 61b9ee9a5e596  Screenshot 21

  • Maxwell HR Operation Specialist
    Replied on December 15, 2021 at 9:47 AM

    Hello mazvi,

    This issue happens because of the nature of the Input Table Element. It counts every input in that table as a single form field as shown below:

    1639577469 61b9f77dd0016 step1 Screenshot 10

    However, you may be able to use Input Table by making it a one-row element, then duplicating it to create multiple Input Tables as shown below:

    1639579373 61b9feed33b39 Screen Shot 202 Screenshot 21


    1639579464 61b9ff48f40b8 Screen Shot 202 Screenshot 32

    1639580109 61ba01cdbbbf4 Screen Shot 202 Screenshot 43

    If you need further assistance, please let us know.

  • mazvi
    Replied on December 15, 2021 at 9:55 AM

    Is there any way we can hop on a zoom call or anything so you can help me through this? Thank you so much.


  • Sheena JotForm Support
    Replied on December 15, 2021 at 10:24 AM

    Hi there,

    Unfortunately we do not have a voice support. Our only mode of communication is through this forum support or you can also email us at support@jotform.com as well. 

    Please go ahead and ask your clarifications here about your concern, we'd be happy to help.

    All the best.

  • mazvi
    Replied on December 16, 2021 at 9:44 AM

    Hie guys,

    Remember, up there you said that if I were to create multiple tables of 1 row each then HubSpot will be able to recognize each column as a n input field. That didn't work. So each table is being recognized as a single response such that when integrating Jotform and HubSpot there is no option to match the fields in HubSpot with the ones in Jotform because the whole table is a single response. To try and make this understandable; I would like to match the column "Name" with the field "Name" in Hubspot and the column "phone number" with the field " phone number" in Hubspot but the table columns are not being recognized as separate input fields. How can I get this to happen?

  • Cecile JotForm Support
    Replied on December 16, 2021 at 11:08 AM

    Thank you for your response.

    As a workaround, you might consider using separate fields for name and phone number instead. You might also consider getting the value from the input table to a text field and then map these text fields to the HubSpot's field.

    Looking forward to your reply.

  • mazvi
    Replied on December 16, 2021 at 11:50 AM

    How do I go about this? How do I separate the fields of the table unless you mean just creating normal text fields for name and phone number, but I want to be able to collect multiple rows of data at once. I'm not sure I know what you mean when you say map values from table to text field.


    I think a step by step guide to do the above will be of great help.

    Thank you.

  • Gaetan_B
    Replied on December 16, 2021 at 12:16 PM

    Hello,

    You actually got it right!


    You would need to separate the fields into regular text fields.


    Regarding the requirement of the multiple rows of data, would it be a finite amount or it could be completely random?


    Best regards

  • mazvi
    Replied on December 16, 2021 at 12:20 PM

    For one of my forms I was allowing an input of 60 rows of data into the table. If I'm to separate the fields into regular text fields this means I get one group of text at a time (after a submission) right? e.g. One name, one phone number and one email address.


  • mazvi
    Replied on December 21, 2021 at 9:36 AM

    1640096984 61c1e4d8b0625  Screenshot 10

    In response to this. I tried creating multiple separate fields as shown below

    1640097029 61c1e505b9d96  Screenshot 21
    But this still won't work to directly map with hubspot and if you downloadthe csv file the responses are not population row by row by all going into one big row. like below.

    1640097350 61c1e646e7ae1  Screenshot 32

  • Ashwin JotForm Support
    Replied on December 21, 2021 at 9:51 AM

    There seems to be some confusion. Please note that when you download your submission in Excel file, each submission will be displayed in one row. If you have received 20 submissions in form, the Excel file will show 20 rows.

    It seems you want to display one submission record data in multiple rows of Excel file, which is not possible.

    Do get back to us if you have any questions.

  • Shawnie
    Replied on December 21, 2021 at 10:12 AM

    Hello -it appears my assistant Mazi has gone back and forth and I would like to get this resolved. Is there any way to connect on the phone so we can get this solved?

  • Shawnie
    Replied on December 21, 2021 at 10:26 AM

    So we tried the idea given above (creating the table as separate entries) but when exporting the data it is still all going across in the same row.


    Please see screenshots and advise:


    1640100387 61c1f223bfe09 Screen Shot 202 Screenshot 101640100387 61c1f2233f286 Screen Shot 202 Screenshot 21

  • shawnie
    Replied on December 21, 2021 at 10:29 AM
  • Sheena JotForm Support
    Replied on December 21, 2021 at 10:31 AM

    Hi Shawnie,

    Hope all is well.

    We currently don't have a phone support. Kindly ask Mazvi to direct all the questions here on this thread, we're glad to help.

    Thank you.