I’m looking to replicate a spreadsheet where I can have multiple lines of data entry, that could have some math checks between the cells in real time, that could export the answers to a google sheet.
Any idea on how this could be done, if possible at all? I’m new to the platform and tried out all the question types and didn’t think it was possible, but I thought I would ask.
Best answer by Liz
Hi
You could then use a short text for them to add in the timestamps, but I don’t think we have a way to verify that the timestamp format is correct. Is this the calculation you’re hoping for?
+5Hi
I’m trying to create a form to accept time stamps that someone would enter manually, and have unlimited lines in the form they could continue to add more data as they need. Hopefully the example i’ve written out below kind of shows what I mean. I would want to allow people to add new rows as they need to add additional times. I would also want to make sure that the time stamps make sense, meaning cell 1B is after 1A, and 1B is before 2A. There’s other stuff I would want to do, but this is the core of what I’d be hoping to be able to capture and export to a spreadsheet.
Example
Cell 1A…………...Cell 1B…………….Cell 1C
00:01:23 ……….00:02:45………...Comments
Cell 2A…………...Cell 2B…………….Cell 2C
00:03:11………..00:05:22…………Comments
+5Hi
You could then use a short text for them to add in the timestamps, but I don’t think we have a way to verify that the timestamp format is correct. Is this the calculation you’re hoping for?
Sounds like it’s not possible then! Thanks for investigating this idea with me.
+5No problem, 
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
