Greetings from Puerto Vallarta, Mexico!
I hope any of you can help me. Iโm creating a โSatisfaction Surveyโ (service related, exported from Google Forms) in which we collect information from our guests; one field in particular is BIRTHDAY. Typically, users donโt want to share their birth YEAR, and Iโm having difficulties to remove the YEAR from the DATE type of field on the appโฆ is there a way so the user can only specify month and day (MM/DD) in the app?
Warm regards. German
@Marketing_Cafe_des_A Itโs not possible to do that right now. What you could do is create two separate columns (birth month and birth date) and then combine them using an app formula or a sheet formula.
This might be helpful date conversion info. Learning WIKI learningwiki.net
Tonyโs right, itโll be much easier to build this yourself.
You should use data validation in your sheet to set up Enum in your app.
Set as buttons so itโs easy to pick the day and month.
If you set this as
reject other inputs this will also ensure that you have no typos.
@tony Thank you. Can I create two separate columns in the app, but still save the info (result) in one column on the Google spreadsheet using a formula?
@Stephen_Mattison Thank you. I will try to add buttons instead of typing.
@Marketing_Cafe_des_A Yes, create a column with an app formula that looks like this:
TEXT([Month Column]) & โ/โ & TEXT([Day column])
User | Count |
---|---|
40 | |
34 | |
30 | |
23 | |
17 |