formidable google sheet

Hi,

We expect to add the possibility of using e2pdf shortcodes as the default value in the next 1 - 2 weeks, which must solve the issue of passing data to the Google sheet.

However, as an alternative, you can try to implement the solution now by using the following PHP hook, which must be added to your theme functions PHP or as a PHP snippet. Snippet updates field value after entry created with PDF download link as https://example.com//?page=e2pdf-download&uid= (depending on settings).

https://codeshare.io/qPeKlA

It must be replaced:

27 - to your Formidable Forms Form ID
2431 - to the Field ID that must be updated with a PDF download link. It can be a "hidden" field for example.
513 - to your E2Pdf Template ID

Let us know please if such solution will fit your needs.

We remain at your service.

Hi,

We currently released an update to the RC version where was added default value shortcode support, so you do not need to use custom code.

1. Please, follow the steps to update the plugin to the RC version: https://e2pdf.com/support/desk/how-to-update-plugin-to-rc-release-candidate-version-from-e2pdf-com

2. After the update you must be able to use the shortcode as the "default value" (Screenshot attached):

[e2pdf-download id="513"] - will generate a PDF Download Button

[e2pdf-download id="513" esc_url_raw="true" output="url"] - will generate PDF URL

* "513" must be replaced with your E2Pdf Template ID.

Let us know please if it will work as expected.

We remain at your service.

Does the entry created under Formidable Forms contain the PDF download link?

P.S. Keep in mind please that must work only for new entries, or if the old entry will be updated via "Edit".

We mean Formidable Forms Entry, not the Google Sheet.

Unfortunately, It will affect only new entries.

If you do not have a lot of entries, you can just go to entry, click "Edit" -> "Save" and it must generate a PDF download link in the field. After saving, you must be able to trigger submission to google sheets with the PDF URL included.

If you do have a lot of entries and you need to have all old entries to have PDF URLs, I'm aware that it will require writing a custom script with PHP to update entries meta with generated PDF download URLs.

Sorry, our fault due to autocorrection. Please use "url" as lowercase:

[e2pdf-download id="513" esc_url_raw="true" output="url"]

P.S. If you need to update an existing entry, remove the value from the hidden field and save. It will regenerate PDF URL.

Can you please attach the screenshot of how the E2Pdf shortcode was placed? Or as an alternative, submit please support ticket with access details to WP Admin Dashboard here: https://e2pdf.com/support/request

Be sure that the Template "516" was changed to your E2Pdf Template ID.

Hi,

We did additional checks and it seems Formidable Forms sanitizes the Value that converts & to &. To avoid this, use the shortcode under Google Sheets action value as:

[2432 sanitize_url=0 keepjs=1]

* where "2432" is your Field ID containing the PDF URL.