Hello. Could you tell me whether it is possible to periodically import Google Sheets or xlsx files from the cloud version of Excel, and have them saved in a folder? I would create the folder by logging into my Wordpress account with CyberDuck FTP, then enter that sheet's URL into another plugin that I want to use the spreadsheet with. Many thanks. Sarah
Hi, you can use the search feature to find the row you need, then use the column name in the double curly braces. docs.sheetdb.io/#get-search-in-document
@@sheetdb Hello Again, I don't understand how to write a code could you please help me, if I want to search "row 3" and use the column name "Total" what code I need to write? please show me an example I tried to create code my own but It's doesn't work, help me, please
@@ekza21 No problem! Here's what it should look like while using the WordPress plugin: [sheetdb url=“sheetdb.io/api/v1/YOUR_API_ID" offset="2" limit="1"] {{Total}} [/sheetdb]
@@sheetdb Thank you, however how can you use the search-in-document function only using a shortcode? Or do you have to create a custom plugin in WP in PHP in order to use this function?
I don't remember exactly, but something like this should help: width: 4rem; height: 4rem; object-fit: cover; border-radius: 1rem; You have to add this to the style file, in this case to the .pizza-menu class
@@sheetdb thanks, i manage to do it with offset and limit and added some column. I have another question, how to filter it to particular data or category from total data?
@@dirkwangke9476 you can use the search attribute More info here: wordpress.org/plugins/sheetdb/ docs.sheetdb.io/#get-search-in-document ruclips.net/video/hQmmhVxG0UI/видео.html
Great tool! Would you mind sharing your CSS to get me going?
Such an extremly great video
How did you add css to it
Hello. Could you tell me whether it is possible to periodically import Google Sheets or xlsx files from the cloud version of Excel, and have them saved in a folder? I would create the folder by logging into my Wordpress account with CyberDuck FTP, then enter that sheet's URL into another plugin that I want to use the spreadsheet with.
Many thanks.
Sarah
amazing tool, gonna use it
Hi, I need some help what If I need to display only one cell, how can I do that?
Hi, you can use the search feature to find the row you need, then use the column name in the double curly braces.
docs.sheetdb.io/#get-search-in-document
@@sheetdb Thank you for your guidance.
@@sheetdb Hello Again, I don't understand how to write a code could you please help me, if I want to search "row 3" and use the column name "Total" what code I need to write? please show me an example I tried to create code my own but It's doesn't work, help me, please
@@ekza21 No problem! Here's what it should look like while using the WordPress plugin:
[sheetdb url=“sheetdb.io/api/v1/YOUR_API_ID" offset="2" limit="1"]
{{Total}}
[/sheetdb]
@@sheetdb Thank you, however how can you use the search-in-document function only using a shortcode? Or do you have to create a custom plugin in WP in PHP in order to use this function?
how to make result in grid view?
help please
I don't remember exactly, but something like this should help:
width: 4rem;
height: 4rem;
object-fit: cover;
border-radius: 1rem;
You have to add this to the style file, in this case to the .pizza-menu class
@@sheetdb thanks, i manage to do it with offset and limit and added some column.
I have another question, how to filter it to particular data or category from total data?
@@dirkwangke9476 you can use the search attribute
More info here: wordpress.org/plugins/sheetdb/
docs.sheetdb.io/#get-search-in-document
ruclips.net/video/hQmmhVxG0UI/видео.html