Changeset 2253923
- Timestamp:
- 03/03/2020 10:33:39 PM (6 years ago)
- File:
-
- 1 edited
-
sheetdb/trunk/readme.txt (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
sheetdb/trunk/readme.txt
r2245602 r2253923 13 13 == Description == 14 14 15 The SheetDB wordpress plugin allows you to easily add content from Google Spreadsheet to your wordpress site. To add content, simply add shortcode that looks like this - `[sheetdb url= "https://sheetdb.io/api/v1/YOUR_API_ID"][/sheetdb]`. Content from within will be rendered as many times as there are rows in the spreadsheet (excluding the first row, which are column names - definition). Each time a new row is rendered, you can refer to any value using the braces notation: `{{column_name}}`15 The SheetDB wordpress plugin allows you to easily add content from Google Spreadsheet to your wordpress site. To add content, simply add shortcode that looks like this - `[sheetdb url="https://sheetdb.io/api/v1/YOUR_API_ID"][/sheetdb]`. Content from within will be rendered as many times as there are rows in the spreadsheet (excluding the first row, which are column names - definition). Each time a new row is rendered, you can refer to any value using the braces notation: `{{column_name}}` 16 16 17 17 Example spreadsheet: [Example spreadsheet document](https://docs.google.com/spreadsheets/u/3/d/1mrsgBk4IAdSs8Ask5H1z3bWYDlPTKplDIU_FzyktrGk/edit) 18 18 19 19 Example code: 20 [sheetdb url= "https://sheetdb.io/api/v1/58f61be4dda40" element="ul" limit=3 search="id=*" sort-by="id" sort-order="desc"]21 <p>{{id}} - {{name}}</p> 20 [sheetdb url="https://sheetdb.io/api/v1/58f61be4dda40" element="ul" limit=3 search="id=*" sort-by="id" sort-order="desc"] 21 {{id}} - {{name}} 22 22 [/sheetdb] 23 23 … … 25 25 * limit - The number of rows that should be returned 26 26 * offset - Row from which it should start (how many rows to skip) 27 * search - You can search for specific data in your sheet. If you want to use more than one condition join them using & symbol. Example: search= "name=Tom&age=15"27 * search - You can search for specific data in your sheet. If you want to use more than one condition join them using & symbol. Example: search="name=Tom&age=15" 28 28 * sort-by - The column you want to sort by 29 29 * sort-order - sort in `asc` or `desc` order
Note: See TracChangeset
for help on using the changeset viewer.