RSVP - Google Sheets integration

Ask the community
,
15

Here is what works - roughly

export function wixEvents_onRsvpCreated ( event ) {
const eventId = event . eventId ;

**const**  rsvp  =  event . rsvpForm . inputValues ; 

**const**  formfirstName  =  rsvp [ 2 ]. value ; 
**const**  formemail  =  rsvp [ 0 ]. value ; 
**const**  formlastName  =  rsvp [ 1 ]. value ; 
**const**  formComment  =  rsvp [ 3 ]. value ; 
console . log ( formfirstName ,  formlastName ,  formemail ,  formComment ); 


 **const**  values  =[ formfirstName ,  formlastName ,  formemail ,  formComment ]; 

 **const**  res  =  appendValuesWrapper ( values );

Interestingly, events that have more fields have different indexing.

The next trick is to loop though the array and add each result to the value constant. Hopefully that way it will grab everything.