Hi TypeForm,
I hope you bear with me with this issue. This is not an error, but I need advice.
I have connected my TypeForm to Excel. My client does not accept Google Sheets into their ecosystem. Also we could not filter the Google Sheet on the other end. So, Excel seems to be what we currently have if do not find a third alternative.
On the first row of the Excel document that TypeForm sends its responses to, there is a line that says:
I'm a beautiful table, do not change me and I will keep receiving responses.
The problem with this is that we need an extra column in the Excel sheet that tells us whether or not we have processed this row at the destination system before. The destination system is limited in the number of rows it can read. As of now, it can only read a mere 256 rows every time it takes the sheet rows. Therefore, if we do not have a column that says e.g., “ThisRowIsProcessed = 1”, we end up fetching the same rows every time. If we have this row we can tell the destination system to fetch only the rows with “ThisRowIsProcessed = 0” so that, in time, it can process all the rows.
I tested adding this extra column just to see if the above statement is true and noticed that it is the case. The Excel sheet stops receiving new answers if you add this extra column.
Do you have any other recommendations?
We need to save all the answers somewhere so that we can fetch them later and process them.
And if Excel cannot do this, do we have any alternatives to Excel and Google Sheets that can?
Thank you in advance!
