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.
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!
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.
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 😅😅)
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); }
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
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
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?
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.
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?
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 ?
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
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
@@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.
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.
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...!!!
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 :)
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.
Horrey Moxet! Do you know how to filter by querys in Jetengine in your showed case? (at Timestamp 04:15)
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 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! 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!
ur tutorials are always different. I love your tutorials
Thank you so much, very helpful. Please can you do this thing with CPT listing instead.
Omg. You are great bro. Really you are the best.
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?
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.
I have created a full fledged login with firebase OTP verification and used Google sheet as a database.
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
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.
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?
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 😁
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.
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
Nice 😃
How can I do the opposite? Send data from Jetformbuilder to Google Sheets?
Already made a video, check in channel
Hello , Great tutorial! can we use Microsoft Excel instead of Google Sheet?
Yes we can use it but with 365 onlinr
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?
Thanks learn something new from you. ❤
Hola, y si quiero que cada campo de la tabla de Google sheets la otra utilizar en campos en el front con Cpt
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?
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 u so much. Please make more videos👍🏻🙏
Thank you very much. Very useful tutorial 👍
¡GENIAL, MUCHAS GRACIAS POR COMPARTIR! :)
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.
Hello, is it possible that when the data is changed on the google sheet, the change is deployed on wordpress without refresh the page?
awesome * 1000000000000 !!!! very useful!!
🤩
Awesome tutorial. Thanks alot
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.
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
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..
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
Jazak Allah bro for your time :)
Thank you for this. Very useful.
Thanks for this amazing tutorial
Wow 😱 really amazing ❤
Great! Thank you!
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.
Can I manage those data from a post type?
Excellent video :)
Thanks for this tutorial
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.
Just Boom 💥
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.
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
Thanks!
How to gate date with right timezone
make sure your google and wordpress timezone are matching.
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 can I contact you for custom work?
softemblems.com
Awesome
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