So we use this form at our church so that the weekly speakers can send in their message info for our creative team to design screens, etc. Since we've had the form for a few years, we have hundreds of submissions. I"ve setup the form so it exports to a Google Sheet of all submissions and keeps it updated week to week. The only issue is that the Google Sheet shows all submissions from oldest to newest, so i have to scroll past hundreds of old submissions to get to the new submissions. Is there a way to reverse the Google Sheet so it shows the newest at top? Also, it says that editor@formfacade.com has main access to sheet so I cant adjust anything with my email, even though im on the account as an Editor
View responses
When responses are synced to Google Sheets, they are always appended at the end. As a result, the sheet displays responses in chronological order, from oldest to newest. This order cannot be changed. We recommend using Formfacade Reports, which allow you to group and view responses by week, month, or year.
Export to Google Sheets
Formfacade does not have permission to create a sheet in your Drive. When you export data from Formfacade Reports to Google Sheets, the sheet is created in the service account, and your email address is added as a collaborator to provide access. The first column, which contains the unique ID, is locked. You will not be able to delete rows or apply filters that affect this column.
