Skip to main content

How to Generate Missing Payable Order IDs

If your Payable Google form is issuing the No Order Found error message and you are missing Payable Order IDs as a result, read this!

Updated this week

Known Problem Overview


Our Payable Forms add-on relies on Google's "Triggers" to let us know when your Form receives a new submission.

From time-to-time, Google can have outages and issues with their triggers that are outside of our control. When this happens, we are not aware of your new Form submissions.

On April 7th a bug impacting 100s of developers also impacted our triggers: https://issuetracker.google.com/issues/184759540

On Jan 17th to 19th 2024 a bug impacting 100s of developers and our ability to get Form Response Data: https://issuetracker.google.com/issues/320903174

Hopefully, these types of issues will be resolved quickly by Google.

When you look in your connected Google Sheet, if you do not have a Payable ID with a recent Form submission, that submission was likely impacted by a Trigger outage.

Current Workaround

We have quickly created a way for you to trigger manual generation for any missing Payable IDs. This will calculate the total as usual and send the submitter an email with the payment link.

If some users have re-submitted or paid, you can delete those rows prior to running the script (right-click the row #, then click Delete). All submissions with no content in the Payable ID field will be generated and emailed.

How to Manually Generate Missing Payable Order IDs


To generate the IDs manually, go into your Google Form in Edit Mode. Refresh the Page. Wait 3-4 seconds. Click the Puzzle Piece and then "Payable Forms".

Payable Forms Add-On

Click the Add Ons puzzle piece icon, then Payable Forms

Generate Missing Payable IDs

Select the Generate Missing Payable IDs option

Go back to your connected Google Sheet, and you should now see the Payable IDs and the emails should have gone out to the submitters.

Find Missing Payable IDs

If the above Generate Missing Payable IDs function does not resolve an empty Payable Order ID cell in your spreadsheet, you may try running the Find Missing Payable IDs function. This function has been designed as a backup to target a selected row of data and can be useful if you erroneously delete Payable submission data from your sheet.

How to Use

  1. In your spreadsheet, click on the row #(s) to select the row of data that is missing a Payable Order ID

  2. Click on Extensions > Payable Forms > Find Missing Payable IDs

  3. You will be prompted to confirm the check for missing IDS, click Yes

    How to use the Find Missing Payable IDs function in Sheets


Video Overview

Did this answer your question?