So helpful! Thank you so much, this opens up so many possibilities with Crocoblock. I had to follow you in both my accounts to not miss any new videos! You are a star. Greetings from Brazil.
00:20 Preview of a JSON script 00:49 Create a Google Sheet 01:45 Paste the code as an Extension 03:14 Find the endpoint 03:27 Connect the endpoint via REST 03:47 Add new Query for the API data 04:22 Create table or listing 05:58 Display the data on a page
Hi Moxet, thank you so much for your video. I'm still quite new to jet-engine. For several of my clients, I have a "numbers section" and I usually create an Options page with Jet Engine. But using a google sheet would be perfect! What would you recommend if I don't want a table but just a few numbers? Would it be possible to do Google Sheet -> Options -> Elementor display? (sorry if this is a stupid question 😅😅)
Hi! Thanks for your tutorial! Do you happen to know how to implement a search filter on that table that actually works? i've been trying for sometime now but i believe i have an error on the variables im setting on the filter. Thanks!
Great tutorial as always! One question: is it possible to create a form with jerformsbuilder or any other builder with REST API data, i mean populate some fields from API data and then do some calculation or get a response? Ex: I have a API with car details data: make, model, engine, price etc. I need to create a form that will populate these fields from API and then when clicked the submit to show for ex the price of a car based on selections of the fields.
Hi Moxet, thank you so much for your tutorials! I created a listing instead of a table. Is there a way to reverse the order of the listing? the first one before the googleSheet is shown as the first item of the listing, instead I would like the last line of the googleSheet to be shown as the first item of the listing
can we use this method for a dynamic chart builder. for instance, im looking for updating the values of charts from google sheets like daily or hourly updates.
Finally was able to use it in a project! Worked really well. Just a question: I tried to use JetSmartFilter to filter the REST API data, but I wasn't able to make it work. Would that be possible?
@@MoxetKhanPK Can you please share the link, I want to show records form the same sheet by search, does it show anything from any cell if we search, I think I have to use smart filter please advice.
Hello! How are you? I really enjoyed your video on this topic, which brought me a part of something I'm developing. Can you tell me if it is possible to fetch values from a spreadsheet to make calculations through a JetEngine form? I need to create a calculator on a website, but the results must be based on data from a specific spreadsheet.
Hi, I have a question that I couldn't find an answer to anywhere. In addition to MAKE or Zapier, is it possible to insert data from Google sheet into CCT / CPT? It would be a really useful feature. Would you be able to give advice on how to achieve this?
Thank you Moxet. I am using the above to manage a clients big phone list. Is there a way to have multiple tabs/sheets in a single google doc, then display each sheets on a separate page? or do I need to create a separate google doc for each sheet?
You can use 1 doc with different sheet, but either you need two .gs file or you need to optimize the code to push data to relavent end points. for example staff phone numbers has staff.gs file which push data from staff sheet to staff cct and so on. Alternatively you can have 1 gs file but with different data variable and end point but that would be a bit difficult to manage.
hi this is great tutoria; but i have question.. how to define checkbox/select/radio field from JETFORMBUILDER to not write the value on google sheet? ived tried this tutorial but using chechbox but it give me the value not the label on google sheet.. very appreciate if u can answer this thx
Thanks sir. I have questions: 1- how can I load data in a jetEngine table without refresh the page? How can we do Ajax? 2- How can I add checkboxes in a column so I can select some rows and do bulk actions ?
You can try this code function getSheetDataAsJSON() { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var range = sheet.getDataRange(); var values = range.getValues(); var headers = values[0]; var lastRow = values[values.length - 1]; // Get the last row var rowObj = {}; for (var j = 0; j < headers.length; j++) { rowObj[headers[j]] = lastRow[j]; } return JSON.stringify(rowObj); // Return only the last row as JSON } function doGet() { return ContentService.createTextOutput(getSheetDataAsJSON()) .setMimeType(ContentService.MimeType.JSON); }
Hello Abdul! Your tutorial are really helpful. Can you tell me that how we can you third part API? I've watched your other tutorial in which you used rapid API but he API I've is not Rapid API
How do we create/update CCT items from Google Sheets data? I have a Google Sheets Document with data, and I want to use the data from it to create CCT or CPT items. Is this possible?
Hi, thanks for your tutorial. My goal its create a possibility to make a product table where registred user can enter a quantity of products, and to send a request to me clicking a button. How its possible to make?
hello Moxet, I have a question that is outside the content of your video, I have many days researching and I can not find a solution, with the jetengine form plugin I will create a form that contains select type fields: city, population and neighborhood, I need that when I select a city only show the populations that correspond to them and likewise, when you select a neighborhood, show only the neighborhoods belonging to that city, can you guide me how I can achieve it.
You need to use hierarchical select, but city should have relavent population as child taxonomy. I am not sure about the structure of your site but it can be taxonomy or relationships.
@@MoxetKhanPK I use block not elementor, already tried with js with code: function getSheetDataAsJSON(page, pageSize) { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var range = sheet.getDataRange(); var values = range.getValues(); var headers = values[0]; var jsonData = []; for (var i = 1; i < values.length; i++) { var row = values[i]; var rowObj = {}; for (var j = 0; j < headers.length; j++) { rowObj[headers[j]] = row[j]; } jsonData.push(rowObj); } // Paginasi var start = (page - 1) * pageSize; var end = start + pageSize; var paginatedData = jsonData.slice(start, end); return JSON.stringify({ data: paginatedData, total: jsonData.length, page: page, pageSize: pageSize }); } function doGet(e) { // Take page and pageSize parameters from URL var page = e.parameter.page ? parseInt(e.parameter.page) : 1; var pageSize = e.parameter.pageSize ? parseInt(e.parameter.pageSize) : 20; return ContentService.createTextOutput(getSheetDataAsJSON(page, pageSize)) .setMimeType(ContentService.MimeType.JSON); } but still error, i try used widget pagination (filter) not work it
Hey, do you happen to have an idea why the dates are different? For example: in sheets, the date is 02/07/2023 and in the jet, it is displayed as 03/07/2023 (adding one day). Thanks!
How do we create/update CCT items from Google Sheets data? I have a Google Sheets Document with data, and I want to use the data from it to create CCT or CPT items. Is this possible?
U just won a subscriber man!!! 3 videos now just sawn and worked!!! Managin APIS its insane...!!!
Thank you
So helpful! Thank you so much, this opens up so many possibilities with Crocoblock. I had to follow you in both my accounts to not miss any new videos! You are a star. Greetings from Brazil.
Thank you, another Sheet to Wordpress Tutorial is coming in few days :)
00:20 Preview of a JSON script
00:49 Create a Google Sheet
01:45 Paste the code as an Extension
03:14 Find the endpoint
03:27 Connect the endpoint via REST
03:47 Add new Query for the API data
04:22 Create table or listing
05:58 Display the data on a page
Thank you, i ll add it to description
Thank you for the things you publish here. You're really helped me understand JetEngine.
Omg. You are great bro. Really you are the best.
Thank you so much, very helpful. Please can you do this thing with CPT listing instead.
Hi Moxet, thank you so much for your video. I'm still quite new to jet-engine. For several of my clients, I have a "numbers section" and I usually create an Options page with Jet Engine. But using a google sheet would be perfect! What would you recommend if I don't want a table but just a few numbers? Would it be possible to do Google Sheet -> Options -> Elementor display? (sorry if this is a stupid question 😅😅)
ur tutorials are always different. I love your tutorials
Thank you for the tutorial. Can we use jet smart filter to control the data in output table from google sheet?
Nope we can't, try to use datatables.
Hi!
Thanks for your tutorial!
Do you happen to know how to implement a search filter on that table that actually works? i've been trying for sometime now but i believe i have an error on the variables im setting on the filter.
Thanks!
Worst case scenario, use datatable, it has pagination, search and what not.
Great tutorial as always!
One question: is it possible to create a form with jerformsbuilder or any other builder with REST API data, i mean populate some fields from API data and then do some calculation or get a response?
Ex: I have a API with car details data: make, model, engine, price etc.
I need to create a form that will populate these fields from API and then when clicked the submit to show for ex the price of a car based on selections of the fields.
gracias por compartir tus conocimientos amigoo. Saludos desde Perú.
Thanks. About to play with it. What about multiple sheet tabs?
You can add gazillion sheet as fas as you maintain the code 😁
Hi Moxet, thank you so much for your tutorials! I created a listing instead of a table. Is there a way to reverse the order of the listing? the first one before the googleSheet is shown as the first item of the listing, instead I would like the last line of the googleSheet to be shown as the first item of the listing
can we use this method for a dynamic chart builder. for instance, im looking for updating the values of charts from google sheets like daily or hourly updates.
Possible, you can fetch these values to query builder than charts
thank you i know there are multiple ways to do that it just little overwhelming. Btw big fan of your content.@@MoxetKhanPK
@@endless3171 welcome 🎉
Hi, thanks for the tutorial, could you explain how to add a search or selection filter for this table using jetsmarth filter? Is it possible?
REST API is not compatible with JSF or Search, i have a video on datatable which can be used.
Could you make a tutorial or help me to show only a range of data from said table? Thank you very much and good video!
Modify the code in range section and define your own range
awesome * 1000000000000 !!!! very useful!!
🤩
Finally was able to use it in a project! Worked really well. Just a question: I tried to use JetSmartFilter to filter the REST API data, but I wasn't able to make it work. Would that be possible?
Thanks learn something new from you. ❤
Hello , Great tutorial! can we use Microsoft Excel instead of Google Sheet?
Yes we can use it but with 365 onlinr
Oh great, thanks mate, how I can add filter to search anything in this type of data
check my video about datatable in the channel
@@MoxetKhanPK Can you please share the link, I want to show records form the same sheet by search, does it show anything from any cell if we search, I think I have to use smart filter please advice.
@@bazeto ruclips.net/video/iVoWDs5S-9A/видео.htmlsi=mTtS8kcmo9CxjJ0a
Hello! How are you? I really enjoyed your video on this topic, which brought me a part of something I'm developing. Can you tell me if it is possible to fetch values from a spreadsheet to make calculations through a JetEngine form? I need to create a calculator on a website, but the results must be based on data from a specific spreadsheet.
Hi, I have a question that I couldn't find an answer to anywhere. In addition to MAKE or Zapier, is it possible to insert data from Google sheet into CCT / CPT?
It would be a really useful feature.
Would you be able to give advice on how to achieve this?
Horrey Moxet! Do you know how to filter by querys in Jetengine in your showed case? (at Timestamp 04:15)
Thank you Moxet. I am using the above to manage a clients big phone list. Is there a way to have multiple tabs/sheets in a single google doc, then display each sheets on a separate page? or do I need to create a separate google doc for each sheet?
You can use 1 doc with different sheet, but either you need two .gs file or you need to optimize the code to push data to relavent end points. for example staff phone numbers has staff.gs file which push data from staff sheet to staff cct and so on.
Alternatively you can have 1 gs file but with different data variable and end point but that would be a bit difficult to manage.
@@MoxetKhanPK thanks fro getting back to me Moxet, do you have a video on how to do this please?
Nice 😃
How can I do the opposite? Send data from Jetformbuilder to Google Sheets?
Already made a video, check in channel
¡GENIAL, MUCHAS GRACIAS POR COMPARTIR! :)
Thank u so much. Please make more videos👍🏻🙏
I have created a full fledged login with firebase OTP verification and used Google sheet as a database.
Thank you very much. Very useful tutorial 👍
Awesome tutorial. Thanks alot
Hello, is it possible that when the data is changed on the google sheet, the change is deployed on wordpress without refresh the page?
Hola, y si quiero que cada campo de la tabla de Google sheets la otra utilizar en campos en el front con Cpt
hi this is great tutoria; but i have question.. how to define checkbox/select/radio field from JETFORMBUILDER to not write the value on google sheet? ived tried this tutorial but using chechbox but it give me the value not the label on google sheet.. very appreciate if u can answer this thx
Checkboxes/select etc tend to store values not labels, if you need to store labels make sure label and value are same
@@MoxetKhanPK ahh ok thank you for the answer, your tutorial is really great..
Hi There, is it also possible to include cell formatting such as currency and color with this method?
The more you refine the code, the more better result you can get.
Wow 😱 really amazing ❤
Thank you for this. Very useful.
Thanks sir. I have questions:
1- how can I load data in a jetEngine table without refresh the page? How can we do Ajax?
2- How can I add checkboxes in a column so I can select some rows and do bulk actions ?
With custom code only.
Jazak Allah bro for your time :)
Excellent video :)
hi! how can u retrieve only 1 item, for example, the latest one and not the 3 of them?
You can try this code
function getSheetDataAsJSON() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var range = sheet.getDataRange();
var values = range.getValues();
var headers = values[0];
var lastRow = values[values.length - 1]; // Get the last row
var rowObj = {};
for (var j = 0; j < headers.length; j++) {
rowObj[headers[j]] = lastRow[j];
}
return JSON.stringify(rowObj); // Return only the last row as JSON
}
function doGet() {
return ContentService.createTextOutput(getSheetDataAsJSON())
.setMimeType(ContentService.MimeType.JSON);
}
@@MoxetKhanPK thank you!
Great! Thank you!
Hello Abdul!
Your tutorial are really helpful. Can you tell me that how we can you third part API? I've watched your other tutorial in which you used rapid API but he API I've is not Rapid API
It is more or less the same, you need to add credentials and fetch the requestes.
@@MoxetKhanPK I'm getting Forbidden error message upon Send Request
Thanks for this amazing tutorial
Can I manage those data from a post type?
How do we create/update CCT items from Google Sheets data?
I have a Google Sheets Document with data, and I want to use the data from it to create CCT or CPT items. Is this possible?
Hi, I have the same problem.
Could you solve it?
@@matiasgongorapowditch255 Hello, could you do it?
Thank you!
Hi, thanks for your tutorial. My goal its create a possibility to make a product table where registred user can enter a quantity of products, and to send a request to me clicking a button. How its possible to make?
Yes it is possible, i already have a tutorial send elementor data to google sheet. please check that.
Just Boom 💥
hello Moxet, I have a question that is outside the content of your video, I have many days researching and I can not find a solution, with the jetengine form plugin I will create a form that contains select type fields: city, population and neighborhood, I need that when I select a city only show the populations that correspond to them and likewise, when you select a neighborhood, show only the neighborhoods belonging to that city, can you guide me how I can achieve it.
You need to use hierarchical select, but city should have relavent population as child taxonomy.
I am not sure about the structure of your site but it can be taxonomy or relationships.
What do I do if there are multiple sheets in the data?
you want to link it with 1 page or different?
is it possible to create charts with the same method?
Yes possible.
Thanks for this tutorial
How to put a "delete" button to delete a row?🤔
You need to use hook which transmit the data to Google Sheet with a CCT ID & then delete it, but for sure you need Google Sheet API integrated.
Thanks for the feedback...
Could you create a video explaining how to do it?@@MoxetKhanPK
how to display the table only 20 list per page...?
you can use datatable, which enable pagination and tons of option, there is video in my channel.
@@MoxetKhanPK I use block not elementor, already tried with js with code:
function getSheetDataAsJSON(page, pageSize) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var range = sheet.getDataRange();
var values = range.getValues();
var headers = values[0];
var jsonData = [];
for (var i = 1; i < values.length; i++) {
var row = values[i];
var rowObj = {};
for (var j = 0; j < headers.length; j++) {
rowObj[headers[j]] = row[j];
}
jsonData.push(rowObj);
}
// Paginasi
var start = (page - 1) * pageSize;
var end = start + pageSize;
var paginatedData = jsonData.slice(start, end);
return JSON.stringify({
data: paginatedData,
total: jsonData.length,
page: page,
pageSize: pageSize
});
}
function doGet(e) {
// Take page and pageSize parameters from URL
var page = e.parameter.page ? parseInt(e.parameter.page) : 1;
var pageSize = e.parameter.pageSize ? parseInt(e.parameter.pageSize) : 20;
return ContentService.createTextOutput(getSheetDataAsJSON(page, pageSize))
.setMimeType(ContentService.MimeType.JSON);
}
but still error, i try used widget pagination (filter) not work it
@@MoxetKhanPK work with builder block...?
@@yupi9448 anything, it has few lines of code
@@MoxetKhanPK can share link video tutor?
Awesome
How to gate date with right timezone
make sure your google and wordpress timezone are matching.
Hey, do you happen to have an idea why the dates are different? For example: in sheets, the date is 02/07/2023 and in the jet, it is displayed as 03/07/2023 (adding one day). Thanks!
Im not sure i ll check it but try to set google sheet timezone to yours as well.
Due to Time zone
How can I contact you for custom work?
softemblems.com
Thanks!
Can this also be done with multiple sheets within one Google spreadsheet?
Yes you can work with multiple sheet, different code.
Can you please write the code for this? I cant figure it out :(
@@PELLO987654321 paid tasks on my fiverr account
@@MoxetKhanPK okay, whats your username?
How do we create/update CCT items from Google Sheets data?
I have a Google Sheets Document with data, and I want to use the data from it to create CCT or CPT items. Is this possible?
Tutorial coming soon.
@@MoxetKhanPK Thanks friend, we look forward to that tutorial. Greetings from Peru