CINXE.COM

<!doctype html> <html lang="en" data-direction="ltr"> <head><script type="text/javascript" src="/_static/js/bundle-playback.js?v=HxkREWBo" charset="utf-8"></script> <script type="text/javascript" src="/_static/js/wombat.js?v=txqj7nKC" charset="utf-8"></script> <script>window.RufflePlayer=window.RufflePlayer||{};window.RufflePlayer.config={"autoplay":"on","unmuteOverlay":"hidden"};</script> <script type="text/javascript" src="/_static/js/ruffle/ruffle.js"></script> <script type="text/javascript"> __wm.init("https://web.archive.org/web"); __wm.wombat("https://help.appsheet.com/en/collections/378176-app-design","20210803152504","https://web.archive.org/","web","/_static/", "1628004304"); </script> <link rel="stylesheet" type="text/css" href="/_static/css/banner-styles.css?v=S1zqJCYt" /> <link rel="stylesheet" type="text/css" href="/_static/css/iconochive.css?v=3PDvdIFv" />  <link href="https://web.archive.org/web/20210803152504/https://fonts.intercomcdn.com/" rel="preconnect" crossorigin> <script src="https://web.archive.org/web/20210803152504js_/https://www.googletagmanager.com/gtag/js?id=UA-30866803-11" async="async" nonce="OPOwNmiqbpGkx/ghTkdBzKEQGz555y4IipXuB9FUVUQ="></script> <script nonce="OPOwNmiqbpGkx/ghTkdBzKEQGz555y4IipXuB9FUVUQ="> window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'UA-30866803-11'); </script> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>APP DESIGN | AppSheet Help Center</title> <meta name="description" content="How to think about the design of your apps."> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="alternate" href="https://web.archive.org/web/20210803152504/https://help.appsheet.com/en/collections/378176-app-design" hreflang="en"> <link rel="alternate" href="https://web.archive.org/web/20210803152504/https://help.appsheet.com/en/collections/378176-app-design" hreflang="x-default"> <meta name="intercom:trackingEvent" content="{"name":"Viewed Collection","metadata":{"action":"viewed","object":"collection","place":"help_center","owner":"educate","default_locale":"en","current_locale":"en","is_default_locale":true,"collection":{"id":"378176","url":"https://help.appsheet.com/en/collections/378176-app-design","value":"APP DESIGN"}}}"/> <link rel="stylesheet" media="all" href="https://web.archive.org/web/20210803152504cs_/https://static.intercomassets.com/alexandria/assets/application-c73211c4960598a57328132a0584af131717823b9f133f0e3683c3db3b086c6a.css"/> <link rel="canonical" href="https://web.archive.org/web/20210803152504/https://help.appsheet.com/en/collections/378176-app-design"/> <link href="https://web.archive.org/web/20210803152504im_/https://downloads.intercomcdn.com/i/o/51092/f0d4c28a561295c21983e2d7/b1b8067f664615ef86aa2df1a210ad49.png" rel="shortcut icon" type="image/png"/> <style> .header, .avatar__image-extra { background-color: #1c73e7; } .article a, .c__primary { color: #1c73e7; } .avatar__fallback { background-color: #1c73e7; } article a.intercom-h2b-button { background-color: #1c73e7; border: 0; } </style> <meta property="og:title" content="APP DESIGN | AppSheet Help Center"/> <meta name="twitter:title" content="APP DESIGN | AppSheet Help Center"/> <meta property="og:description" content="How to think about the design of your apps."/> <meta name="twitter:description" content="How to think about the design of your apps."/> <meta property="og:type" content="website"/> <meta property="og:image" content="https://web.archive.org/web/20210803152504im_/https://downloads.intercomcdn.com/i/o/142798/13084aa8590a653715e9b762/10ca231677addf17caf30303a38c15f1.png"/> <meta name="twitter:image" content="https://web.archive.org/web/20210803152504im_/https://downloads.intercomcdn.com/i/o/142798/13084aa8590a653715e9b762/10ca231677addf17caf30303a38c15f1.png"/> </head> <body class="header__lite"> <header class="header"> <div class="container header__container o__ltr" dir="ltr"> <div class="content"> <div class="mo o__centered o__reversed header__meta_wrapper"> <div class="mo__body header__site_name"> <div class="header__logo"> <a href="/web/20210803152504/https://help.appsheet.com/en/"> <img alt="AppSheet Help Center" src="https://web.archive.org/web/20210803152504im_/https://downloads.intercomcdn.com/i/o/103137/486c671a2a0e052da90400ce/cb62899544157d9cdcef7eff3a576e24.png"/> </a> </div> </div> <div class="mo__aside"> <div class="header__links"> <a target="_blank" rel="noopener" href="https://web.archive.org/web/20210803152504/https://www.appsheet.com/template/Apps" class="header__home__url"><svg width="14" height="14" viewbox="0 0 14 14" xmlns="http://www.w3.org/2000/svg"><g stroke="#FFF" fill="none" fill-rule="evenodd" stroke-linecap="round" stroke-linejoin="round"><path d="M11.5 6.73v6.77H.5v-11h7.615M4.5 9.5l7-7M13.5 5.5v-5h-5"/></g></svg><span>Go to AppSheet</span></a> </div> </div> </div> <form action="/web/20210803152504/https://help.appsheet.com/en/" autocomplete="off" class="header__form search"> <input type="text" autocomplete="off" class="search__input js__search-input o__ltr" placeholder="Search for articles..." tabindex="1" name="q" value=""> <div class="search_icons"> <button type="submit" class="search__submit o__ltr"></button> <a class="search__clear-text__icon"> <svg class="interface-icon" xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewbox="0 0 16 16"> <path d="M8.018 6.643L5.375 4 4 5.375l2.643 2.643L4 10.643 5.375 12l2.643-2.625L10.625 12 12 10.643 9.357 8.018 12 5.375 10.643 4z"/> </svg> </a> </form> </div> </div> </div> </header> <div class="container"> <div class="content educate_content"><section class="content section"> <div class="breadcrumb" dir="ltr"> <div class="link__arrow o__ltr"> <a href="/web/20210803152504/https://help.appsheet.com/en/">All Collections</a> </div> <div class="link__arrow o__ltr">APP DESIGN</div> </div> <div class="section__bg"> <div class="paper g__space collection__headline"> <div class="collection o__ltr"> <div class="collection__photo"> <svg role="img" viewbox="0 0 48 48"><g id="chat-question" fill="none" fill-rule="evenodd"><path d="M47 21.268c0 10.363-10.297 18.765-23 18.765-2.835 0-5.55-.418-8.058-1.184L2.725 45 7.9 34.668c-4.258-3.406-6.9-8.15-6.9-13.4C1 10.904 11.297 2.502 24 2.502s23 8.402 23 18.766z" stroke-width="2" stroke-linejoin="round"></path><path d="M25 28.502a2 2 0 1 0 0 4 2 2 0 0 0 0-4" fill="#231F1F"></path><path d="M19 17.75c0-3.312 2.686-6.124 6-6.124 3.313 0 6 2.626 6 5.938 0 3.315-2.687 5.938-6 5.938V26" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"></path></g></svg> </div> <div class="collection__meta intercom-force-break" dir="ltr"> <h1 class="t__h1">APP DESIGN</h1> <p class="paper__preview">How to think about the design of your apps.</p> <div class="avatar"> <div class="avatar__photo avatars__images o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/2176995/square_128/headshot-1609601729.jpg?1609601729" alt="Steve Coile avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> <span class="c__darker"> 14 articles in this collection </span> <br> Written by <span class="c__darker"> Santiago Uribe Montoya</span> and <span class="c__darker"> Steve Coile</span> </div> </div> </div> </div> </div> </div> <div class="g__space"> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/1100263-app-design-101" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">App Design 101</span></h2> <span class="paper__preview c__body">How to think about building your app</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/1411522-the-info-tab" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">The Info Tab</span></h2> <span class="paper__preview c__body">Customize your app's look and find where errors and warnings are happening.</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/2176995/square_128/headshot-1609601729.jpg?1609601729" alt="Steve Coile avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Steve Coile</span> <br> Updated over a week ago </div> </div> </div> </div> </a> </div> <div class="g__space"> <div class="section__headline" id="modeling-tables-and-columns" dir="ltr"> <div class="section__content intercom-force-break">Modeling tables and columns</div> </div> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/1128191-the-item-detail-data-pattern" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">The "Item-Detail" Data Pattern</span></h2> <span class="paper__preview c__body">A classic data model pattern to capture many Detail records that correspond to a single Item record</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/1211505-the-lookup-dropdown-data-pattern" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">The "Lookup/Dropdown" Data Pattern</span></h2> <span class="paper__preview c__body">A classic data pattern used to help users pick values from a fixed list of options</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> </div> <div class="g__space"> <div class="section__headline" id="ux-design-patterns" dir="ltr"> <div class="section__content intercom-force-break">UX design patterns</div> </div> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/1201279-control-whether-and-when-a-value-can-be-edited-in-a-form" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">Control Whether and When a Value Can be Edited in a Form</span></h2> <span class="paper__preview c__body">Design pattern to ensure that a form input can only be changed in specific circumstances.</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> </div> <div class="g__space"> <div class="section__headline" id="app-design-patterns" dir="ltr"> <div class="section__content intercom-force-break">App design patterns</div> </div> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/962279-make-your-list-into-an-app" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">Make Your List into an App</span></h2> <span class="paper__preview c__body">Everyone has a list in a spreadsheet - a client list, an item list, etc. Here are some suggestions for building useful list apps.</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/962284-many-identical-apps" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">Many Identical Apps</span></h2> <span class="paper__preview c__body">How to make several versions of the same app that are different for each user</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> </div> <div class="g__space"> <div class="section__headline" id="spreadsheet-design" dir="ltr"> <div class="section__content intercom-force-break">Spreadsheet design</div> </div> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/961386-making-an-appsheet-friendly-spreadsheet" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">Making an "AppSheet-Friendly" Spreadsheet</span></h2> <span class="paper__preview c__body">How to optimize your spreadsheet design so that it works better with AppSheet</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/961388-effective-use-of-column-headers" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">Effective Use of Column Headers</span></h2> <span class="paper__preview c__body">How to make sure that AppSheet can identify and locate your column headers</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/1044830-working-with-a-spreadsheet-and-the-editor" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">Working with a Spreadsheet and the Editor</span></h2> <span class="paper__preview c__body">How to understand and control the process of getting your spreadsheet to work well with the AppSheet Editor.</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/961390-spreadsheet-cell-formats" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">Spreadsheet Cell Formats</span></h2> <span class="paper__preview c__body">You can assign a "cell format" to a cell in your spreadsheet to control how the data stored in that cell is displayed.</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/961393-spreadsheet-formulas" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">Spreadsheet Formulas</span></h2> <span class="paper__preview c__body">How formulas you write in your spreadsheet impact your app creation process</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/3326638-mismatched-spreadsheet-formulas" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">Mismatched Spreadsheet Formulas</span></h2> <span class="paper__preview c__body">Diagnosing Mismatched Formulas in a Column</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> <a href="/web/20210803152504/https://help.appsheet.com/en/articles/962281-using-spreadsheets-with-pivoted-data" class="t__no-und paper paper__article-preview"> <div class="article__preview intercom-force-break" dir="ltr"> <h2 class="t__h3"><span class="c__primary">Using Spreadsheets with Pivoted Data</span></h2> <span class="paper__preview c__body">Most spreadsheet data uses field names as column headers and data entries in each row.</span> <div class="avatar"> <div class="avatar__photo o__ltr"> <img src="https://web.archive.org/web/20210803152504im_/https://static.intercomassets.com/avatars/1310421/square_128/santiago_bw_cropped-1498516487.png?1498516487" alt="Santiago Uribe Montoya avatar" class="avatar__image"> </div> <div class="avatar__info"> <div> Written by <span class="c__darker"> Santiago Uribe Montoya</span> <br> Updated over a week ago </div> </div> </div> </div> </a> </div> </div> </section> </div> </div> <footer class="footer"> <div class="container"> <div class="content"> <div class="u__cf" dir="ltr"> <div class="footer__logo"> <a href="/web/20210803152504/https://help.appsheet.com/en/"> <img alt="AppSheet Help Center" src="https://web.archive.org/web/20210803152504im_/https://downloads.intercomcdn.com/i/o/103137/486c671a2a0e052da90400ce/cb62899544157d9cdcef7eff3a576e24.png"/> </a> </div> <div class="footer__links"> <ul class="footer__link-list footer__links__custom"> <li class="footer__link footer__link__" data-footer-link-type="custom"> <a target="_blank" rel="nofollow noreferrer noopener" href="https://web.archive.org/web/20210803152504/https://www.appsheet.com/Template/Apps?utm_source=Help&utm_medium=intercom&utm_term=footer">My Apps</a> </li> <li class="footer__link footer__link__" data-footer-link-type="custom"> <a target="_blank" rel="nofollow noreferrer noopener" href="https://web.archive.org/web/20210803152504/https://community.appsheet.com/">馃檵Ask the Community</a> </li> </ul> </div> </div> </div> </div> </footer> <script nonce="OPOwNmiqbpGkx/ghTkdBzKEQGz555y4IipXuB9FUVUQ="> window.intercomSettings = {"app_id":"vwrsb6v2"}; </script> <script nonce="OPOwNmiqbpGkx/ghTkdBzKEQGz555y4IipXuB9FUVUQ="> (function(){var w=window;var ic=w.Intercom;if(typeof ic==="function"){ic('reattach_activator');ic('update',intercomSettings);}else{var d=document;var i=function(){i.c(arguments)};i.q=[];i.c=function(args){i.q.push(args)};w.Intercom=i;function l(){var s=d.createElement('script');s.type='text/javascript';s.async=true;s.src="https://web.archive.org/web/20210803152504/https://widget.intercom.io/widget/vwrsb6v2";var x=d.getElementsByTagName('script')[0];x.parentNode.insertBefore(s,x);}if(w.attachEvent){w.attachEvent('onload',l);}else{w.addEventListener('load',l,false);}}})() </script> <script src="https://web.archive.org/web/20210803152504js_/https://static.intercomassets.com/alexandria/assets/application-130be63fc09b6129d9f3c49a1a21e594b51cc38a76846266ec9f754a30898812.js" nonce="OPOwNmiqbpGkx/ghTkdBzKEQGz555y4IipXuB9FUVUQ="></script> </body> </html>