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" : 1732577718956, "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-Forum/ct-p/appsheet-spaces", "description" : "Have questions about using AppSheet? Need help with your app? This is where you can ask questions and find answers from a global community of your peers, app creators, and platform experts.", "id" : "appsheet-spaces", "shortTitle" : "AppSheet Forum", "title" : "AppSheet Forum", "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-Q-A%2FAppSheet%2Fm-p%2F838292", "loginUrlNotRegistered" : "https://www.googlecloudcommunity.com/gc/user/userloginpage?redirectreason=notregistered&dest_url=https%3A%2F%2Fwww.googlecloudcommunity.com%2Fgc%2FAppSheet-Q-A%2FAppSheet%2Fm-p%2F838292", "loginUrlNotRegisteredDestTpl" : "https://www.googlecloudcommunity.com/gc/user/userloginpage?redirectreason=notregistered&dest_url=%7B%7BdestUrl%7D%7D" }, "name" : "ForumTopicPage", "rtl" : false, "object" : { "viewHref" : "/gc/AppSheet-Q-A/AppSheet/td-p/836231", "subject" : "AppSheet", "id" : 836231, "page" : "ForumTopicPage", "type" : "Thread" } }, "WebTracking" : { "Activities" : { }, "path" : "Community:Google Cloud Community/Category:AppSheet/Category:AppSheet Forum/Board:AppSheet Q&A/Message:Re: 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" : { "conversationStyle" : "forum", "viewHref" : "https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/bd-p/appsheet-questions", "settings" : { }, "description" : "Have questions about using AppSheet? Need help with your app? This is where you can ask questions and find answers from a global community of your peers, app creators, and platform experts.", "id" : "appsheet-questions", "shortTitle" : "AppSheet Q&A", "title" : "AppSheet Q&A", "nodeType" : "Board", "ancestors" : [ { "viewHref" : "https://www.googlecloudcommunity.com/gc/AppSheet-Forum/ct-p/appsheet-spaces", "description" : "Have questions about using AppSheet? Need help with your app? This is where you can ask questions and find answers from a global community of your peers, app creators, and platform experts.", "id" : "appsheet-spaces", "shortTitle" : "AppSheet Forum", "title" : "AppSheet Forum", "nodeType" : "category" }, { "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" }, { "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 = 'forums/v5/ForumTopicPage'; LITHIUM.Components.ORIGINAL_PAGE_ID = 'ForumTopicPage'; LITHIUM.Components.ORIGINAL_PAGE_CONTEXT = 'AXecsOWmWZaD8V-nyLV6_Xub9pqH8A455b232PdYn3vNMtSys4fkc1so444kDPU8HNIyV1s_uh4jQqmdT9PfcPLoLBucVD8GCRhO7MSddwaeSiEFLDwzi7YjSfC3qWQeZSIRxwG5gocRhlUDh96DW2Nlu24dxsybsU3W7_LiZQ_5yugi8785LmyzgWyGzy9lZcG2lU1TLDrlUhNL5E75ev7GTn0mlkXNCjg8gVGLMVmpk1iKAEL97PPF8QUZCZiQCK-ZXFI93nIhOuv2bmDtM2SFXtAU9LUNOnrYDizzyQYcTHIXyHiLSnp4koWa-6SHxMoBKvsfG_XZZRSfc6UrGadVnljO_S4u8KbeMI5T1bShTVs20wY57g3YF6RuVkqG'; 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", "FACEBOOK_LOGOUT" : "lia-component-users-action-logout", "BASE_DISABLED" : "lia-link-disabled", "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 = [ "prism.js", "theme.js", "KeepSessionAlive.js", "jquery.effects.slide.js", "plugin.js", "MessageBodyDisplay.js", "plugin.js", "brightcove_uploader.js", "ReCaptchaV3.js", "PolyfillsAll.js", "en.js", "TinyMceEditor.js", "DynamicPager.js", "en.js", "jquery.delayToggle-1.0.js", "tinymce-patched.js", "en.js", "jquery.ui.widget.js", "jquery.ajax-cache-response-1.0.js", "jquery.clone-position-1.0.js", "plugin.js", "jquery.function-utils-1.0.js", "DataHandler.js", "Components.js", "MessageEditor.js", "SearchForm.js", "ProductsField.js", "jquery.blockui.js", "AjaxFeedback.js", "SearchAutoCompleteToggle.js", "jquery.ui.draggable.js", "plugin.js", "DropDownMenu.js", "LiModernizr.js", "jquery.placeholder-2.0.7.js", "jquery.ui.resizable.js", "plugin.js", "jquery.tmpl-1.1.1.js", "InlineMessageReplyContainer.js", "Text.js", "Events.js", "ElementQueries.js", "jquery.css-data-1.0.js", "json2.js", "BlockEvents.js", "jquery.viewport-1.0.js", "NoConflict.js", "UserListActual.js", "aws-sdk.js", "FieldSet.js", "Tooltip.js", "en.js", "MessageViewDisplay.js", "ResizeSensor.js", "plugin.js", "LazyLoadComponent.js", "HelpIcon.js", "en.js", "jquery.effects.core.js", "en.js", "Throttle.js", "plugin.js", "plugin.js", "jquery.tools.tooltip-1.2.6.js", "plugin.js", "plugin.js", "Cache.js", "plugin.js", "TokenInputAutoComplete.js", "PartialRenderProxy.js", "jquery.scrollTo.js", "plugin.js", "jquery.position-toggle-1.0.js", "en.js", "plugin.js", "jquery.hoverIntent-r6.js", "jquery.ui.position.js", "jquery.ui.dialog.js", "jquery.ui.mouse.js", "jquery.iframe-transport.js", "EarlyEventCapture.js", "jquery.js", "plugin.js", "jquery.json-2.6.0.js", "jquery.ui.core.js", "Video.js", "Link.js", "DeferredImages.js", "Lithium.js", "plugin.js", "AutoComplete.js", "plugin.js", "CustomEvent.js", "plugin.js", "plugin.js", "InputEditForm.js", "ActiveCast3.js", "Forms.js", "InformationBox.js", "jquery.autocomplete.js", "OoyalaPlayer.js", "ForceLithiumJQuery.js", "plugin.js", "jquery.fileupload.js", "en.js", "Globals.js", "ElementMethods.js", "Namespace.js", "plugin.js", "jquery.appear-1.1.1.js", "Auth.js", "Placeholder.js", "jquery.lithium-toastmessage.js", "ThreadedDetailMessageList.js", "Sandbox.js", "DropDownMenuVisibilityHandler.js", "en.js", "jquery.lithium-selector-extensions.js", "api.js", "InlineMessageReplyEditor.js", "plugin.js", "jquery.tokeninput-1.6.2.js", "jquery.iframe-shim-1.0.js", "AjaxSupport.js", "plugin.js", "InlineMessageEditor.js", "Loader.js", "CookieBannerAlert.js", "plugin.js", "Dialog.js", "SpoilerToggle.js", "en.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

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 add a reference to a stock adjustment, say in stock management app when stock is changed how would I add a reference to it, so it can be viewed in the stock adjustment table showing time , stock amount and a reference for that stock adjustment. I’ve tried different methods but still unable to get it working. 
many help or advice greatly appreciated.

thanks 

Greg 

0 3 50
3 REPLIES 3

It is not clear what structure you have and what end result you are looking for.   Please show what you have so far for the best help.

Basically if you started an app template “inventory management “ when you edit stock levels how would I put a column in for the inventory log as a reference for purchase order number for that stock adjustment?

I hope to help, but not sure about the goal. I don't think most of us here that can help use app templates unless to display areas of growth for projects or a new way to design a base for an app. So might need more info. There are many ways that inventory can be managed through appsheets. Break down your end goal in mind in a little more detail via a step by step on what you are trying to achieve.