Linux 软件免费装
Banner图

Gravity Forms To Excel AddOn

开发者 winball
更新时间 2016年3月6日 01:12
PHP版本: 3.7 及以上
WordPress版本: 4.4.1
版权: GPLv2 or later
版权网址: 版权信息

标签

email forms notification gravityforms attachment excel excel export no CSV

下载

0.1.3 0.1.4 0.1.4.1 0.1.4.2 0.1.5.0 0.1.5.1 0.1.5.2

详情介绍:

This Gravity Forms AddOn saves form data into a given Excel document and attaches it to notification emails. You don't need any programming skills to get native Excel documents back as the result of your Gravity Forms web form. After uploading your Excel 2007 file (.xslx, other versions are not supported) the form data is saved into one sheet (which you can define) of your document. You can then select to which notification emails this Excel file should be attached to. Using simple Excel formulas (=A1) you can fill out complex Excel sheets with data from the web form. No further export or import of CSV data is required. Operating instructions
  1. Create your form with Gravity Forms
  2. Give all your fields admin field labels (under the tab "Advanced")
  3. Create your notification emails
  4. Open the GF2Excel form settings, upload your Excel file, type in your sheet number to insert the form data and finally select the notifications you would like to attach the filled in Excel file.
  5. Submit your form and open your Excel file. Connect your actual form fields through formulas (=A1) with data of the sheet which is filled by Gravity Forms. The admin field labels will help you to associate the data with the form fields.
  6. Open the WP4O-GF2Excel form settings again and upload the Excel file with your formulas.
  7. Repeat steps 5 and 6 until you are satisfied with the result.
  8. Be happy :-)
This plugin requires Gravity Forms by RocketGenius to be active. This plugin was successfully tested on WordPress Multisite without any abnormalities. This plugin is maintained by winball.de on wp4office.winball2.de. We welcome your pull requests, comments and suggestions for improvement. Additional help and example files with descriptions are available. You can try out a demo before installing. You do have problems or need individual service? If you do have problems with your Excel files please have a look at the FAQ. Professional web services are our actual business. If you need help with your form or your Excel file, please feel free to contact us.

安装:

Upload the plugin to your blog into '/wp-content/plugins/' (manually via ftp or through the dashboard) and activate it. This plugin requires Gravity Forms by RocketGenius to be active.

屏幕截图:

  • Use the admin field labels to associate the data with the form fields.
  • Upload your Excel file, type in your sheet number and select the notifications.
  • The target sheet will contain the admin field labels in column A and the form data in column B.
  • Using simple formulas (e.g. A1=...) your Excel sheet will show the data coming from the web form.

升级注意事项:

0.1.5.0
  • changed sample excel file to contain VLOOKUP in cield C7
  • fixed blank page of death after activation, when activated without having Gravity Forms active
  • fixed $form['gf2excel-addon'] not defined
0.1.4.2 Fixed some bugs:
  • fixed missing charts in output Excel file
  • fixed file not found for installation sin subdirectories
  • Added FAQ telling people restrictions of PHPExcel library (no macros, no form fields)

常见问题:

Can i use Excel templates containing macros and form fields?

No. Based on the functional range of the PHPExcel library we use in this AddOn there are some limitations regarding to the Excel files and the contents within these files.

  • We only support Excel 2007 (.xslx) (more formats on the wishlist)
  • We do not support macros (on the wishlist)
  • We do not support Excel form fields like buttons

更新日志:

0.1.5.0 0.1.4.2 0.1.4 0.1.3 0.1.2 0.1.1