Title: Dynamic/Sequential field ID
Last modified: August 30, 2016

---

# Dynamic/Sequential field ID

 *  Resolved [sydsax](https://wordpress.org/support/users/sydsax/)
 * (@sydsax)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/dynamicsequential-field-id/)
 * 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://wordpress.org/plugins/ns-google-sheets-connector/](https://wordpress.org/plugins/ns-google-sheets-connector/)

Viewing 5 replies - 1 through 5 (of 5 total)

 *  Plugin Author [Never Settle](https://wordpress.org/support/users/neversettle/)
 * (@neversettle)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/dynamicsequential-field-id/#post-6301155)
 * 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](https://wordpress.org/support/users/sydsax/)
 * (@sydsax)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/dynamicsequential-field-id/#post-6301177)
 * 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](https://wordpress.org/support/users/neversettle/)
 * (@neversettle)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/dynamicsequential-field-id/#post-6301233)
 * 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](https://wordpress.org/support/users/sydsax/)
 * (@sydsax)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/dynamicsequential-field-id/#post-6301234)
 * 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](https://wordpress.org/support/users/neversettle/)
 * (@neversettle)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/dynamicsequential-field-id/#post-6301235)
 * 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.

 * ![](https://s.w.org/plugins/geopattern-icon/ns-google-sheets-connector_feab92.
   svg)
 * [NS Google Sheets Connector](https://wordpress.org/plugins/ns-google-sheets-connector/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/ns-google-sheets-connector/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/ns-google-sheets-connector/)
 * [Active Topics](https://wordpress.org/support/plugin/ns-google-sheets-connector/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/ns-google-sheets-connector/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/ns-google-sheets-connector/reviews/)

## Tags

 * [Google Sheets](https://wordpress.org/support/topic-tag/google-sheets/)

 * 5 replies
 * 2 participants
 * Last reply from: [Never Settle](https://wordpress.org/support/users/neversettle/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/dynamicsequential-field-id/#post-6301235)
 * Status: resolved