I currently use Zapier to bring form entries into the sheet from Cognito Forms and adds each new form entry as a new row at the bottom of the list. If you know of a better way to do this than Zapier, then tell me!
There are currently around 3000 unique email addresses, each one belonging to my customers. But each customer makes several form submissions per week, each one being added as a new row at the bottom.
I would like to be able to have a separate Google Sheet that is able to look up entries from this master sheet by the email address and list them in a new sheet.
So the new sheet there is a menu item, or a button or a cell where you enter the email address of the customer you want to find.
Then when you press enter, all the entries from the master sheet belonging to that email address show up in the new Google Sheet. They will be in date order with newest in row 1 and then older ones below.
I would also like it that the link to the Cognito Form entry as found in Column C opens up in a web browser window rather than downloads as a pdf.
I have 20 members of staff who will all be using this look up function at one time, so they need to have their own unique Sheet that they work from that searches the master sheet from without their searches showing up on other staff member's sheet.
Lately, there is sometimes a lot of text in the cells in Column E, so if the rows of the search results could be taller so the text is not all in one line that would be better.
It would also be amazing if I could give each customer access to the function so they can use their own email address to search the sheet, but not be able to search the sheet by anyone else's email address. I don't know if that is possible - desirable, not essential.