• Resolved sydsax

    (@sydsax)


    Hello and thank you for this plugin!
    My question is about dynamic fields, e.g.:
    I’ve a form with 20 surname fields with the cf7 field id like “surname01”, “surname02”, etc.
    How could I put in the google spreadsheet column to retrieve all the surname values under a unique column?

    I hope to have explained it clearly,
    thank you in advance!

    https://www.ads-software.com/plugins/ns-google-sheets-connector/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Never Settle

    (@neversettle)

    You should be able to easily add new column in your Google sheet with the headers being the exact field IDs from CF7, and they should be copied on over.

    It’s possible that I may be misunderstanding the question though, so let me know if that works for you :).

    Thread Starter sydsax

    (@sydsax)

    Thanks about that!
    My issue is column related ??
    Now every value is printed in a new column but I need to print some values as separate entry in the same column.

    It’s a fix that I should set in Google Sheet I guess, using transpose or something like that.
    So your plugin have no issues on that :).
    Or you’ve tips to share to achieve that? ??
    Thanks again!

    Plugin Author Never Settle

    (@neversettle)

    Yeah, the plugin itself can’t merge values into columns but you could create a formula in Google Sheets to be a combination of the column values you want, and then hide the columns in the Google Sheets interface which, in the end, would create the same effect. But, that customization would all be done within the Google sheet and our plugin would be simply configured as per usual.

    Thread Starter sydsax

    (@sydsax)

    Thanks for that,
    I’ll try breaking my head in the spreadsheet formulas.
    I don’t know if I’ve to mark as resolved, if it’s resolved could you mark this topic as resolved?
    Thanks again!

    Plugin Author Never Settle

    (@neversettle)

    You’re very welcome – happy to help :).
    Marking this as resolved.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Dynamic/Sequential field ID’ is closed to new replies.