Updated: 3rd November 2025 - LC
What: Updating the ISCA_Certification_Part2_Rating spreadsheet with the latest feedback from the ISCA Certification Part 2 JotForm submissions to send to Lifecoachmag.
Who: VA
Why: To keep ISCA testimonial data accurate and current for reporting, evaluation, and quality assurance purposes.
When: Once a week or whenever new JotForm submissions are received.
Open Dropbox and locate the file:
2022 Virtual Assistant Team > TESTIMONIALS > 00. Sandy to Check > 3. ISCA > 01. Certification Testimonials > ISCA_Certification_Part2_Rating
Open JotForm and find the form “ISCA Certification Part 2.”
Click More → Submissions to access the responses.
Compare JotForm submissions with the spreadsheet entries.
Copy new data (Name, Email, Rating, Feedback).
Paste into the matching columns in the spreadsheet.
Save the updated file and close once all entries are added.
Review link:
https://docs.google.com/forms/d/e/1FAIpQLSd0AVegpyEbYVS50IB42EtmxtHJhUcKnMHTks4Jwe1ZOMTPsA/viewform
Step-by-Step Procedure
1. Access the Spreadsheet
Open Dropbox.
Navigate to:
2022 Virtual Assistant Team > TESTIMONIALS > 00. Sandy to Check > 3. ISCA > 01. Certification Testimonials
Open the file “ISCA_Certification_Part2_Rating”.
2. Retrieve New Submissions from JotForm
Go to JotForm and log in to Sandy's account.
Locate the form titled “ISCA Certification Part 2.”
On the left-hand side of the form name, click “More” to display additional options.
Under the DATA column, click “Submissions.” This will open the submission dashboard in a new tab.
3. Identify New Entries
Compare the submissions on JotForm with the entries already listed in the spreadsheet.
Focus on entries not yet recorded in the spreadsheet.
4. Copy the Required Details
For each new submission, copy the following information:
Name
Rating "On a scale of 1 to 5, how would you rate your overall experience with ISCA?”
Feedback “Why did you give that rating?”
5. Paste the Data into the Spreadsheet
Return to the ISCA_Certification_Part2_Rating spreadsheet.
Paste each piece of information into the corresponding column.
Ensure the entries align with the column headers for Name, Email, Rating, and Feedback.
Double-check for formatting consistency (no extra spaces or broken text).
6. Save and Finalize
Once all new submissions have been added, click Save.
Close the spreadsheet when done.
Confirm all new JotForm submissions have been entered.
Verify no duplicates exist.
Check that ratings and comments align with the correct names and emails.