Find answers, ask questions, and connect with other creators.<\/p>", "imageupload.max_uploaded_images_per_upload" : 100, "imageupload.max_uploaded_images_per_user" : 10000, "integratedprofile.connect_mode" : "", "tkb.toc_maximum_heading_level" : "2", "tkb.toc_heading_list_style" : "disc", "sharedprofile.show_hovercard_score" : true, "config.search_before_post_scope" : "community", "tkb.toc_heading_indent" : "15", "p13n.cta.recommendations_feed_dismissal_timestamp" : -1, "imageupload.max_file_size" : 10024, "layout.show_batch_checkboxes" : false, "integratedprofile.cta_connect_slim_dismissal_timestamp" : -1 }, "isAnonymous" : true, "policies" : { "image-upload.process-and-remove-exif-metadata" : true }, "registered" : false, "emailRef" : "", "id" : -1, "login" : "Former Community Member" }, "Server" : { "communityPrefix" : "/qsqph94282", "nodeChangeTimeStamp" : 1732570519003, "tapestryPrefix" : "/gc", "deviceMode" : "DESKTOP", "responsiveDeviceMode" : "DESKTOP", "membershipChangeTimeStamp" : "0", "version" : "24.7", "branch" : "24.7-release", "showTextKeys" : false }, "Config" : { "phase" : "prod", "integratedprofile.cta.reprompt.delay" : 30, "profileplus.tracking" : { "profileplus.tracking.enable" : false, "profileplus.tracking.click.enable" : false, "profileplus.tracking.impression.enable" : false }, "app.revision" : "2409051714-s8dac8f1df8-b80", "navigation.manager.community.structure.limit" : "1000" }, "Activity" : { "Results" : [ ] }, "NodeContainer" : { "viewHref" : "https://www.googlecloudcommunity.com/gc/AppSheet/ct-p/appsheet", "description" : "Find answers, ask questions, and connect with other creators.", "id" : "appsheet", "shortTitle" : "AppSheet", "title" : "AppSheet", "nodeType" : "category" }, "Page" : { "skins" : [ "googlecloud", "theme_hermes", "responsive_peak" ], "authUrls" : { "loginUrl" : "https://www.googlecloudcommunity.com/gc/user/userloginpage?dest_url=https%3A%2F%2Fwww.googlecloudcommunity.com%2Fgc%2FAppSheet%2Fct-p%2Fappsheet", "loginUrlNotRegistered" : "https://www.googlecloudcommunity.com/gc/user/userloginpage?redirectreason=notregistered&dest_url=https%3A%2F%2Fwww.googlecloudcommunity.com%2Fgc%2FAppSheet%2Fct-p%2Fappsheet", "loginUrlNotRegisteredDestTpl" : "https://www.googlecloudcommunity.com/gc/user/userloginpage?redirectreason=notregistered&dest_url=%7B%7BdestUrl%7D%7D" }, "name" : "CategoryPage", "rtl" : false, "object" : { "viewHref" : "/gc/AppSheet/ct-p/appsheet", "id" : "appsheet", "page" : "CategoryPage", "type" : "Category" } }, "WebTracking" : { "Activities" : { }, "path" : "Community:Google Cloud Community/Category:AppSheet" }, "Feedback" : { "targeted" : { } }, "Seo" : { "markerEscaping" : { "pathElement" : { "prefix" : "@", "match" : "^[0-9][0-9]$" }, "enabled" : false } }, "TopLevelNode" : { "viewHref" : "https://www.googlecloudcommunity.com/gc/AppSheet/ct-p/appsheet", "description" : "Find answers, ask questions, and connect with other creators.", "id" : "appsheet", "shortTitle" : "AppSheet", "title" : "AppSheet", "nodeType" : "category" }, "Community" : { "viewHref" : "https://www.googlecloudcommunity.com/", "integratedprofile.lang_code" : "en", "integratedprofile.country_code" : "US", "id" : "qsqph94282", "shortTitle" : "Google Cloud Community", "title" : "Google Cloud Community" }, "CoreNode" : { "viewHref" : "https://www.googlecloudcommunity.com/gc/AppSheet/ct-p/appsheet", "settings" : { }, "description" : "Find answers, ask questions, and connect with other creators.", "id" : "appsheet", "shortTitle" : "AppSheet", "title" : "AppSheet", "nodeType" : "category", "ancestors" : [ { "viewHref" : "https://www.googlecloudcommunity.com/", "description" : "The official home of Google Cloud and Workspace community forums, learning hub, and community blogs.", "id" : "qsqph94282", "shortTitle" : "Google Cloud Community", "title" : "Google Cloud Community", "nodeType" : "Community" } ] } }; LITHIUM.Components.RENDER_URL = "/gc/util/componentrenderpage/component-id/#{component-id}?render_behavior=raw"; LITHIUM.Components.ORIGINAL_PAGE_NAME = 'community/CategoryPage'; LITHIUM.Components.ORIGINAL_PAGE_ID = 'CategoryPage'; LITHIUM.Components.ORIGINAL_PAGE_CONTEXT = 'PqtkcQZt83CkBwUUh06tgJ1WJ92GXJTPvOvymnVE9JRefnxzqmyElGADrX5eG6foJtvT3Rt6-EUNRTLWLGtVrKrt3KKxm37SbBua2qfaWYsQuRILRHApOB9p6YBDLdP_u0d2JAJ4dtX_lfv2CAXs9OskS63vOr7Q-mglBQnx_qz9_uk9YlhtUIyPOGnLSG2pdNXaHH3rmy4asqXaTXemGrXQzyiVjBckqLHsYby3zSdmNMBpIOw5fxRDou8LiIuggGNXTYUMvcTvpyhWvON3Sa1MggrfTq2v_DbCZ4xR8V4xkD5qkus1fl7loBtVtyYK216CSvODVcdZkjvIDctQDQ..'; LITHIUM.Css = { "BASE_DEFERRED_IMAGE" : "lia-deferred-image", "BASE_BUTTON" : "lia-button", "BASE_SPOILER_CONTAINER" : "lia-spoiler-container", "BASE_TABS_INACTIVE" : "lia-tabs-inactive", "BASE_TABS_ACTIVE" : "lia-tabs-active", "BASE_AJAX_REMOVE_HIGHLIGHT" : "lia-ajax-remove-highlight", "BASE_FEEDBACK_SCROLL_TO" : "lia-feedback-scroll-to", "BASE_FORM_FIELD_VALIDATING" : "lia-form-field-validating", "BASE_FORM_ERROR_TEXT" : "lia-form-error-text", "BASE_FEEDBACK_INLINE_ALERT" : "lia-panel-feedback-inline-alert", "BASE_BUTTON_OVERLAY" : "lia-button-overlay", "BASE_TABS_STANDARD" : "lia-tabs-standard", "BASE_AJAX_INDETERMINATE_LOADER_BAR" : "lia-ajax-indeterminate-loader-bar", "BASE_AJAX_SUCCESS_HIGHLIGHT" : "lia-ajax-success-highlight", "BASE_CONTENT" : "lia-content", "BASE_JS_HIDDEN" : "lia-js-hidden", "BASE_AJAX_LOADER_CONTENT_OVERLAY" : "lia-ajax-loader-content-overlay", "BASE_FORM_FIELD_SUCCESS" : "lia-form-field-success", "BASE_FORM_WARNING_TEXT" : "lia-form-warning-text", "BASE_FORM_FIELDSET_CONTENT_WRAPPER" : "lia-form-fieldset-content-wrapper", "BASE_AJAX_LOADER_OVERLAY_TYPE" : "lia-ajax-overlay-loader", "BASE_FORM_FIELD_ERROR" : "lia-form-field-error", "BASE_SPOILER_CONTENT" : "lia-spoiler-content", "BASE_FORM_SUBMITTING" : "lia-form-submitting", "BASE_EFFECT_HIGHLIGHT_START" : "lia-effect-highlight-start", "BASE_FORM_FIELD_ERROR_NO_FOCUS" : "lia-form-field-error-no-focus", "BASE_EFFECT_HIGHLIGHT_END" : "lia-effect-highlight-end", "BASE_SPOILER_LINK" : "lia-spoiler-link", "BASE_DISABLED" : "lia-link-disabled", "FACEBOOK_LOGOUT" : "lia-component-users-action-logout", "FACEBOOK_SWITCH_USER" : "lia-component-admin-action-switch-user", "BASE_FORM_FIELD_WARNING" : "lia-form-field-warning", "BASE_AJAX_LOADER_FEEDBACK" : "lia-ajax-loader-feedback", "BASE_AJAX_LOADER_OVERLAY" : "lia-ajax-loader-overlay", "BASE_LAZY_LOAD" : "lia-lazy-load" }; LITHIUM.noConflict = true; LITHIUM.useCheckOnline = false; LITHIUM.RenderedScripts = [ "Sandbox.js", "Auth.js", "jquery.function-utils-1.0.js", "Loader.js", "jquery.appear-1.1.1.js", "NoConflict.js", "jquery.ui.resizable.js", "Throttle.js", "ActiveCast3.js", "jquery.placeholder-2.0.7.js", "prism.js", "jquery.ui.draggable.js", "jquery.ui.widget.js", "jquery.iframe-transport.js", "jquery.viewport-1.0.js", "Events.js", "jquery.ui.core.js", "jquery.fileupload.js", "jquery.delayToggle-1.0.js", "OoyalaPlayer.js", "Globals.js", "jquery.blockui.js", "PartialRenderProxy.js", "SearchAutoCompleteToggle.js", "jquery.lithium-selector-extensions.js", "LiModernizr.js", "ForceLithiumJQuery.js", "Video.js", "AjaxSupport.js", "jquery.scrollTo.js", "InformationBox.js", "UserListActual.js", "jquery.tools.tooltip-1.2.6.js", "jquery.ui.position.js", "ElementMethods.js", "jquery.autocomplete.js", "json2.js", "DeferredImages.js", "Placeholder.js", "jquery.iframe-shim-1.0.js", "Tooltip.js", "Text.js", "ElementQueries.js", "DataHandler.js", "jquery.js", "Forms.js", "Namespace.js", "SearchForm.js", "AjaxFeedback.js", "jquery.effects.core.js", "jquery.ui.mouse.js", "Link.js", "jquery.clone-position-1.0.js", "Lithium.js", "jquery.effects.slide.js", "Cache.js", "Dialog.js", "ResizeSensor.js", "jquery.ui.dialog.js", "CookieBannerAlert.js", "PolyfillsAll.js", "jquery.ajax-cache-response-1.0.js", "AutoComplete.js", "HelpIcon.js", "Components.js", "jquery.css-data-1.0.js", "jquery.hoverIntent-r6.js", "jquery.json-2.6.0.js", "jquery.tmpl-1.1.1.js", "jquery.position-toggle-1.0.js", "SpoilerToggle.js" ];(function(){LITHIUM.AngularSupport=function(){function g(a,c){a=a||{};for(var b in c)"[object object]"===Object.prototype.toString.call(c[b])?a[b]=g(a[b],c[b]):a[b]=c[b];return a}var d,f,b={coreModule:"li.community",coreModuleDeps:[],noConflict:!0,bootstrapElementSelector:".lia-page .min-width .lia-content",bootstrapApp:!0,debugEnabled:!1,useCsp:!0,useNg2:!1},k=function(){var a;return function(b){a||(a=document.createElement("a"));a.href=b;return a.href}}();LITHIUM.Angular={};return{preventGlobals:LITHIUM.Globals.preventGlobals, restoreGlobals:LITHIUM.Globals.restoreGlobals,init:function(){var a=[],c=document.querySelector(b.bootstrapElementSelector);a.push(b.coreModule);b.customerModules&&0

