AI助手支持GPT4.0
This plugin provides integration between Caldera Forms and Caldera表单和
/sheets/" rel="nofollow">Google Sheets.
/ sheets /“ rel =” nofollow“> Google表格。
It adds new processor to Caldera Forms that enables sending of submitted forms to Google Sheets.
它将新的处理器添加到Caldera Forms中,从而可以将提交的表单发送到Google表格。 p>
Important Note
重要说明 em> p>Due to the changes in Google API policies, method for connecting plugin to Google Sheets was changed in version 1.7.由于Google API政策的更改,在1.7版中更改了将插件连接到Google表格的方法。From now on you have to use your own OAuth2 credentials, instead of shared ones as in the earler versions.从现在开始,您必须使用自己的OAuth2凭据,而不是早期版本中的共享凭据。If your plugin was connected to Google Sheets in earlier versions, it will continue working using shared credentials.如果您的插件已连接到早期版本的Google表格,则它将使用共享凭据继续运行。However in order to guarantee seamless plugin operation in the future, it is recommended that you re-connect your plugin using the new method.但是,为了保证将来无缝运行插件,建议您使用新方法重新连接插件。 p>Connecting to Google Sheets连接到Google表格 h4>Generate OAuth2 credentials 生成OAuth2凭据 em> p>Open the Google API Library打开 Google API库Connect to your Google account (enter credentials)连接到您的Google帐户(输入凭据) li> ul> li>Click Select a project, then NEW PROJECT, enter a name for the project – e.g.点击选择项目 strong>,然后点击 NEW PROJECT strong>,输入项目名称-例如“CalderaFormsGoogleSheets” – and click Create.“ CalderaFormsGoogleSheets” –并点击创建 strong>。 li>Make sure that created project is selected.确保已选择创建的项目。 li>Search for “sheets” and click on Google Sheets API.搜索“表格”,然后点击 Google表格API strong>。Click ENABLE.点击启用 strong>。 li>Open the Google API Console Credentials page打开 Google API控制台凭据页面 li>On the OAuth consent screen:在 OAuth同意屏幕 strong>上:For Application Name enter “Google Sheets Integration for Caldera Forms”对于应用程序名称 strong>,输入“ Caldera表单的Google表格集成” li>For Scopes for Google APIs click Add Scope, select ../auth/spreadsheets scope and click ADD对于 Google API的作用域 strong>,单击添加作用域 strong>,选择 ../ auth / spreadsheets strong>作用域,然后单击 ADD strong >> li>For Authorised domains enter domain name of your site对于授权域 strong>,输入您站点的域名 li>Click Save点击保存 strong> li> ul> li>On the Credentials screen, select Create credentials, then OAuth client ID在凭据 strong>屏幕上,选择创建凭据 strong>,然后选择 OAuth客户端ID strong>For Application type select Other 对于应用程序类型 strong>,选择其他 strong> li>For Name enter “Google Sheets Integration for Caldera Forms”对于名称 strong>,输入“ Caldera表单的Google表格集成” li>Click Create点击创建 strong> li> ul> li>On the page that appears, your OAuth2 “client ID” and “client secret” are displayed.在出现的页面上,显示您的OAuth2“客户端ID”和“客户端密码”。Leave this page open, so that you can copy/paste values from it to the plugin configuration.使此页面保持打开状态,以便您可以将值从该页面复制/粘贴到插件配置。Alternatively, copy the values to some clipboard.或者,将值复制到某个剪贴板。 li> ul>Add credentials to the plugin 向插件添加凭据 em> p>Open a new page and go to plugin Settings screen (or to Admin Panel > Caldera Forms > Google Sheets screen)打开一个新页面,然后转到插件“设置” strong>屏幕(或进入管理面板> Caldera Forms> Google表格 strong>屏幕) li>For Google OAuth2 Client ID paste “client ID” from Google OAuth2 Credentials page 对于 Google OAuth2客户端ID strong>,请从Google OAuth2凭据页面粘贴“客户端ID” li>For Google OAuth2 Secret paste “client secret” from Google OAuth2 Credentials page对于 Google OAuth2机密 strong>,请从Google OAuth2凭据页面粘贴“客户端机密” li>Click Get Code button – you will be redirected to Google Sheets authorization page点击获取代码 strong>按钮–您将被重定向到Google表格授权页面Connect to your Google account (enter credentials)连接到您的Google帐户(输入凭据) li> ul> li>You will see This app isn’t verified screen – this is OK, because you are authenticating your own site您将看到此应用未经验证 strong>屏幕-可以,因为您正在验证自己的网站Click Advanced and then click Go to Google Sheets Integration for Caldera Forms (unsafe)单击高级 strong>,然后单击转到Caldera表单的Google表格集成(不安全) strong> li> ul> li>In the Grant Google Sheets Integration for Caldera Forms permission screen click Allow在授予Google表格集成Caldera Forms权限 strong>屏幕中,点击允许 strong> li>In the Confirm your choices screen click Allow在确认选择 strong>屏幕中,点击允许 strong> li>Copy generated “access code” to the clipboard将生成的“访问代码”复制到剪贴板 li>Paste “access code” into the Google Access Code in plugin Settings screen将“访问代码”粘贴到插件“ 设置 strong>”屏幕中的 Google访问代码 strong>中 li>Click Save点击保存 strong> li> ul>Using The Plugin使用插件 h4>In Google Sheets 在Google表格中 em> p>Create a new Sheet and name it 创建一个新工作表并命名为 li>Rename the tab on which you want to capture the data重命名要在其上捕获数据的选项卡 li> ul>If you wish to record all of your Caldera Form fields, proceed to the next step and enable “Automatically generate header” option in processor settings.如果您希望记录所有的Caldera Form字段,请继续执行下一步,并在处理器设置中启用“自动生成标头”选项。 p>If you wish to record only selected fields (or for some reason automatic header generation doesn’t work for you) manually enter column names in the first row as follows:如果您只想记录选定的字段(或者由于某种原因而无法自动生成标题),请在第一行中手动输入列名,如下所示: p>Enter “id” in the the first column name在第一列名称中输入“ id” li>Enter “date” in the the second column name在第二列名称中输入“日期” li>Enter slug names of your Caldera Form fields as the following column names输入您的破火山口表单字段的子弹名称作为以下列名称 li> ul>In Caldera Forms 破火山口形式 em> p>Add Google Sheets processor to your form将Google表格处理器添加到您的表单中 li>Configure Google Sheets sheet and tab name配置Google表格的工作表和标签名 li>If you didn’t manually create spreadsheet header in the previous step, check “Automatically generate header” checkbox 如果在上一步中没有手动创建电子表格标题,请选中“自动生成标题”复选框 li>Click ‘Save Form’ to save processor settings点击“保存表格”以保存处理器设置 li>Test your form submit and verify that the data shows up in your Google Sheet测试您的表单提交并验证数据是否显示在Google表格中 li> ul>Automatic Header Generation自动标题生成 h4>When “automatic header generation” is enabled, the plugin verifies spreadsheet header on each new form submission and adds new fields to it if needed.启用“自动标题生成”后,插件会在每个新表单提交时验证电子表格标题,并在需要时向其添加新字段。Note that it never deletes fields from the header – as this would also delete some submission data – though you can do it manually.请注意,尽管您可以手动执行操作,但它永远不会从标题中删除字段,因为这也会删除一些提交数据。You may also manually reorder columns as you wish.您也可以根据需要手动对列进行重新排序。 p>It should be noted that header verification takes some time and may slow down form submission for large forms.应注意,标头验证会花费一些时间,并且可能会减慢大型表单的提交速度。Therefore consider using it only for your “test submissions” – after initial form creation and/or modification – and turning it off afterwards.因此,考虑在最初的表单创建和/或修改之后,仅将其用于“测试提交”,然后将其关闭。 p>Important Notes重要注意事项 h4>Your slug names should be in english only (use only the following ASCII characters – [A-Za-z0-9])您的子弹名称只能是英文(仅使用以下ASCII字符– [A-Za-z0-9]) li>Your slug names should be lowercase only (no capital letters)您的子弹名称只能是小写(不能使用大写字母) li>If your slug names have underscores, replace them with dashes in Google Sheet column names (e.g. for ‘name_english’ slug use ‘name-english’ column name)如果您的子句名称带有下划线,请在Google表格的列名称中用破折号代替(例如,对于“ name_english”子句使用“ name-english”列名) li> ul>Acknowledgements致谢 h4>The plugin is heavily based on CF7 Google Sheets Connector该插件很大程度上基于 CF7 Google表格连接器 p>
Due to the changes in Google API policies, method for connecting plugin to Google Sheets was changed in version 1.7.
由于Google API政策的更改,在1.7版中更改了将插件连接到Google表格的方法。
From now on you have to use your own OAuth2 credentials, instead of shared ones as in the earler versions.
从现在开始,您必须使用自己的OAuth2凭据,而不是早期版本中的共享凭据。
If your plugin was connected to Google Sheets in earlier versions, it will continue working using shared credentials.
如果您的插件已连接到早期版本的Google表格,则它将使用共享凭据继续运行。
However in order to guarantee seamless plugin operation in the future, it is recommended that you re-connect your plugin using the new method.
但是,为了保证将来无缝运行插件,建议您使用新方法重新连接插件。 p>
Generate OAuth2 credentials
生成OAuth2凭据 em> p>Open the Google API Library打开 Google API库Connect to your Google account (enter credentials)连接到您的Google帐户(输入凭据) li> ul> li>Click Select a project, then NEW PROJECT, enter a name for the project – e.g.点击选择项目 strong>,然后点击 NEW PROJECT strong>,输入项目名称-例如“CalderaFormsGoogleSheets” – and click Create.“ CalderaFormsGoogleSheets” –并点击创建 strong>。 li>Make sure that created project is selected.确保已选择创建的项目。 li>Search for “sheets” and click on Google Sheets API.搜索“表格”,然后点击 Google表格API strong>。Click ENABLE.点击启用 strong>。 li>Open the Google API Console Credentials page打开 Google API控制台凭据页面 li>On the OAuth consent screen:在 OAuth同意屏幕 strong>上:For Application Name enter “Google Sheets Integration for Caldera Forms”对于应用程序名称 strong>,输入“ Caldera表单的Google表格集成” li>For Scopes for Google APIs click Add Scope, select ../auth/spreadsheets scope and click ADD对于 Google API的作用域 strong>,单击添加作用域 strong>,选择 ../ auth / spreadsheets strong>作用域,然后单击 ADD strong >> li>For Authorised domains enter domain name of your site对于授权域 strong>,输入您站点的域名 li>Click Save点击保存 strong> li> ul> li>On the Credentials screen, select Create credentials, then OAuth client ID在凭据 strong>屏幕上,选择创建凭据 strong>,然后选择 OAuth客户端ID strong>For Application type select Other 对于应用程序类型 strong>,选择其他 strong> li>For Name enter “Google Sheets Integration for Caldera Forms”对于名称 strong>,输入“ Caldera表单的Google表格集成” li>Click Create点击创建 strong> li> ul> li>On the page that appears, your OAuth2 “client ID” and “client secret” are displayed.在出现的页面上,显示您的OAuth2“客户端ID”和“客户端密码”。Leave this page open, so that you can copy/paste values from it to the plugin configuration.使此页面保持打开状态,以便您可以将值从该页面复制/粘贴到插件配置。Alternatively, copy the values to some clipboard.或者,将值复制到某个剪贴板。 li> ul>Add credentials to the plugin 向插件添加凭据 em> p>Open a new page and go to plugin Settings screen (or to Admin Panel > Caldera Forms > Google Sheets screen)打开一个新页面,然后转到插件“设置” strong>屏幕(或进入管理面板> Caldera Forms> Google表格 strong>屏幕) li>For Google OAuth2 Client ID paste “client ID” from Google OAuth2 Credentials page 对于 Google OAuth2客户端ID strong>,请从Google OAuth2凭据页面粘贴“客户端ID” li>For Google OAuth2 Secret paste “client secret” from Google OAuth2 Credentials page对于 Google OAuth2机密 strong>,请从Google OAuth2凭据页面粘贴“客户端机密” li>Click Get Code button – you will be redirected to Google Sheets authorization page点击获取代码 strong>按钮–您将被重定向到Google表格授权页面Connect to your Google account (enter credentials)连接到您的Google帐户(输入凭据) li> ul> li>You will see This app isn’t verified screen – this is OK, because you are authenticating your own site您将看到此应用未经验证 strong>屏幕-可以,因为您正在验证自己的网站Click Advanced and then click Go to Google Sheets Integration for Caldera Forms (unsafe)单击高级 strong>,然后单击转到Caldera表单的Google表格集成(不安全) strong> li> ul> li>In the Grant Google Sheets Integration for Caldera Forms permission screen click Allow在授予Google表格集成Caldera Forms权限 strong>屏幕中,点击允许 strong> li>In the Confirm your choices screen click Allow在确认选择 strong>屏幕中,点击允许 strong> li>Copy generated “access code” to the clipboard将生成的“访问代码”复制到剪贴板 li>Paste “access code” into the Google Access Code in plugin Settings screen将“访问代码”粘贴到插件“ 设置 strong>”屏幕中的 Google访问代码 strong>中 li>Click Save点击保存 strong> li> ul>Using The Plugin使用插件 h4>In Google Sheets 在Google表格中 em> p>Create a new Sheet and name it 创建一个新工作表并命名为 li>Rename the tab on which you want to capture the data重命名要在其上捕获数据的选项卡 li> ul>If you wish to record all of your Caldera Form fields, proceed to the next step and enable “Automatically generate header” option in processor settings.如果您希望记录所有的Caldera Form字段,请继续执行下一步,并在处理器设置中启用“自动生成标头”选项。 p>If you wish to record only selected fields (or for some reason automatic header generation doesn’t work for you) manually enter column names in the first row as follows:如果您只想记录选定的字段(或者由于某种原因而无法自动生成标题),请在第一行中手动输入列名,如下所示: p>Enter “id” in the the first column name在第一列名称中输入“ id” li>Enter “date” in the the second column name在第二列名称中输入“日期” li>Enter slug names of your Caldera Form fields as the following column names输入您的破火山口表单字段的子弹名称作为以下列名称 li> ul>In Caldera Forms 破火山口形式 em> p>Add Google Sheets processor to your form将Google表格处理器添加到您的表单中 li>Configure Google Sheets sheet and tab name配置Google表格的工作表和标签名 li>If you didn’t manually create spreadsheet header in the previous step, check “Automatically generate header” checkbox 如果在上一步中没有手动创建电子表格标题,请选中“自动生成标题”复选框 li>Click ‘Save Form’ to save processor settings点击“保存表格”以保存处理器设置 li>Test your form submit and verify that the data shows up in your Google Sheet测试您的表单提交并验证数据是否显示在Google表格中 li> ul>Automatic Header Generation自动标题生成 h4>When “automatic header generation” is enabled, the plugin verifies spreadsheet header on each new form submission and adds new fields to it if needed.启用“自动标题生成”后,插件会在每个新表单提交时验证电子表格标题,并在需要时向其添加新字段。Note that it never deletes fields from the header – as this would also delete some submission data – though you can do it manually.请注意,尽管您可以手动执行操作,但它永远不会从标题中删除字段,因为这也会删除一些提交数据。You may also manually reorder columns as you wish.您也可以根据需要手动对列进行重新排序。 p>It should be noted that header verification takes some time and may slow down form submission for large forms.应注意,标头验证会花费一些时间,并且可能会减慢大型表单的提交速度。Therefore consider using it only for your “test submissions” – after initial form creation and/or modification – and turning it off afterwards.因此,考虑在最初的表单创建和/或修改之后,仅将其用于“测试提交”,然后将其关闭。 p>Important Notes重要注意事项 h4>Your slug names should be in english only (use only the following ASCII characters – [A-Za-z0-9])您的子弹名称只能是英文(仅使用以下ASCII字符– [A-Za-z0-9]) li>Your slug names should be lowercase only (no capital letters)您的子弹名称只能是小写(不能使用大写字母) li>If your slug names have underscores, replace them with dashes in Google Sheet column names (e.g. for ‘name_english’ slug use ‘name-english’ column name)如果您的子句名称带有下划线,请在Google表格的列名称中用破折号代替(例如,对于“ name_english”子句使用“ name-english”列名) li> ul>Acknowledgements致谢 h4>The plugin is heavily based on CF7 Google Sheets Connector该插件很大程度上基于 CF7 Google表格连接器 p>
ul>
li>
“CalderaFormsGoogleSheets” – and click Create.
“ CalderaFormsGoogleSheets” –并点击创建 strong>。 li>Make sure that created project is selected.确保已选择创建的项目。 li>Search for “sheets” and click on Google Sheets API.搜索“表格”,然后点击 Google表格API strong>。Click ENABLE.点击启用 strong>。 li>Open the Google API Console Credentials page打开 Google API控制台凭据页面 li>On the OAuth consent screen:在 OAuth同意屏幕 strong>上:For Application Name enter “Google Sheets Integration for Caldera Forms”对于应用程序名称 strong>,输入“ Caldera表单的Google表格集成” li>For Scopes for Google APIs click Add Scope, select ../auth/spreadsheets scope and click ADD对于 Google API的作用域 strong>,单击添加作用域 strong>,选择 ../ auth / spreadsheets strong>作用域,然后单击 ADD strong >> li>For Authorised domains enter domain name of your site对于授权域 strong>,输入您站点的域名 li>Click Save点击保存 strong> li> ul> li>On the Credentials screen, select Create credentials, then OAuth client ID在凭据 strong>屏幕上,选择创建凭据 strong>,然后选择 OAuth客户端ID strong>For Application type select Other 对于应用程序类型 strong>,选择其他 strong> li>For Name enter “Google Sheets Integration for Caldera Forms”对于名称 strong>,输入“ Caldera表单的Google表格集成” li>Click Create点击创建 strong> li> ul> li>On the page that appears, your OAuth2 “client ID” and “client secret” are displayed.在出现的页面上,显示您的OAuth2“客户端ID”和“客户端密码”。Leave this page open, so that you can copy/paste values from it to the plugin configuration.使此页面保持打开状态,以便您可以将值从该页面复制/粘贴到插件配置。Alternatively, copy the values to some clipboard.或者,将值复制到某个剪贴板。 li>
Click ENABLE.
点击启用 strong>。 li>Open the Google API Console Credentials page打开 Google API控制台凭据页面 li>On the OAuth consent screen:在 OAuth同意屏幕 strong>上:For Application Name enter “Google Sheets Integration for Caldera Forms”对于应用程序名称 strong>,输入“ Caldera表单的Google表格集成” li>For Scopes for Google APIs click Add Scope, select ../auth/spreadsheets scope and click ADD对于 Google API的作用域 strong>,单击添加作用域 strong>,选择 ../ auth / spreadsheets strong>作用域,然后单击 ADD strong >> li>For Authorised domains enter domain name of your site对于授权域 strong>,输入您站点的域名 li>Click Save点击保存 strong> li> ul> li>On the Credentials screen, select Create credentials, then OAuth client ID在凭据 strong>屏幕上,选择创建凭据 strong>,然后选择 OAuth客户端ID strong>For Application type select Other 对于应用程序类型 strong>,选择其他 strong> li>For Name enter “Google Sheets Integration for Caldera Forms”对于名称 strong>,输入“ Caldera表单的Google表格集成” li>Click Create点击创建 strong> li> ul> li>On the page that appears, your OAuth2 “client ID” and “client secret” are displayed.在出现的页面上,显示您的OAuth2“客户端ID”和“客户端密码”。Leave this page open, so that you can copy/paste values from it to the plugin configuration.使此页面保持打开状态,以便您可以将值从该页面复制/粘贴到插件配置。Alternatively, copy the values to some clipboard.或者,将值复制到某个剪贴板。 li>
>
> li>
Leave this page open, so that you can copy/paste values from it to the plugin configuration.
使此页面保持打开状态,以便您可以将值从该页面复制/粘贴到插件配置。
Alternatively, copy the values to some clipboard.
或者,将值复制到某个剪贴板。
Add credentials to the plugin
向插件添加凭据 em> p>Open a new page and go to plugin Settings screen (or to Admin Panel > Caldera Forms > Google Sheets screen)打开一个新页面,然后转到插件“设置” strong>屏幕(或进入管理面板> Caldera Forms> Google表格 strong>屏幕) li>For Google OAuth2 Client ID paste “client ID” from Google OAuth2 Credentials page 对于 Google OAuth2客户端ID strong>,请从Google OAuth2凭据页面粘贴“客户端ID” li>For Google OAuth2 Secret paste “client secret” from Google OAuth2 Credentials page对于 Google OAuth2机密 strong>,请从Google OAuth2凭据页面粘贴“客户端机密” li>Click Get Code button – you will be redirected to Google Sheets authorization page点击获取代码 strong>按钮–您将被重定向到Google表格授权页面Connect to your Google account (enter credentials)连接到您的Google帐户(输入凭据) li> ul> li>You will see This app isn’t verified screen – this is OK, because you are authenticating your own site您将看到此应用未经验证 strong>屏幕-可以,因为您正在验证自己的网站Click Advanced and then click Go to Google Sheets Integration for Caldera Forms (unsafe)单击高级 strong>,然后单击转到Caldera表单的Google表格集成(不安全) strong> li> ul> li>In the Grant Google Sheets Integration for Caldera Forms permission screen click Allow在授予Google表格集成Caldera Forms权限 strong>屏幕中,点击允许 strong> li>In the Confirm your choices screen click Allow在确认选择 strong>屏幕中,点击允许 strong> li>Copy generated “access code” to the clipboard将生成的“访问代码”复制到剪贴板 li>Paste “access code” into the Google Access Code in plugin Settings screen将“访问代码”粘贴到插件“ 设置 strong>”屏幕中的 Google访问代码 strong>中 li>Click Save点击保存 strong> li> ul>Using The Plugin使用插件 h4>In Google Sheets 在Google表格中 em> p>Create a new Sheet and name it 创建一个新工作表并命名为 li>Rename the tab on which you want to capture the data重命名要在其上捕获数据的选项卡 li> ul>If you wish to record all of your Caldera Form fields, proceed to the next step and enable “Automatically generate header” option in processor settings.如果您希望记录所有的Caldera Form字段,请继续执行下一步,并在处理器设置中启用“自动生成标头”选项。 p>If you wish to record only selected fields (or for some reason automatic header generation doesn’t work for you) manually enter column names in the first row as follows:如果您只想记录选定的字段(或者由于某种原因而无法自动生成标题),请在第一行中手动输入列名,如下所示: p>Enter “id” in the the first column name在第一列名称中输入“ id” li>Enter “date” in the the second column name在第二列名称中输入“日期” li>Enter slug names of your Caldera Form fields as the following column names输入您的破火山口表单字段的子弹名称作为以下列名称 li> ul>In Caldera Forms 破火山口形式 em> p>Add Google Sheets processor to your form将Google表格处理器添加到您的表单中 li>Configure Google Sheets sheet and tab name配置Google表格的工作表和标签名 li>If you didn’t manually create spreadsheet header in the previous step, check “Automatically generate header” checkbox 如果在上一步中没有手动创建电子表格标题,请选中“自动生成标题”复选框 li>Click ‘Save Form’ to save processor settings点击“保存表格”以保存处理器设置 li>Test your form submit and verify that the data shows up in your Google Sheet测试您的表单提交并验证数据是否显示在Google表格中 li> ul>Automatic Header Generation自动标题生成 h4>When “automatic header generation” is enabled, the plugin verifies spreadsheet header on each new form submission and adds new fields to it if needed.启用“自动标题生成”后,插件会在每个新表单提交时验证电子表格标题,并在需要时向其添加新字段。Note that it never deletes fields from the header – as this would also delete some submission data – though you can do it manually.请注意,尽管您可以手动执行操作,但它永远不会从标题中删除字段,因为这也会删除一些提交数据。You may also manually reorder columns as you wish.您也可以根据需要手动对列进行重新排序。 p>It should be noted that header verification takes some time and may slow down form submission for large forms.应注意,标头验证会花费一些时间,并且可能会减慢大型表单的提交速度。Therefore consider using it only for your “test submissions” – after initial form creation and/or modification – and turning it off afterwards.因此,考虑在最初的表单创建和/或修改之后,仅将其用于“测试提交”,然后将其关闭。 p>Important Notes重要注意事项 h4>Your slug names should be in english only (use only the following ASCII characters – [A-Za-z0-9])您的子弹名称只能是英文(仅使用以下ASCII字符– [A-Za-z0-9]) li>Your slug names should be lowercase only (no capital letters)您的子弹名称只能是小写(不能使用大写字母) li>If your slug names have underscores, replace them with dashes in Google Sheet column names (e.g. for ‘name_english’ slug use ‘name-english’ column name)如果您的子句名称带有下划线,请在Google表格的列名称中用破折号代替(例如,对于“ name_english”子句使用“ name-english”列名) li> ul>Acknowledgements致谢 h4>The plugin is heavily based on CF7 Google Sheets Connector该插件很大程度上基于 CF7 Google表格连接器 p>
In Google Sheets
在Google表格中 em> p>Create a new Sheet and name it 创建一个新工作表并命名为 li>Rename the tab on which you want to capture the data重命名要在其上捕获数据的选项卡 li> ul>If you wish to record all of your Caldera Form fields, proceed to the next step and enable “Automatically generate header” option in processor settings.如果您希望记录所有的Caldera Form字段,请继续执行下一步,并在处理器设置中启用“自动生成标头”选项。 p>If you wish to record only selected fields (or for some reason automatic header generation doesn’t work for you) manually enter column names in the first row as follows:如果您只想记录选定的字段(或者由于某种原因而无法自动生成标题),请在第一行中手动输入列名,如下所示: p>Enter “id” in the the first column name在第一列名称中输入“ id” li>Enter “date” in the the second column name在第二列名称中输入“日期” li>Enter slug names of your Caldera Form fields as the following column names输入您的破火山口表单字段的子弹名称作为以下列名称 li> ul>In Caldera Forms 破火山口形式 em> p>Add Google Sheets processor to your form将Google表格处理器添加到您的表单中 li>Configure Google Sheets sheet and tab name配置Google表格的工作表和标签名 li>If you didn’t manually create spreadsheet header in the previous step, check “Automatically generate header” checkbox 如果在上一步中没有手动创建电子表格标题,请选中“自动生成标题”复选框 li>Click ‘Save Form’ to save processor settings点击“保存表格”以保存处理器设置 li>Test your form submit and verify that the data shows up in your Google Sheet测试您的表单提交并验证数据是否显示在Google表格中 li> ul>Automatic Header Generation自动标题生成 h4>When “automatic header generation” is enabled, the plugin verifies spreadsheet header on each new form submission and adds new fields to it if needed.启用“自动标题生成”后,插件会在每个新表单提交时验证电子表格标题,并在需要时向其添加新字段。Note that it never deletes fields from the header – as this would also delete some submission data – though you can do it manually.请注意,尽管您可以手动执行操作,但它永远不会从标题中删除字段,因为这也会删除一些提交数据。You may also manually reorder columns as you wish.您也可以根据需要手动对列进行重新排序。 p>It should be noted that header verification takes some time and may slow down form submission for large forms.应注意,标头验证会花费一些时间,并且可能会减慢大型表单的提交速度。Therefore consider using it only for your “test submissions” – after initial form creation and/or modification – and turning it off afterwards.因此,考虑在最初的表单创建和/或修改之后,仅将其用于“测试提交”,然后将其关闭。 p>Important Notes重要注意事项 h4>Your slug names should be in english only (use only the following ASCII characters – [A-Za-z0-9])您的子弹名称只能是英文(仅使用以下ASCII字符– [A-Za-z0-9]) li>Your slug names should be lowercase only (no capital letters)您的子弹名称只能是小写(不能使用大写字母) li>If your slug names have underscores, replace them with dashes in Google Sheet column names (e.g. for ‘name_english’ slug use ‘name-english’ column name)如果您的子句名称带有下划线,请在Google表格的列名称中用破折号代替(例如,对于“ name_english”子句使用“ name-english”列名) li> ul>Acknowledgements致谢 h4>The plugin is heavily based on CF7 Google Sheets Connector该插件很大程度上基于 CF7 Google表格连接器 p>
If you wish to record all of your Caldera Form fields, proceed to the next step and enable “Automatically generate header” option in processor settings.
如果您希望记录所有的Caldera Form字段,请继续执行下一步,并在处理器设置中启用“自动生成标头”选项。 p>
If you wish to record only selected fields (or for some reason automatic header generation doesn’t work for you) manually enter column names in the first row as follows:
如果您只想记录选定的字段(或者由于某种原因而无法自动生成标题),请在第一行中手动输入列名,如下所示: p>
In Caldera Forms
破火山口形式 em> p>Add Google Sheets processor to your form将Google表格处理器添加到您的表单中 li>Configure Google Sheets sheet and tab name配置Google表格的工作表和标签名 li>If you didn’t manually create spreadsheet header in the previous step, check “Automatically generate header” checkbox 如果在上一步中没有手动创建电子表格标题,请选中“自动生成标题”复选框 li>Click ‘Save Form’ to save processor settings点击“保存表格”以保存处理器设置 li>Test your form submit and verify that the data shows up in your Google Sheet测试您的表单提交并验证数据是否显示在Google表格中 li> ul>Automatic Header Generation自动标题生成 h4>When “automatic header generation” is enabled, the plugin verifies spreadsheet header on each new form submission and adds new fields to it if needed.启用“自动标题生成”后,插件会在每个新表单提交时验证电子表格标题,并在需要时向其添加新字段。Note that it never deletes fields from the header – as this would also delete some submission data – though you can do it manually.请注意,尽管您可以手动执行操作,但它永远不会从标题中删除字段,因为这也会删除一些提交数据。You may also manually reorder columns as you wish.您也可以根据需要手动对列进行重新排序。 p>It should be noted that header verification takes some time and may slow down form submission for large forms.应注意,标头验证会花费一些时间,并且可能会减慢大型表单的提交速度。Therefore consider using it only for your “test submissions” – after initial form creation and/or modification – and turning it off afterwards.因此,考虑在最初的表单创建和/或修改之后,仅将其用于“测试提交”,然后将其关闭。 p>Important Notes重要注意事项 h4>Your slug names should be in english only (use only the following ASCII characters – [A-Za-z0-9])您的子弹名称只能是英文(仅使用以下ASCII字符– [A-Za-z0-9]) li>Your slug names should be lowercase only (no capital letters)您的子弹名称只能是小写(不能使用大写字母) li>If your slug names have underscores, replace them with dashes in Google Sheet column names (e.g. for ‘name_english’ slug use ‘name-english’ column name)如果您的子句名称带有下划线,请在Google表格的列名称中用破折号代替(例如,对于“ name_english”子句使用“ name-english”列名) li> ul>Acknowledgements致谢 h4>The plugin is heavily based on CF7 Google Sheets Connector该插件很大程度上基于 CF7 Google表格连接器 p>
When “automatic header generation” is enabled, the plugin verifies spreadsheet header on each new form submission and adds new fields to it if needed.
启用“自动标题生成”后,插件会在每个新表单提交时验证电子表格标题,并在需要时向其添加新字段。
Note that it never deletes fields from the header – as this would also delete some submission data – though you can do it manually.
请注意,尽管您可以手动执行操作,但它永远不会从标题中删除字段,因为这也会删除一些提交数据。
You may also manually reorder columns as you wish.
您也可以根据需要手动对列进行重新排序。 p>
It should be noted that header verification takes some time and may slow down form submission for large forms.
应注意,标头验证会花费一些时间,并且可能会减慢大型表单的提交速度。
Therefore consider using it only for your “test submissions” – after initial form creation and/or modification – and turning it off afterwards.
因此,考虑在最初的表单创建和/或修改之后,仅将其用于“测试提交”,然后将其关闭。 p>
The plugin is heavily based on CF7 Google Sheets Connector
该插件很大程度上基于 CF7 Google表格连接器 p>
ol>
原文出处:http://www.sanshu.cn/a/6813.html
群主管理都是支付大佬