So as it turns out the email Connector, great as it is, has a key flaw, if two emails arrive at close to the same time one of them will not be imported.
Silly as this sounds, the following error comes up " The import has been cancelled because a new request has been submitted."
I originally noticed the issue when I created and started testing a data set a couple of weeks ago. I inmediately contect Support about it, preempting that this would be an issue, and they said that this a limitation of the system. I was not given the impression that they plan to fix the problem, as the support person dismissed the issue saying if it were to happen it would most likely be duplicate emails.
Now the that data started coming in I am encountering the error daily, which unfortunatelly makes the data useless.
If anyone has run into this issue before, is there a workaround to get this to work????
As a bit of background
We use online forms to generate work permits and to later signoff the permits when the work is completed. We would get an email with each of those submitions, generating two data sets.
By joining the the tow data sets I was planning of getting a live list of jobs that have and have not been signed off.
I was then planning of having the open jobs displayed on a monitor and raise alarms if a job was not closed after a set time.
I can possible get the out of a google sheet but the 1 hour refresh shedule is jsut not good enough.