mclintonjbj Posted January 4, 2013 Report Share Posted January 4, 2013 I have a form that I am allowing users to submit event information, photos and dates. How can I allow people to submit things with the date? If someone submits an event with a date that has already been submitted they get an error message. I don't want the records to overwrite each other in the table though. Quote Link to comment Share on other sites More sharing options...
0 bahar_vm Posted January 7, 2013 Report Share Posted January 7, 2013 First is to have a date/time field in your table then you include it in your DataPage (submission form) to enable users submit the date of the event. Make sure the date field in the table is not set as "Unique". If you see error when submitting duplicate dates, it could be that you have it set to be "Unique" in the table. However make sure in your table you have an ID field which is set to be unique as identifier of each record. Best, Bahar M. Quote Link to comment Share on other sites More sharing options...
0 mclintonjbj Posted January 7, 2013 Author Report Share Posted January 7, 2013 I believe it is working now. Took the Unique off in the table. Thanks a bunch. Quote Link to comment Share on other sites More sharing options...
Question
mclintonjbj
I have a form that I am allowing users to submit event information, photos and dates.
How can I allow people to submit things with the date?
If someone submits an event with a date that has already been submitted they get an error message.
I don't want the records to overwrite each other in the table though.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.