formidable google sheet

Help Desk ›› How to ›› formidable google sheet
Log In to Reply
30 April, 2023 03:04:14
CAAM SSP
Topics: 2
Messages: 13
Hi

i would like to ask wether e2pdf file can be put in the google sheet. for now, every entry will push into google sheet. i would like to put the download link for entry pdf when required. for example, for now email push notification i put [e2pdf-download id="X"]. so then the recipient can download the pdf.

i try to put "[e2pdf-download id="X"]" in the formidable form, but no joy. no link generated at the google sheet.


thank you
30 April, 2023 04:45:49
E2Pdf
Support
Topics: 7
Messages: 3176
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.

We would really appreciate your feedback at WordPress.org!
1 May, 2023 04:38:36
CAAM SSP
Topics: 2
Messages: 13
so for asking. where to put the codes?
1 May, 2023 04:50:47
E2Pdf
Support
Topics: 7
Messages: 3176
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.
We would really appreciate your feedback at WordPress.org!
1 May, 2023 05:29:50
CAAM SSP
Topics: 2
Messages: 13
hi. i tries the method. but still not work.
1 May, 2023 05:36:26
E2Pdf
Support
Topics: 7
Messages: 3176
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 would really appreciate your feedback at WordPress.org!
1 May, 2023 05:40:30
CAAM SSP
Topics: 2
Messages: 13
no. the entry in the google sheet doesnt contain the pdf download link nor the download button. what do i missing. im using the RC Version 1.20.13
1 May, 2023 05:42:01
E2Pdf
Support
Topics: 7
Messages: 3176
We mean Formidable Forms Entry, not the Google Sheet.
We would really appreciate your feedback at WordPress.org!
1 May, 2023 05:47:48
CAAM SSP
Topics: 2
Messages: 13
owh. ic. it will affected to archive or only for new entry?
1 May, 2023 05:52:23
E2Pdf
Support
Topics: 7
Messages: 3176
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.
We would really appreciate your feedback at WordPress.org!
1 May, 2023 06:31:23
CAAM SSP
Topics: 2
Messages: 13
Noted. Ill try again.
1 May, 2023 09:02:49
CAAM SSP
Topics: 2
Messages: 13
[e2pdf-download id="513"] is works. there is a download button in the formidable entry. unfortunately, the option 2 [e2pdf-download id="513" esc_url_raw="true" output="URL"] is giving same results as option 1.
1 May, 2023 09:19:45
E2Pdf
Support
Topics: 7
Messages: 3176
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.
We would really appreciate your feedback at WordPress.org!
1 May, 2023 18:41:30
CAAM SSP
Topics: 2
Messages: 13
change to lowercase, nothing appered
2 May, 2023 00:33:35
E2Pdf
Support
Topics: 7
Messages: 3176
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.
We would really appreciate your feedback at WordPress.org!
2 May, 2023 18:42:08
CAAM SSP
Topics: 2
Messages: 13
the link works, unfortunately the link given in the formidable view and generated in the google sheet is not the same. in the formidable view you can download the pdf, but in the google sheet is not. giving error 404.

what is identify is

https://xxx.com/?page=e2pdf-download&uid=6ae6fe8277688c6c84d916921d42b962 (this one generated at formidable view and work)

https://xxx.com/?page=e2pdf-download&uid=6ae6fe8277688c6c84d916921d42b962 (generated at google sheet and not working)

why the link generated is not the same?

3 May, 2023 02:29:33
E2Pdf
Support
Topics: 7
Messages: 3176
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.

We would really appreciate your feedback at WordPress.org!