Hello,
I am looking to create an intake form to track attendance at a conference, where the potential attendees are contained in a SharePoint list and/or Excel spreadsheet. I would like the user to be able to pull the following information from the SharePoint list/Excel spreadsheet for each attendee upon entrance:
- Event Name (from list of events);
- Date (to be entered manually);
- Once Event Name and Date are Selected, I would like the user to be able to input multiple attendees with the following information for each event/date;
- Company Name to be selected from a list of options (each company has a handful of potential attendees associated with it);
- Attendee, selected from a list of attendees driven by the Company selected above (once you select the Company, a handful of Company representatives will show as options);
- Repeat selection of Company and Attendee, in the 2 preceding steps until all attendees for that date have been entered.
When the user is finished entering the attendees for a given event and date, as detailed above, the user would "submit" the data and transfer it to another list/worksheet with these columns of data: EVENT NAME, DATE, COMPANY, ATTENDEE.
This process would be repeated for each day of the Event with the data being added to the list/spreadsheet of attendees. I'd love for this functionality to be available in a mobile app.
Thanks in advance!
Share
Report
All responses (
Answers (
155,644
