Kill this post if you would like but I thought it might be one to start with in the Community in terms of discussion: thought i would post here instead of directly to support to see if this is the type thing that could be discussed here in the community..
(the whole workflow process is geared to capturing the data into a google sheet, using Document Studio add-on to merge the data into a google doc template and then push a pdf out by mail to the respondent)
I am trying to add a calculated column (or series of columns) into the Google sheet and have the field updated with each entry of a new row of data from Typeform BUT it is not working for me despite looking at about 2 hours of google support comments
what seems to happen is that if i put in a calculated field using the ARRAYFORMULA method to add the calculated value automatically to the field in the new row, the google sheet does not accept any new Typeform results into the table. I have tried removing protection on the table to make it work but even that seems not to work - almost as if the new row data will not write to the sheet due to the fact that the array formula is present in the cell… the records are stored ‘up in typeform’ but are not being pushed down into the google sheet.
the only workaround that i have found is to create a second tab on the google sheet and use the array formulas and calculated fields to display them there as rows are added to the main tab by Typeform and then use the Document Studio to report off this additional tab.
is there anything else that folks could suggest or have i managed to find the easiest way to do this..