Register Patient

This job was provided by an OpenFn.org user via the job library API.

Metadata

• Name: Register Patient
• Adaptor: @openfn/language-googlesheets
• Adaptor Version: v2.0.0
• Created over 5 years ago
• Updated over 3 years ago
• Score: 3 (an indicator of how useful this job may be)

Key Functions

appendValues, JSON

Expression

appendValues({
  spreadsheetId: '1EFkY4zD4qqxnJdH-QaeasKd1zXC-1sNKpEg08W-3sT0',
  range: 'COVID-19 Cases!A2',
  values: state => {
    const kobo = state.data.body;
    
    console.log('Submission data: ' + JSON.stringify(kobo, null, 2));
    
    return [
      [
        kobo['National_ID'],
        kobo['Patient_name'],
        kobo['Last_Name_of_Patient'],
        kobo['Sex'],
        kobo['Age'],
        kobo['Comments'],
        Date(),
      ],
    ];
  },
});