Do you mean that the form only accept the date-format you choose? So that they only can fill 1/16 and not 1/16/12 or something? Its not possible I think. You have to tell them by the helptext, and exlain it there.
Or, use one checkbox for date (1-31) and one for year. Then sum this in spreadsheet?? kl. 21:39:18 UTC+1 onsdag 16. januar 2013 skrev Sue Etter følgende: > > I've very new at this so I hope I'm asking the right question in the right > place. I've created a little program really a form that fills in fields on > a Google Spreadsheet. The problem I have is that if I fill in a date with > just a month and year (1/16) the data on the spreadsheet automatically > becomes 1/16/2013. I know I can go into the spreadsheet and format the > column to show just M/Y but that does not fix the issue. I would like to > find some way to code the form so the column is formatted already and all > entries will read just as they are typed and not be changed automatically > into a full date. Some people my type the full year or just the month and > day - can I have the column post EXACTLY as the form is filled out? I have > already coded it as .Text. Any suggestions would be greatly appreciated. > > Thank you in advance. > Sue > -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
