Hi - Do I have to call and save sheetdb on every page? Or is it possible to call sheetdb once and save it to a slot, for example at the top of the site, and then only call sheetdb-slot on all other pages? If so, is there a best practice as to where to put the first call? The home page, I'd guess... Thanks!
Hi, my project requirement is the following: Display matching data as per the user Search, Ability to update/edit the data on that Search Results and commit those to the sheet source, Append/add rows to the sheet. How can I achieve this?
Hello! crongats for the great plugin! I was able to install and fetch the data from the sheet and column I need , I am only having trouble running the offset and limit functions to narrow to data from a single cell, i add after the hook, and nothing appears on page, the spreadsheet url is /**/uQ on Sheet Rio XP and only the number "140" located in row 8 column W" associated with a service price, of Hang-Gliding-Experience. When I add this code nothing appears [sheetdb url=offset=8 limit=1]{{tour-price-person-USD}}[/sheetdb], code works fine displaying all column without variables, I am trying to use plugin to fetch only price of services for the specific tour to site , the URL of the post where to display the price is samba.tours/tour/hang-gliding-and-paragliding-rio/ Would greatly appreciate your help!!
Hi Samba! Thanks for this comment. Do not use parameters directly in the URL. Use the `sheet` attribute to select the tab, here is an example: [sheetdb url="sheetdb.io/api/v1/YOUR_API_ID" sheet="Rio%20XP" limit=1 offset=6]{{tour-price-person-USD}}[/sheetdb] The offset is 6 because we start with the second row (in the first we have column names) - so we have 6 records to skip to get to the record number 7. If you want only one row, maybe it will be easier for you to use the search method instead, for example like this: [sheetdb url="sheetdb.io/api/v1/YOUR_API_ID" sheet="Rio%20XP" search="title=Hang-Gliding-Experience" limit=1]{{tour-price-person-USD}}[/sheetdb] BTW. Do not publish your full URL with API ID, it is not recommended for security reasons and the possibility of using your quota by third parties. Hope it helps!
Hi! thanks for your video. Where I can get a syntax to additional options? How I can get only 1 row per request? of formating the titles. Thanks again
I need to have a drop-down menu that allows them to change between veg and meat. Please help!
Hi, that's video is great. It's possible make can two or multiple tabs sheet with your plugin?
Hi - Do I have to call and save sheetdb on every page? Or is it possible to call sheetdb once and save it to a slot, for example at the top of the site, and then only call sheetdb-slot on all other pages? If so, is there a best practice as to where to put the first call? The home page, I'd guess... Thanks!
Muy util!!! Really Very Useful, Question!!!: Is there a possibility to access the sheet with login and password?
Sure, you can use any spreadsheet that your Google Account has access to.
Great!
Hi, my project requirement is the following:
Display matching data as per the user Search,
Ability to update/edit the data on that Search Results and commit those to the sheet source,
Append/add rows to the sheet.
How can I achieve this?
Have you solved the user search?
Hello! crongats for the great plugin! I was able to install and fetch the data from the sheet and column I need , I am only having trouble running the offset and limit functions to narrow to data from a single cell, i add after the hook, and nothing appears on page, the spreadsheet url is /**/uQ on Sheet Rio XP and only the number "140" located in row 8 column W" associated with a service price, of Hang-Gliding-Experience. When I add this code nothing appears [sheetdb url=offset=8 limit=1]{{tour-price-person-USD}}[/sheetdb], code works fine displaying all column without variables, I am trying to use plugin to fetch only price of services for the specific tour to site , the URL of the post where to display the price is samba.tours/tour/hang-gliding-and-paragliding-rio/ Would greatly appreciate your help!!
Hi Samba! Thanks for this comment.
Do not use parameters directly in the URL. Use the `sheet` attribute to select the tab, here is an example:
[sheetdb url="sheetdb.io/api/v1/YOUR_API_ID" sheet="Rio%20XP" limit=1 offset=6]{{tour-price-person-USD}}[/sheetdb]
The offset is 6 because we start with the second row (in the first we have column names) - so we have 6 records to skip to get to the record number 7.
If you want only one row, maybe it will be easier for you to use the search method instead, for example like this:
[sheetdb url="sheetdb.io/api/v1/YOUR_API_ID" sheet="Rio%20XP" search="title=Hang-Gliding-Experience" limit=1]{{tour-price-person-USD}}[/sheetdb]
BTW. Do not publish your full URL with API ID, it is not recommended for security reasons and the possibility of using your quota by third parties.
Hope it helps!
@@sheetdb Thank you very much for the information, Working perfectly!! *****P.s I deleted the API from previous message. ;-)
@@sambatours6224 Great to hear that! Cheers 🍻