This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Welcome to the

AppSheet Creators Community

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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
'; res += '
'; res += '
'; res += '
'; res += '
'; if (jsonObj.urls.length > 0) { for (var i = 0; i
'; 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
`; }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 += '
'; for (var j = 0; j `+decodeURIComponent(decodeURIComponent(content.urls[j].split("||")[0]))+`
`; } } 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

Start a conversation
Load more

Join now and collaborate with the community to solve your toughest business challenges.

Sign in to Start a Topic