Google Docs question

TopicsAll ForumsGeneralThe Corner PubGoogle Docs question

This topic has 3 voices, contains 5 replies, and was last updated by  frankm 1344 days ago.

February 17, 2014 at 5:54 pm Quote #33046

frankm
(4741)

I need to create a form in Google Docs. There are duplicate fields (the same information entered in one field will need to be entered into another field). I wanted to auto-fill the second field from the first (if possible). I’m not that familiar with Google Docs. I tried searching but came up with nothing. Any suggestions?


  Quote
February 17, 2014 at 6:09 pm Quote #33047

ron
(8931)

In a spreadsheet? If you want to duplicate what’s in cell E-14, for example, just put the following into the formula box for the field you wish the dupe to appear in:
=(e14)


  Quote
February 17, 2014 at 6:43 pm Quote #33049

frankm
(4741)

ron: In a spreadsheet?If you want to duplicate what’s in cell E-14, for example, just put the following into the formula box for the field you wish the dupe to appear in: =(e14)

I was told to use Google Docs vs Google Spreadsheets but I’m not well versed in either … if I could just use Microsoft Word or Microsoft Excel I could do something like what your suggesting but for some reason they wanted Google Docs. Maybe I’ll just create the form in Google Spreadsheets (use the formula you referenced) and then see if they are cool with that. Thanks for the feedback.


  Quote
February 17, 2014 at 8:12 pm Quote #33050

ron
(8931)

Ah, I’ve never used “Google Forms” before. Looks like you’d have to embed some custom JavaScript in the form to get it to do as you wish. Basically, a javascript event that fires when the person exits the one field, which then takes that value and displays it in another field.


  Quote
February 17, 2014 at 9:24 pm Quote #33058

guitard
(7354)

I won’t swear to it, but I think I’ve created a spreadsheet in Excel and then opened it in Google docs before. You can give that a quick test to see if it works and if so, you can then do your full document that way.


  Quote
February 17, 2014 at 10:07 pm Quote #33060

frankm
(4741)

Since I’m much better at Excel … I just created the form using Excel and opened it in Google Sheets. Everything seems to be good. I’ll find out tomorrow if Sheets is OK vs Docs. Thanks for the suggestions.


  Quote

You must be logged in to reply to this topic.