In the app we have two tables, one for events and the other for participants, which can participate in more than one event.
For each event, the attendance lists are completed by hand, due to the requirements of the project’s funders, so these attendance lists must be entered in the system.
To reduce the time and error related to enter the lists in the system, we would like you to:
1- The [Name] field suggests the names, taking as a reference those already existing in the participants table (NOTE: we already do this, which allows us to filter and show the existing participant information as a suggestion in the other fields for your selection).
2- That when selecting a participant from those displayed in the list, auto-comomplete the other fields with the information (sex, age, telephone number, etc.) previously registered for the selected participant.
3- If it is a new participant, to be able to enter all the data of the same in each field of the table (name, sex, age, telephone, etc.)
If the participant exists in the participant table, be able to select their name and last name and have the other fields completed automatically, but if it is a new one, be able to complete the participants registration form, all from and in participants table.
Thanks in advance.