Tag Info

Hot answers tagged


I do not think that Google Forms has any feature like that. One option might be to ask respondents for their email address (or some other identifier) and only to accept the first entry (ie the one with the minimum date/time) each day.


Your Google Form decides which column to store the data in - you do not control this. And the design you're aiming for (different weeks data in different columns) is likely to cause long term problems. But there is a better approach: In general, the first column in the sheet which it stores data in is labelled Timestamp, and contains the date/time when ...


Yes, it's possible. From Forms Service This service allows scripts to create, access, and modify Google Forms.


The function GoogleFinance can do one of two things: return "realtime" data (with usual reporting delays, about 20 minutes). Example: =GoogleFinance("CURRENCY:USDBRL") return historical data: the closing price on a particular day. Example: =GoogleFinance("CURRENCY:USDBRL","price",DATE(2015,4,1)) What it does not do (unfortunately) is look ...

Only top voted, non community-wiki answers of a minimum length are eligible