I am attempting to create a form to collect biological records (bird sightings, etc.) in a database. Records will be entered by members only, but each member might submit tens of records at one time, creating multiple database entries. For this reason I want to make the process as quick and easy as possible. There are a number of things that would help, but I'm struggling to find information on whether any of them are possible:
1. When a member loads up the form page, can their name be automatically added to the name field? It would need to be editable, as they may enter a record for someone else.
2. Can other fields (specifically one for 'location' of sighting) be autofilled with the value from the previous record submitted by that member (i.e. the location in the last record). It would need to be specific to each member, rather than just the most recent entry in the database. This would save considerable time when entering many sightings for the same site.
3. Finally, is it possible for a member to view and edit all of the records that they have submitted to the database in the past, but not other people's?
Unfortunately, my coding experience is limited and out of date, so any explanations might need to be more basic than your average response!
Many thanks in advance.