Pabbly Connect integration + SpreadSimple - Addon to Hide Products
In this updated "addon" video we will be able to use a simple google Appscript function linked to our Sheet to automatically hide the products in our SpreadSimple site when a certain quantity reaches to a value threshold we set up.
It's a video that in a few minutes will show the potential behind spreadsimple and pabbly connect integration.
#spreadsimple and #pabbly-connect can really make a nice work together, and this addon proves that
🤖IMPORTANT NOTE🤖
Please check the previous video to implement this change.
In this video i will cover:
👉 Google Appscript functions
👉 Google Sheets filters
If you have any doubt please comment below, happy to reply.
Also if you liked the video please Subscribe to My channel and share it on your Facebook page.
You don't have Pabbly?? You can get it here, pricing is good enough if you need it!
https://news.digitalfastmind.com/pabbly
This is an affiliate link that will help me with a small commission, but if you don't want to buy the tool and still help me there is a good option for you!
🍺 Now that you followed the tutorial, you can buy me a beer by clicking on the link below! It helps a lot during development nights!!
http://paypal.me/digitalfastmind/
🚀FUNCTION TO USE IN GOOGLE APPSCRIPT🚀
👉START COPY BELOW
/**
TITLE: Hide a row if a value is inputted.
**/
//**GLOBALS**
// Insert here the Sheet name where you have the data.
var SHEET = "Sheet1";
// The value that will cause the row to hide, remember to use the "" if it's a text value.
var VALUE = 0;
// The column we will be using, count from the left
var COLUMN_NUMBER = 16
function onEdit(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var activeSheet = ss.getActiveSheet();
//Conditional check to make sure we're using the correct sheet.
if(SHEET == activeSheet.getName()){
var cell = ss.getActiveCell()
var cellValue = cell.getValue();
//Conditional check to ensure we are looking at the correct column.
if(cell.getColumn() == COLUMN_NUMBER){
//Finally If the cell matched the value we require,hide the row.
if(cellValue == VALUE){
activeSheet.hideRow(cell);
};
};
};
}