search

verbb / formie

The most user-friendly forms plugin for Craft CMS.
Other
93 stars 68 forks source link

Connect unique Google Sheet ID per form? #1909

Open sjcallender opened 4 weeks ago

sjcallender commented 4 weeks ago

Question

Is it possible to connect to more than one sheet ID so different forms can export data to different Google Sheets? Currently, it appears only one sheet ID is allowed for the whole plugin.

Additional context

No response

engram-design commented 4 weeks ago

You select the sheet in the integration settings for the form.

image

If you want to target different files then they indeed need to be separate integrations.

sjcallender commented 4 weeks ago

Yes, sorry, I meant different files. From our view, it would be important to give marketing teams the ability to change files without dev intervention.

For our context, we moved from Freeform to Formie, in part, because you had the Sheets integration already. We didn't look close enough, but we anticipated more flexibility for our clients. Hoping it's a worthy new feature contender. 🙏🏼

engram-design commented 3 weeks ago

Gotcha. It’s something we can add for sure. Similar to the Webhook integration where there’s a URL set at the integration plugin-level settings, but this can be overridden per form.

I think the only issue may be the token access (the token granted to access one file might not work for another file), but I’ll do some testing.