Does this work when using tables of data will each row be considered on
-
MazvitaAsked on December 14, 2021 at 09:11 PM
Does this work when using tables of data will each row be considered one contact?
This is a re-post of a comment on How to Integrate Jotform with Hubspot CRM
-
AhmedAnswered on December 15, 2021 at 02:52 AMJotform Support
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.
-
mazviAnswered on December 15, 2021 at 08: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
Here is an image of my fillable table. -
MaxwellAnswered on December 15, 2021 at 09:47 AMJotform Support
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:
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:
If you need further assistance, please let us know.
-
mazviAnswered on December 15, 2021 at 09: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.
-
SheenaAnswered on December 15, 2021 at 10:24 AMJotform Support
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.
-
mazviAnswered on December 16, 2021 at 09: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? -
CecileAnswered on December 16, 2021 at 11:08 AMJotform Support
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.
-
mazviAnswered 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.
-
GaetanAnswered on December 16, 2021 at 12:16 PMJotform Support
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
-
mazviAnswered 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.
-
mazviAnswered on December 21, 2021 at 09:36 AM
In response to this. I tried creating multiple separate fields as shown below
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. -
AshwinAnswered on December 21, 2021 at 09:51 AMJotform Support
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.
-
ShawnieAnswered 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?
-
ShawnieAnswered 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:
-
shawnieAnswered on December 21, 2021 at 10:29 AM
ACcording to this - its not a possibility. Is this still the case?
-
SheenaAnswered on December 21, 2021 at 10:31 AMJotform Support
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.