Hi! Can I manually add entries to the spreadsheet? Or is the sheet only for entries from the Gravity Form?

Just bought the plugin but the support docs are broken, No images are displaying. https://webholics.org/knowledgebase/integrate-google-spreadsheet-gravity-forms/

Question about this. -Use Conditions on fields to send data only if set conditions are met.

Can I set a condition if field x = 21 data will be sent to google sheet 21 and if field x = 22 data will be sent to google sheet 22?

I’d be happy to renew our licence. But I’d like the plugin to be php8 compatible. For now, it’s not:

Fatal error: Unparenthesized `a ? b : c ? d : e` is not supported. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in …/httpdocs/webroot/wp-content/plugins/gravity-forms-spreadsheet-addon/inc/class-gfspreadsheetreview.php on line 265

Should be quite easiy to solve

Hello – I have downloaded the plug in, installed it, configured the API (it says authorized), I can view the spreadsheet list but it does not list any names in the “sheet” section where I need to select a sheet. Google says the app does have access to google docs and google drive.

I have a couple of presale questions

1) Can I output to Google Sheets the “source url” that the form was sent from?

This info is a column you can see in Gravity Forms admin (Entries panel) however it’s not a field that is specifically part of the form being sent. I have the same form on many pages which I want to track which pages it got submitted from.

2) Can I have multiple forms (even from different websites) output to the same Google Sheet?

Hi, does the plugin match automatically the form fields with the sheet col names? or this is something manual?

Hi! I sent a message via your website a couple of days ago, but I didn’t get any notification back. So I am posting my concerns here:

I have been using Gravity Forms Google Spreadsheet Addon for years. Recently I encountered two independent issues that I would like to bring to your attention:

1. Entry Date: Format Due to localization, I am using the the following Settings => General; Date > Y.m.d; Time > H:i

The issue is that when the Entry Date field is processed into my Google Sheet, the timestamp will show as Y.m.d, H:i, which creates a problem with Google Sheets as it cannot be recognized as a Date. I tried writing a formula that substitutes the problematic characters (really, it’s only the comma). Still, I try to avoid ArrayFormula’s within the same sheet that your plugin writes to, as it causes issues with inserting. Therefore I query it into another sheet, where I apply the formulas. However, with the date format issue, those rows will not appear due to the comma in the cell. I checked in the gf_entry table, and the date_created columns use YYYY-mm-d H:i:s The odd thing is that other feeds on this same installation seem to be working fine (using the date_created format). If I re-sync the entries, it seems to be okay. It’s only when new rows are added (no cell format applied) to the sheet that things go wrong. I don’t know why that comma gets added.

2. Entry Updates I am using the Gravity Flow add-on or processing the Add-on when an entry is updated, which some others have asked you about on CodeCanyon.

Thank you!

Hello, a few issues/questions. I did send this to your swb support so ignore one if you prefer answering here or there. But I felt this info is important for people deciding to buy or not.

1: If we change the column order in the spreadsheet or add admin columns after it has been mapped it messes everything up and needs to be completely re-mapped. Is this normals? It seems it mapps to the column Letter and not the heading.

2: Can I re-sync the same item to the same row? When we update submissions data in Gravity forms it does not sync to the spreadsheet unless you manually sync which creates a duplicate entry in the spreadsheet for EVERY submission.

3: Can conditional logic for when it sync apply to admin fields edits which happens in the back-end after the initial form is submitted.

Hi webholics, isnt this automated? I had some submission come in but the latest leads haven’t synced in. I hope you can answer this ASAP. I have been waiting for 14days for you guys to answer… Thank you

Hi, I’m currently having a problem with configuring the Feeds. I can select the spreadsheet which I want to connect the form but The under the Select Sheet it doesn’t show the available sheet to map the fields. https://paste.pics/G63EO

Hello,

can i change the adress to different columns like street+nr, zip, city i need it for german format in different columns.

Can you only submit unique orders to google sheet. i have many customer how submit moretimes to GF and i only whant the mosted full submission into google sheets.

do you have also replace function? exp. Customer insert “1” and when customer insert “1” we want to insert a sentences into google sheet.

best regards Oliver

Hello there,

I’m going to buy the wordpress plugin but I have a few questions.

I want a verification section before the customer fills the form.

If the verification is valid I want it to fill the form.

Example;

The customer has a gift code. The customer will enter the gift code in the textbox and if the code is valid, the form will open and then I will receive information such as the customer’s name and surname.

If this is possible I want to buy your plugin.

will it sync when gravity form entry is updated?

I already configured mostly everything and successfully seelcted a spreadsheet and a sheet, but I’m having trouble mapping the headers and have the following message: Map Sheet Headers No mapping fields are available.

Any way to fix this???

When using the plugin, there is no loading notification for the user that the form has been submitted. At the same time, there are no problems in the console.

Pre-sale question: Is this capable of sending data from several different forms to a single Google spreadsheet? For example: three different forms to a single sheet with each separate set of form entries as a separate tab inside the spreadsheet.

Is it compatible with gravity flow?

Is it possible to automatically update specific fields of a row in excel sheet, if an entry of the gravity form is updated?

I just bought your plugin and I can’t find a way to synchronize the payment meta information (gravity paypal and stripe add-ons).

Can I send the payment info to gSheet? 1. whether the payment was successful or not; 2. Transaction ID; 3. date and time of the transaction.

This is important to me. Otherwise I have to request a refund. Thanks in advance