Hi All, I m a soccer coach, and I started t

[Avenchine]

Hi All,

I m a soccer coach, and I started to develop a small Appsheet App to manager my teams ( about 24 juniors and 3 teams), training session and players attendance. The App is based on my current google sheet.

I facing now a small problem and need some help . here the situation:

To manage attendence with appsheet, i split the current gsheet to 3 sheets:

1 - players (E): PID, data: name, birthdate, Ref to Team… 2 - Activities (E):

AID, Date, Type, location, and a Ref to Team,

3 - Attendance - ® : ID, Present?, Ref to AID, Ref to PID,…

To enhance the workflow and the simplicity I need to accomplish the Following:

• Create a new Activity for a team A (5 players),with Add Button from the Activities View is GREAT ! this will add a new row to the [Activities sheet]:

AID004 ; 06/02/2018; Training; Indoor; TeamA

• Instead to open the Attendance view and add each player, one by one, i need the App to add automatically

a new row for each Team A player to the [attendance sheet]:

ID0051; 1 ;

AID004, PID001 ID0052; 1 ;

AID004, PID002 ID0053; 0 ;

AID004, PID003 ID0054; 1 ;

AID004, PID004 ID0055; 0 ;

AID004, PID005

[Players Sheet] looks like this: PID001;

Sharapova; TeamA;… PID002;

Federer;

TeamA;… PID003;

Hingis;

TeamA;… PID004;

Williams;

TeamA;… PID005;Haas;

TeamA;…

Is there any way to do this ?

Thank you in advance