6 comments found.
Subject: Issue with Conditional Fields and Custom Field Mapping in Google Sheet Connector
Email Body:
Hello, good morning.
I’m using your plugin Elementor Form Google Sheet Connector and I’ve noticed the following:
When the form fields have the same name as the column headers in the Google Sheet, the data is sent correctly. However, when I use conditional fields or when the form fields have different names than the Sheet headers, the data is not mapped or sent correctly.
Examples from my form:
Field: What is your name? → Sheet Header: nombre
Field: What email should we send your draw number to? → Sheet Header: email
Field: What WhatsApp number would you like us to contact you on? → Sheet Header: whatsapp
My questions: How can I manually map the form fields to the specific Google Sheet columns, especially when using conditional logic?
Is there a better or recommended way to ensure that conditional field data is recorded correctly in the Sheet?
I really appreciate your help and look forward to your response.
Kind regards,
When I create a new Google Sheets document from the form and assign it, everything works correctly. However, if I change the name of the sheet where the data is recorded, it stops working. It also doesn’t work if I assign an existing file or sheet. It only works if the sheet is created from the form and the name of the sheet where the data is received is not changed.
1. Manually mapping the form fields feature is not available yet, We will try to add this feature in the next release.
2. My question is are you using any third-party plugin for the condition field?
3. “Changing the name of the sheet where the data is recorded, it stops working” we look into this and will update you about it soon
Hello, thank you for your response.
The plugin I use for conditional logic is this one: https://add-ons.org/plugin/elementor-forms-conditional-logic/
However, in the second case I mentioned (when I changed the name of the sheet and reassigned it), I did not use conditional logic, I only changed the sheet name and stopped receiving data correctly. It also didn’t work when assigning an existing sheet; the only way it works is with a sheet created from scratch by the form.
I hope this information helps to better identify the issue.
I look forward to your updates.
Best regards
Thanks for the update. We look into this and will update you about it soon
Is it possible to connect Google Sheets with WooCommerce to view orders?
Not possible to view WooCommerce orders
Hello good day, is it possible to also see the products on the sheet and the quantities?
Not possible
Hello, good day. Pre-sale question: Is it possible to add functionalities from Autocrat in Sheets or apply them to this plugin to improve its performance and productivity?
Not supported yet
Google Sheet Connector For Elementor Forms – GLWS!
Thanks
Great work!
Thanks
