Topics › All Forums › General › The Corner Pub › Google Docs question
| February 17, 2014 at 5:54 pm Quote #33046 | |
 frankm (4891) | 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? frankmQuote |
| February 17, 2014 at 6:09 pm Quote #33047 | |
 ron (11779) | 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: ronQuote |
| February 17, 2014 at 6:43 pm Quote #33049 | |
| frankm (4891) |
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. frankmQuote |
| February 17, 2014 at 8:12 pm Quote #33050 | |
| ron (11779) | 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. ronQuote |
| 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. guitardQuote |
| February 17, 2014 at 10:07 pm Quote #33060 | |
| frankm (4891) | 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. frankmQuote |
You must be logged in to reply to this topic.