Using ARRAYFORMULA in Output Column
rivalpro last edited by
I have a spreadsheet set up so when a user submits a form the spread sheet holds their first name, last name and other data to use in Templater. The last column is the Output name for that row/file. I am currently using an Arrayformula to concatenate the first name, last name and a string and set the output nam (Example. =ARRAYFORMULA(G2:G & “_” & H2:H & “_HappyHolidays”) this would produce “John_Smith_HappyHolidays” down the entire column) When I run Bot, it changes the output cell to just text and breaks the Arrayformula. Is there a better way to automate the output name as new forms are submitted?
ariestav last edited by
@rivalpro Unfortunately, what you are encountering here is a known issue with using Bot and Google Sheets. Can you somehow, make an invisible field that does the “stitching” of the other fields in the form and inject that invisible field into the Google Sheet. In other words, the output column should be hard coded. I know this is not what you want to hear, but it is a limitation of writing data back to a Google Sheet using their API.