Trying to do something simple, but is stuck at the moment. I have 3 sheets, “Players”, “Events” “Responses”
Players - names of players
Events - Date and name of events
Responses - to capture the response i.e. player available for specific event or not.
First Screen - List the Events (calendar layout) - linked to “Events” sheet
Second Screen- provide the list (Inline List) of players - linked to “Players” sheet
Third Screen - (is form) which captures the response, with email date of response etc. - linked to “Responses” sheet. I am able to record the Players information and current-date and availability, via switch component.
Problem: I do not know how to share the Date selected in the First Screen from calendar layout, to record this when the Third Screed (form) is submitted.
It is most likely simple, but I am stuck at the moment, need some guidance.