I have a flow that works well, but is manual. I trigger it when i get a form entry from Hubspot.
It then sends me a CSV of all the form data ever entered to my email, I cull the old stuff and save the new ssheet to my Mac and import that into Filemaker Pro.
There are a few issues with data validity that are annoying and I am slowly working through those but I will outline them here as they are quite important and I would think Hubspot would know about them but they seem completely unaware.
Hubspot records any date entered into a form as a Milisecond Epoch date format this however when it gets to Filemaker is 1,000 times larger than Filemaker can handle as it has a different format of epoch. I created a Filemaker script to cut off 3 zeros and the date resolves. But I would like the data arriving to be modified in Parabola.
Hubspot takes a mobile number field and calls it a Text Field… but when it gets to data its not a text field and the leading zero is gone… you cant start a number with a zero of course. Thats annoying… Ide also like that dealt with in Parabola.
Lastly … automation… I really would like to have the data trigger off a webhook and instantly arrive in my Filemaker database… ! I don’t have the smarts for that … just wondering if anyone out there has done this and can help please ?
Guy and Amy