Welcome to the

AppSheet Creators Community

Find answers, ask questions, and connect with other creators.

cancel
Showing results for 
Search instead for 
Did you mean: 
'; res += '
'; res += '
'; res += '
'; res += '
'; if (jsonObj.urls.length > 0) { for (var i = 0; i < jsonObj.urls.length; i++) { var data = jsonObj.urls[i]; res += '
'; res += '
'; } } else{ res += '
'; res += '
'; res += '
'; res += '
'; res += '
'; res += '
'; } res += '
'; document.querySelector('.dynamic-data').innerHTML = res; document.querySelector('#description').value= decodeURIComponent(decodeURIComponent(jsonObj.description).replace("\n","\r\n").replace("\\n","\r\n")); document.querySelector('#list-boards').value=decodeURIComponent(decodeURIComponent(jsonObj.boards).replace("\n","\r\n").replace("\\n","\r\n")); var getDateTimeInJson = decodeURIComponent(decodeURIComponent(jsonObj.dateValue).replace("\n","\r\n").replace("\\n","\r\n")); if ("" == "") { var dateFormats = moment(new Date(getDateTimeInJson)).tz(moment.tz.guess()).format("YYYY-MM-DDThh:mm"); }else{ var getTimeZoneInJson = getDateTimeInJson.split("_")[1]; var getDateWithOutZone = getDateTimeInJson.split("_")[0]; if (getTimeZoneInJson == ""){ var dateFormats = moment(new Date(getDateWithOutZone)).tz(moment.tz.guess()).format("YYYY-MM-DDThh:mm"); }else{ var newDate = new Date(getDateWithOutZone); var dateTimeChangeWithZone = newDate.toLocaleString("en-US", {timeZone: ""}); var dateFormats = moment(new Date(dateTimeChangeWithZone)).tz(moment.tz.guess()).format("YYYY-MM-DDThh:mm"); } } document.querySelector('#edit-date').value = dateFormats; document.querySelector("#myModal").style.display = 'block'; } function submitData() { let boardData = encodeURIComponent(encodeURIComponent(document.querySelector("#list-boards").value)); let getDateValue = encodeURIComponent(encodeURIComponent(document.querySelector('#edit-date').value)); if ("" == "") { var dateValues = getDateValue; }else{ var dateValues = getDateValue +"_"+(""); } let titleVal = encodeURIComponent(encodeURIComponent(document.querySelector("#title").value)); let descriptionData = encodeURIComponent(encodeURIComponent(document.querySelector("#description").value)); let title1 = encodeURIComponent(encodeURIComponent(document.querySelector("#url-title0").value)); let url1 = encodeURIComponent(encodeURIComponent(document.querySelector("#href0").value)); if (titleVal === "") { document.querySelector('#title').style.border = "1px solid red"; alert("title is required"); return false; } if ( title1 !== "" && url1 === "") { document.querySelector('#href0').style.border = "1px solid red"; alert("Pease enter URL for url 1"); return false; } if ( title1 === "" && url1 !== "") { document.querySelector('#url-title0').style.border = "1px solid red"; alert("Pease enter URL for title 1"); return false; } let urlString1 = title1.concat("||",url1); var tarObj = { title:titleVal, description:descriptionData, boards:boardData, dateValue:dateValues, bgurl:encodeURIComponent(document.querySelector("#bg-url").value), urls:[urlString1] } var xhr = new XMLHttpRequest(); if ('category' == 'board'){ xhr.open("POST", "/restapi/vc/boards/id/appsheet/settings/name/" + keyToSave + "/set?value=" + JSON.stringify(tarObj));} else{ xhr.open("POST", "/restapi/vc/categories/id/appsheet/settings/name/" + keyToSave + "/set?value=" + JSON.stringify(tarObj)); } xhr.setRequestHeader("Accept", "application/json"); xhr.setRequestHeader("Content-Type", "application/json"); xhr.onreadystatechange = function () { if (xhr.readyState === 4) { if (xhr.status === 200) { alert("Announcement details are saved successfully"); window.location.reload(); } else { alert("an error occured while saving the data. Please try after later"); return false; } keyToSave = ""; }}; xhr.send({}); } function closeModal() { document.querySelector("#myModal").style.display = 'none'; } function populateData() { var keyDetails = "c_category_announcement_tile1,c_category_announcement_tile2,c_category_announcement_tile3"; var keyList = keyDetails.split(","), displayCont = ""; var resCon = loopContent[0]; for (var i = 0; i< keyList.length; i++) { if (resCon.hasOwnProperty(keyList[i])){ var content = JSON.parse(resCon[keyList[i]]); if (content.title !== "" || "false" === "true") { var contentUrl = decodeURIComponent(content.bgurl); if(contentUrl == ""){ displayCont += `
`; }else{ displayCont += `
`; } if ("false" === "true") { displayCont += `` } var dateString = decodeURIComponent(decodeURIComponent(content.dateValue)); var getTimeZone = dateString.split("_")[1]; var getDateTime = dateString.split("_")[0]; if ("" == "") { if(getDateTime ==""){ var dateWithTimeZone =""; }else{ var defaultTimeZone = "US/Pacific"; if(getTimeZone == defaultTimeZone){ var dateFormat = moment(new Date(getDateTime)).tz(moment.tz.guess()).format("MMMM D, YYYY | h:mm A"); var dateWithTimeZone = dateFormat+" "+defaultTimeZone; }else{ var localeDate = new Date(getDateTime); var changeDateTimeWithZone = localeDate.toLocaleString("en-US", {timeZone: defaultTimeZone}); var dateFormat = moment(new Date(changeDateTimeWithZone)).tz(moment.tz.guess()).format("MMMM D, YYYY | h:mm A"); var dateWithTimeZone = dateFormat+" "+defaultTimeZone; } } }else{ if (getTimeZone == "") { if(getDateTime ==""){ var dateWithTimeZone =""; }else{ var dateFormat = moment(new Date(getDateTime)).tz(moment.tz.guess()).format("MMMM D, YYYY | h:mm A"); var dateWithTimeZone = dateFormat +" "+ (""); } }else{ if(getDateTime ==""){ var dateWithTimeZone =""; }else{ var localeDate = new Date(getDateTime); var changeDateTimeWithZone = localeDate.toLocaleString("en-US", {timeZone: ""}); var dateFormat = moment(new Date(changeDateTimeWithZone)).tz(moment.tz.guess()).format("MMMM D, YYYY | h:mm A"); var dateWithTimeZone = dateFormat +" "+ (""); } } } displayCont += `

`+decodeURIComponent(decodeURIComponent(content.boards).replace("\n","\r\n").replace("\\n","\r\n"))+`

`; displayCont += `

`+dateWithTimeZone+`

`; displayCont += `
`+decodeURIComponent(decodeURIComponent(content.title))+`
`; displayCont += `

`+decodeURIComponent(decodeURIComponent(content.description).replace("\n","\r\n").replace("\\n","\r\n"))+`

`; displayCont += '
`; } } } document.querySelector(".three-tiles").innerHTML = displayCont; } $('.widget-img img').on("error", function() { $(this).attr('src', '/html/assets/gcc-tile-card-default.png'); });

Activity in AppSheet

CSV export outputs no rows

A little help please. I have set up a CSV export and everything seems fine - except the output file has header...

  • 0 Likes
  • 7 Replies
  • 462 Views
Solved!
AppSheet

Hi I’m new to AppSheet and loving it, I’ve manage to edit a few templates for a work project. I am unable to a...

  • 0 Likes
  • 2 Replies
  • 37 Views