[Part 5] Monitor the status of each request from your spreadsheet

This article explains each request's approval status and how it is updated on your responses spreadsheet.

1. Where can you see the approval status of each request?

When someone submits a form, Form Publisher will automatically track each request's status in your responses spreadsheet.

_Part_5__Monitor_the_status_of_each_request_from_your_spreadsheet1.png

You can see this information under the [Form Publisher] Approval column.

_Part_5__Monitor_the_status_of_each_request_from_your_spreadsheet2.png

2. What does each approval status mean?

Pending

_Part_5__Monitor_the_status_of_each_request_from_your_spreadsheet3.png

Someone has sent a request and is waiting for the approver’s answer.

In your spreadsheet, the PENDING status lets you know that approval is requested.

Check your mailbox, open the generated file, and you’ll be able to see: Workflow status: pending.

_Part_5__Monitor_the_status_of_each_request_from_your_spreadsheet4.png

Approved

_Part_5__Monitor_the_status_of_each_request_from_your_spreadsheet5.png

If you decide to approve a request, the [Form Publisher] Approval status PENDING from your responses spreadsheet is replaced by APPROVED.

Rejected

_Part_5__Monitor_the_status_of_each_request_from_your_spreadsheet6.png

If you decide to reject a request, the process is the same as for the approval. The main difference is that PENDING is replaced by REJECTED.

Feedback requested

_Part_5__Monitor_the_status_of_each_request_from_your_spreadsheet7.png

Learn more

Before making your decision, you need further information from your respondent.

FEEDBACK REQUESTED appears under the approval status column of your responses spreadsheet.

Your respondent will then receive an email with your comment and will be able to edit his form responses and submit a new one.

If you’re satisfied with the new information he provided, you can finally approve or reject his request.

The generated file is updated after each step which allows you to be informed of the progress.

Now that you know how to configure an approval workflow with Form Publisher, read our use cases to find useful examples.

Comments

4 comments

Eric January 12, 2020 15:58

"validation" is "approval" this page needs to be updated :)

0

Comment actions Permalink
Oleg Gulevskyy February 06, 2020 19:41

Thanks for the heads up, Eric

I flagged this with our documentation team to review the wording.

Best,

FP Team

0

Comment actions Permalink
Vicki Chiu February 13, 2020 09:25 (Edited February 13, 2020 09:26)

When I set the approval workflow in Dec 18, it went smooth that the generated files can be updated as approved/rejected after the process.

Just sometimes there were bugs that the files remain pending even we have approved and recipients (including the applicant) cannot receive email updating them the form is approved.

Recently the problem become more serious...(we didn't make any changes to the template form)

All generated file (both excel file & google sheet) cannot be not updated after the approval process...
They are all remain "pending" even the response shows it is approved?

How can I solve this problem...?

0

Comment actions Permalink
Richard Debrabant February 14, 2020 15:19

Hi Vicki Chiu,

We’re sorry to hear that, could you contact us here https://support.form-publisher.com/hc/en-us/requests/new and provide us with your template and spreadsheet please ?

This way will be able to investigate this issue.

Thanks !

0

Comment actions Permalink