{"id":141,"date":"2022-09-14T09:07:37","date_gmt":"2022-09-14T09:07:37","guid":{"rendered":"https:\/\/jassweb.com\/new22\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet\/"},"modified":"2022-09-14T09:07:37","modified_gmt":"2022-09-14T09:07:37","slug":"solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/","title":{"rendered":"[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet?"},"content":{"rendered":"<h2> Introduction <\/h2>\n<p>[ad_1]<\/p>\n<p>Creating a custom UI button with a growing Google Sheet can be a great way to automate certain tasks and make your workflow more efficient. However, it can be difficult to know how to properly call a function with such a button. In this article, we will discuss the steps necessary to properly call a function with a custom UI button with a growing Google Sheet. We will also discuss some best practices to ensure that your button works as intended. By the end of this article, you should have a better understanding of how to properly call a function with a custom UI button with a growing Google Sheet.<\/p>\n<h2> Solution<\/h2>\n<p><\/p>\n<p>1. Create a custom UI button in the Google Sheet.<br \/>\n2. Add an onclick event listener to the button.<br \/>\n3. Inside the onclick event listener, call the function you want to execute.<br \/>\n4. Make sure the function is defined in the same script as the onclick event listener.<br \/>\n5. If the Google Sheet is growing, you may need to add a trigger to the function so that it runs when the sheet is updated. To do this, go to the script editor and select &#8220;Resources&#8221; > &#8220;Current project&#8217;s triggers&#8221;. Then, select the function you want to run and set the trigger to run when the sheet is updated. <\/p>\n<p><\/p>\n<div class=\"entry-content\" itemprop=\"text\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1088640234840270\" crossorigin=\"anonymous\"><\/script><br \/>\n<script><\/p>\n<p><\/script><\/p>\n<p><\/p>\n<div id=\"answer-69200323\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"69200323\" data-parentid=\"69197916\" data-score=\"1\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>The <strong>onOpen<\/strong> trigger in your script is only for adding the Custom Menu in your Sheet. The function will only get executed when the user selected an Item in the menu that is associated with the function. In your example, clicking <code>Get place info<\/code> will execute the <code>COMBINED2<\/code> function.<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-How-can-I-properly-call-a-function-with-a.png\"><img decoding=\"async\" src=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-How-can-I-properly-call-a-function-with-a.png\" alt=\"enter image description here\"><\/a><\/p>\n<p>Also, executing the script only when the place information is not present in the sheet is not possible, you have to run the script to get the identifier of the place and compare it to the data in the Sheet. In your example, place.url can be used as identifier. The only thing you can do is to prevent the script from populating the Sheet.<\/p>\n<p>Here I updated your script by changing the function associated to the <code>Get place info<\/code> to <code>writeToSheet()<\/code>. <code>writeToSheet()<\/code> will call <code>COMBINED2(text)<\/code> to get the place information and use <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/developers.google.com\/apps-script\/reference\/spreadsheet\/text-finder\">TextFinder<\/a> to check if the place url exists in the Sheet. If the result of TextFinder is 0, it will populate the Sheet.<\/p>\n<pre><code>\/\/ const LOC_BASIS_LAT_LON = \"40.74516247433546, -73.98621366765811\"; \/\/ e.g. \"37.7644856,-122.4472203\"\nconst LOC_BASIS_LAT_LON = \"37.7644856,-122.4472203\";\n\nfunction COMBINED2(text) {\n  var API_KEY = 'enter api key here';\n  var baseUrl=\"https:\/\/maps.googleapis.com\/maps\/api\/place\/findplacefromtext\/json\";\n  var queryUrl = baseUrl + '?input=\" + text + \"&amp;inputtype=textquery&amp;key=' + API_KEY + \"&amp;locationbias=point:\" + LOC_BASIS_LAT_LON;\n  var response = UrlFetchApp.fetch(queryUrl);\n  var json = response.getContentText();\n  var placeId = JSON.parse(json);\n  var ID = placeId.candidates[0].place_id;\n  var fields=\"name,formatted_address,formatted_phone_number,website,url,types,opening_hours\";\n  var baseUrl2 = 'https:\/\/maps.googleapis.com\/maps\/api\/place\/details\/json?placeid=';\n  var queryUrl2 = baseUrl2 + ID + '&amp;fields=\" + fields + \"&amp;key='+ API_KEY + \"&amp;locationbias=point:\" + LOC_BASIS_LAT_LON;\n\n  if (ID == '') {\n    return 'Give me a Google Places URL...';\n  }\n\n  var response2 = UrlFetchApp.fetch(queryUrl2);\n  var json2 = response2.getContentText();\n  var place = JSON.parse(json2).result;\n\n  var weekdays=\"\";\n  place.opening_hours.weekday_text.forEach((weekdayText) =&gt; {\n    weekdays += ( weekdayText + '\\r\\n' );\n  } );\n\n  var data = [\n    place.name,\n    place.formatted_address,\n    place.formatted_phone_number,\n    place.website,\n    place.url,\n    weekdays.trim()\n  ];\n\n  return data;\n}\n\nfunction getColumnLastRow(range){\n  var ss = SpreadsheetApp.getActiveSheet();\n  var inputs = ss.getRange(range).getValues();\n  return inputs.filter(String).length;\n}\n\nfunction writeToSheet(){\n  var ss = SpreadsheetApp.getActiveSheet();\n  var lastRow = getColumnLastRow(\"A1:A\");\n  var text = ss.getRange(\"A\"+lastRow).getValue();\n  var data = COMBINED2(text);\n  var placeCid = data[4];\n  var findText = ss.createTextFinder(placeCid).findAll();\n  if(findText.length == 0){\n    ss.getRange(lastRow,2,1, data.length).setValues([data])\n  }\n}\n\nfunction onOpen() {\n  const ui = SpreadsheetApp.getUi();  \n  ui.createMenu(\"Custom Menu\")\n      .addItem(\"Get place info\",\"writeToSheet\")\n      .addToUi();\n}\n<\/code><\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p>Example 1:<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/1663146457_432_Solved-How-can-I-properly-call-a-function-with-a.png\"><img decoding=\"async\" src=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/1663146457_432_Solved-How-can-I-properly-call-a-function-with-a.png\" alt=\"enter image description here\"><\/a><\/p>\n<p>After clicking custom menu:<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/1663146457_86_Solved-How-can-I-properly-call-a-function-with-a.png\"><img decoding=\"async\" src=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/1663146457_86_Solved-How-can-I-properly-call-a-function-with-a.png\" alt=\"enter image description here\"><\/a><\/p>\n<p>Example 2:<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/1663146457_909_Solved-How-can-I-properly-call-a-function-with-a.png\"><img decoding=\"async\" src=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/1663146457_909_Solved-How-can-I-properly-call-a-function-with-a.png\" alt=\"enter image description here\"><\/a><\/p>\n<p>After clicking custom menu:<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/1663146457_94_Solved-How-can-I-properly-call-a-function-with-a.png\"><img decoding=\"async\" src=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/1663146457_94_Solved-How-can-I-properly-call-a-function-with-a.png\" alt=\"enter image description here\"><\/a><\/p>\n<p><em>Note: Since we are using lastRow, new entry must be inserted below the last row of column A. Otherwise it will overwrite the last entry.<\/em><\/p>\n<h2>Reference:<\/h2>\n<ul>\n<li><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/developers.google.com\/apps-script\/guides\/menus\">Custom Menu<\/a><\/li>\n<li><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/developers.google.com\/maps\/documentation\/places\/web-service\/details\">Place Details<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p> <span class=\"d-none\" itemprop=\"commentCount\">6<\/span> <\/p>\n<\/div>\n<\/div>\n<p>solved How can I properly call a function with a custom UI button with a growing Google Sheet? <\/p>\n<p><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1088640234840270\" crossorigin=\"anonymous\"><\/script><br \/>\n<script><\/p>\n<p><\/script><\/div>\n<p>[ad_2]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction [ad_1] Creating a custom UI button with a growing Google Sheet can be a great way to automate certain tasks and make your workflow more efficient. However, it can be difficult to know how to properly call a function with such a button. In this article, we will discuss the steps necessary to properly &#8230; <a title=\"[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet?\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/\" aria-label=\"More on [Solved] How can I properly call a function with a custom UI button with a growing Google Sheet?\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[951,2441,1955],"class_list":["post-141","post","type-post","status-publish","format-standard","hentry","category-solved","tag-google-apps-script","tag-google-places-api","tag-google-sheets"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet? - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet? - JassWeb\" \/>\n<meta property=\"og:description\" content=\"Introduction [ad_1] Creating a custom UI button with a growing Google Sheet can be a great way to automate certain tasks and make your workflow more efficient. However, it can be difficult to know how to properly call a function with such a button. In this article, we will discuss the steps necessary to properly ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-14T09:07:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-How-can-I-properly-call-a-function-with-a.png\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet?\",\"datePublished\":\"2022-09-14T09:07:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/\"},\"wordCount\":448,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-How-can-I-properly-call-a-function-with-a.png\",\"keywords\":[\"google-apps-script\",\"google-places-api\",\"google-sheets\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/\",\"name\":\"[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet? - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-How-can-I-properly-call-a-function-with-a.png\",\"datePublished\":\"2022-09-14T09:07:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#primaryimage\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-How-can-I-properly-call-a-function-with-a.png\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-How-can-I-properly-call-a-function-with-a.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet? - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet? - JassWeb","og_description":"Introduction [ad_1] Creating a custom UI button with a growing Google Sheet can be a great way to automate certain tasks and make your workflow more efficient. However, it can be difficult to know how to properly call a function with such a button. In this article, we will discuss the steps necessary to properly ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/","og_site_name":"JassWeb","article_published_time":"2022-09-14T09:07:37+00:00","og_image":[{"url":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-How-can-I-properly-call-a-function-with-a.png","type":"","width":"","height":""}],"author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet?","datePublished":"2022-09-14T09:07:37+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/"},"wordCount":448,"commentCount":0,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"image":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#primaryimage"},"thumbnailUrl":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-How-can-I-properly-call-a-function-with-a.png","keywords":["google-apps-script","google-places-api","google-sheets"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/","url":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/","name":"[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet? - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"primaryImageOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#primaryimage"},"image":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#primaryimage"},"thumbnailUrl":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-How-can-I-properly-call-a-function-with-a.png","datePublished":"2022-09-14T09:07:37+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#primaryimage","url":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-How-can-I-properly-call-a-function-with-a.png","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/uploads\/2022\/09\/Solved-How-can-I-properly-call-a-function-with-a.png"},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-how-can-i-properly-call-a-function-with-a-custom-ui-button-with-a-growing-google-sheet-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] How can I properly call a function with a custom UI button with a growing Google Sheet?"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/141","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=141"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/141\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}