How to build an Airtable Admin Panel/ GUI using Low-Code
Tags: showdev, tutorial, lowcode, airtable
Published: 2021-08-24 14:58:05

<em class="iz">This article walks us through the process of creating an admin panel and sales dashboard on top of Airtable data. Using the <a href="https://www.dronahq.com/details-integrations/Airtable/">ready connector to Airtable</a> in DronaHQ, we will be integrating with the customer database present in Airtable and notify the admin or sales managers on Slack every time a new customer is added to the database. </em>
<h2 id="f046" class="ja jb gb as jc jd je ig jf jg jh ik ji jj jk jl jm jn jo jp jq jr js jt ju jv cr"><strong>Building an Airtable Admin Panel</strong></h2>
<p id="f255" class="ib ic gb id b ie jw ig ih ii jx ik il im jy io ip iq jz is it iu ka iw ix iy ex cr" data-selectable-paragraph="">The Admin Panel is the fundamental tool for working with your online store. Using this internal tool, you can manage products and orders, offer discounts, interact with your customers, and do much more.</p>
<p id="8170" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">Using a custom internal tool like an admin panel, you can turn your Sales figures, Inventory, Customer database stored in Airtable to actionable insights and dashboards. It can also be used to export weekly/monthly/yearly data to create reports.</p>
<p id="ebad" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">An Airtable Admin panel will increase productivity, give insight into data, and help you catch the pain points of any particular team or employee, further leading to greater revenue for your company. By investing in an Airtable admin panel early, you will establish an efficient business and allow your workforce to do what they need to make your company grow.</p>
<p data-selectable-paragraph="">With DronaHQ, you can:</p>

<ol>
 	<li>Create multiple views in your Airtable GUI so different users will see only the data intended for them</li>
 	<li>Manage user access to define view and edit rights using roles based as well as user based <a href="https://community.dronahq.com/t/app-permissions/525">permissions</a></li>
 	<li>Create filtered Airtable client views by defining on-screen <a href="https://community.dronahq.com/t/applying-rules/227">rules</a>.</li>
 	<li>Search and filter your Airtable data and data sets depending on pre-defined filter parameters</li>
 	<li>Manipulate your Airtable data, edit or delete data through the Airtable GUIs</li>
 	<li>Combine Airtable data with information from other platforms like Google Sheets, Zendesk, HubSpot, Salesforce and lots more.</li>
</ol>
To follow along with this tutorial, <a href="https://www.dronahq.com/signup">login to connect Airtable database now</a>
<h3 id="7d63" class="ja jb gb as jc jd je ig jf jg jh ik ji jj jk jl jm jn jo jp jq jr js jt ju jv cr"><strong>How to integrate your Admin Panel, Admin Client, Dashboard, Internal Tool, or GUI with  your Airtable account on DronaHQ?</strong></h3>
<p id="13af" class="ib ic gb id b ie jw ig ih ii jx ik il im jy io ip iq jz is it iu ka iw ix iy ex cr" data-selectable-paragraph="">DronaHQ has many ready connectors that will easily integrate with the apps you use in your everyday work. For this use case, we will use <a href="https://www.dronahq.com/details-integrations/Airtable/">Airtable connector</a> and <a href="https://www.dronahq.com/details-integrations/Slack/">Slack connector</a>.</p>
<p id="1206" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">Let’s get started.</p>
<p id="b331" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong class="id kb">Step 1:</strong> Go to DronaHQ Studio &gt; Connectors &gt; Manage Accounts</p>
<p data-selectable-paragraph=""><img class=" wp-image-13924 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/1-300x169.png" alt="DronaHQ Studio — Connectors Section" width="675" height="380" /></p>
<p id="b331" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><img class=" wp-image-13926 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/2-300x169.png" alt="Configuring Account" width="582" height="328" /></p>
<p id="dd0e" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong class="id kb">Step 2:</strong> For adding your Airtable account in DronaHQ, you need four fields: Account Name, API Key, Base ID, and Table Name.</p>
<strong class="id kb">1. Account Name: </strong>Give your account a name without any space. In my case, it was “ambar."
<p id="97ef" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong class="id kb">2. API Key: </strong>Go to your Airtable account (<strong class="id kb">airtable.com/account</strong>), and click on “Generate API Key.” This API Key will be the same for all your tables present in it.</p>
<p data-selectable-paragraph=""><img class=" wp-image-13927 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/4-300x169.png" alt="Generating API Key" width="543" height="306" /></p>
<p data-selectable-paragraph=""><strong class="id kb">3. Base ID:</strong> This can be accessed from <strong class="id kb">airtable.com/api</strong>. Click on the base (or table) you want to integrate.</p>
<p data-selectable-paragraph=""><img class="aligncenter wp-image-13928 " src="https://www.dronahq.com/wp-content/uploads/2021/04/5-300x221.png" alt="Link: airtable.com/api" width="396" height="292" /></p>
<p data-selectable-paragraph=""><img class=" wp-image-13929 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/6-300x169.png" alt="Base ID" width="676" height="381" /></p>
<p id="31b1" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong class="id kb">4. Table Name: </strong>This value will be the name of the base (or table) you want to connect. In my case, it’s “Classic Cars.”</p>
<p id="5393" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">Now that we have all the values for the integration, we can easily connect and use the data in our Airtable Admin Panel app.</p>
<p data-selectable-paragraph=""><img class=" wp-image-13980 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/7-1-300x169.png" alt="Connecting your Airtable account" width="659" height="371" /></p>
<p data-selectable-paragraph=""><strong class="id kb">Step 3: </strong>Now click on “Submit,” and voila! Your account will get connected to Studio.</p>
<p id="7928" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">You can now access your Airtable data to do 5 actions, allowed by DronaHQ. Those are shown in the image.</p>
<img class=" wp-image-13932 alignright" src="https://www.dronahq.com/wp-content/uploads/2021/04/2021-04-20-7-244x300.png" alt="Airtable actions supported by DronaHQ" width="210" height="258" />

&nbsp;

In this article, we will cover the first 3 actions.
<ol>
 	<li id="2faa" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy kl km kn cr" data-selectable-paragraph=""><strong class="id kb">Find Rows: </strong>You can find multiple rows in your Airtable database, using one column to filter. It will return record IDs of all the rows found.</li>
 	<li id="6cf6" class="ib ic gb id b ie ko ig ih ii kp ik il im kq io ip iq kr is it iu ks iw ix iy kl km kn cr" data-selectable-paragraph=""><strong class="id kb">Find a Row: </strong>Like the first one, it will return us only one specific record ID.</li>
 	<li id="d44e" class="ib ic gb id b ie ko ig ih ii kp ik il im kq io ip iq kr is it iu ks iw ix iy kl km kn cr" data-selectable-paragraph=""><strong class="id kb">Create Row: </strong>The integration with Airtable will enable you to add a new record (in the end) to the Airtable table.</li>
</ol>
&nbsp;
<h3 id="b686" class="ja jb gb as jc jd je ig jf jg jh ik ji jj jk jl jm jn jo jp jq jr js jt ju jv cr"><strong>About Airtable Database</strong></h3>
<p id="5811" class="ib ic gb id b ie jw ig ih ii jx ik il im jy io ip iq jz is it iu ka iw ix iy ex cr" data-selectable-paragraph="">In my Airtable database, I have various sheets, but we will use the sheets mentioned below.</p>
<strong class="id kb">1. Employees List:</strong> All the details about the workforce, starting with their employee number, name, contact info, reporting manager, job title, and more.

<strong class="id kb">2. Customers List:</strong> All the customers are given a unique ID called Customer Number. Along with this, it contains the customer name, the company he/she belongs to, contact details, which sales rep is handling their orders, etc.

<strong class="id kb">3. Product Types:</strong> It consists of categories under which products are distributed, for example, motorcycles, classic cars, vintage cars, buses &amp; trucks, trains, ships, and planes. This sheet also tells us about the number of products in each category.

<strong class="id kb">4. Product List:</strong> It contains all the products, along with their unique product code, name, which category it belongs to, its vendor, description, and size.

<strong class="id kb">5. Orders Status:</strong> This list consists of all the orders, along with their details like customer number, ordered date, required date, order status (shipped, in-process, on hold, and more), shipped data (if shipped), and comments (if any).

<strong class="id kb">6. Order Details:</strong> This list is the extended version of the previous one. It contains the breakdown of each order according to the product ID.

<img class=" wp-image-13917 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/1235-300x137.png" alt="Order details" width="589" height="269" />
<p id="8006" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">[Image Above]For example, there’s an order number “10101”, which contains four different products, with different quantities and prices. This list will thus show the breakdown of the order.</p>
<strong>7.</strong> <strong class="id kb">Yearly Orders: </strong>It contains the number of sales done in a month of any particular year.

<strong class="id kb">8. SDR Sales:</strong> Number of sales a particular sales representative has done. It has the SDR’s name, employee number, and a number of sales done.

<strong class="id kb">9. Payment Details:</strong> It has a check number, the date of transaction, and the total amount paid.

&nbsp;
<h2 id="bee0" class="ja jb gb as jc jd je ig jf jg jh ik ji jj jk jl jm jn jo jp jq jr js jt ju jv cr"><strong>Building the Airtable Admin Panel</strong></h2>
<h3 id="e2a2" class="ln jb gb as jc lo lp lq jf lr ls lt ji lu lv lw jm lx ly lz jq ma mb mc ju md cr"><strong>Step 1: Using a pre-built template</strong></h3>
<p id="cc04" class="ib ic gb id b ie jw ig ih ii jx ik il im jy io ip iq jz is it iu ka iw ix iy ex cr" data-selectable-paragraph="">We will use a pre-built app template to give a quick start. Go to <strong class="id kb">Studio &gt; Templates &gt; Admin Panel.</strong></p>
<p data-selectable-paragraph=""><strong>Note: </strong>These steps can also be used to build custom Airtable GUIs or a web client.</p>

<p id="413b" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">As you can see, this template will make it extremely easy to build the Airtable admin panel. It contains five sections, and we will use all of them, with slight tweaking.</p>

<h3 id="b7b4" class="ln jb gb as jc lo lp lq jf lr ls lt ji lu lv lw jm lx ly lz jq ma mb mc ju md cr"><strong>Step 2: Let’s start with the Customers’ Section</strong></h3>

<p data-selectable-paragraph="">In the customers’ screen, we need to add a formula to the table grid control present. For that, I have imported the Customers Airtable Database (CSV file) to DronaHQ Sheets.</p>
<p data-selectable-paragraph=""><img class=" wp-image-13939 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/Airtable-App-Blog-300x169.png" alt="Binding data to table grid control" width="705" height="398" /></p>
<p id="a6f1" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">Select the table grid control, go to <strong class="id kb">BindData &gt; Custom Formula &gt; Edit</strong></p>
<p class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">To display the customers’ list, we will use the LOOKUP() formula. Add the formula shown below and click on “Save and Validate”.</p>
<img class=" wp-image-13943 alignright" src="https://www.dronahq.com/wp-content/uploads/2021/04/1234567-300x292.png" alt="Formula to bind data" width="379" height="369" />
<p id="458e" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong class="id kb"><em class="iz">Syntax:</em></strong><em class="iz"> LOOKUP([Sheetname.columnname],filter,sorting,order)</em></p>
<p id="9ae1" class="ib ic iz id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong><em>LOOKUP([Airtable_Customers.CustomerNumber,Airtable_</em></strong><strong><em>Customers.CompanyName,Airtable_Customers.FirstName,Airtable_Customers.LastName,Airtable_Customers.Country,Airtable_Customers.SalesRepEmployeeNumber,Airtable_Customers.CreditLimit])</em></strong></p>
<p id="d331" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong class="id kb">Name of the DronaHQ Sheet:</strong> Airtable_Customers</p>
<p id="4cd0" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong class="id kb">Variable </strong><strong class="id kb">Nam</strong><strong class="id kb">es:</strong> CustomerNumber, CompanyName, FirstName, LastName, Country, SalesRepEmployeeNumber, CreditLimit</p>
<p id="2e11" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong class="id kb">NOTE:</strong> LOOKUP() formula is used for data present in DronaHQ Sheets. So wherever I have used it, you need to import the CSV file of the corresponding sheet.</p>
<p id="cbf4" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">The result shown will be similar to the image.</p>
<p id="1476" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">Here, we have not used any filter, as we want to display the whole list of customers. But, if you want to know more about the LOOKUP() formula filters, refer <a class="cd mn" href="https://community.dronahq.com/t/all-custom-functions-list/293" rel="noopener nofollow">to this</a>.</p>
<img class="wp-image-13944 alignright" src="https://www.dronahq.com/wp-content/uploads/2021/04/00-242x300.png" alt="Redirecting from table grid" width="233" height="289" />In the table grid control, when you click on any one row, it gives 3 options:
<ol>
 	<li id="e2c4" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy kl km kn cr" data-selectable-paragraph="">Select Row,</li>
 	<li id="7952" class="ib ic gb id b ie ko ig ih ii kp ik il im kq io ip iq kr is it iu ks iw ix iy kl km kn cr" data-selectable-paragraph="">Navigate with Selection, or</li>
 	<li id="116c" class="ib ic gb id b ie ko ig ih ii kp ik il im kq io ip iq kr is it iu ks iw ix iy kl km kn cr" data-selectable-paragraph="">Show Details.</li>
</ol>
<p id="b1cc" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">In our case, we will use <strong class="id kb">“Navigate with Selection”,</strong> which means when a row is clicked, it will take to the details of that particular customer.</p>
<p data-selectable-paragraph="">For this, in the properties of the table grid, you will find a “Actions” section. You can use any action you wish to happen when a row is clicked, whether selecting or navigating to some other screen.</p>
<p data-selectable-paragraph="">I have used the action to navigate it to <strong class="id kb">“Customer Details”,</strong> a new screen type <strong class="id kb">“Tray.”</strong> You can set the screen type from the properties section, with custom width. It will display the customer details like company name, customer contact information, the orders that particular customer has placed, and payment corresponding to those orders.</p>
<p data-selectable-paragraph=""><img class="wp-image-13948 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/9-300x169.png" alt="Setting the screen type as “Tray”" width="761" height="429" /></p>
<p data-selectable-paragraph=""><img class="alignnone wp-image-13949 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/10-300x169.png" alt="Manage the width of Tray screen type" width="742" height="418" /></p>
<p id="6883" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">All the fields will use the LOOKUP() formula with a filter of Customer Number (match with the customer selected).</p>
<p id="ed9a" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">Let’s see an example, for displaying the <strong class="id kb">company name</strong>:</p>
<p id="3ee7" class="ib ic iz id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong><em>LOOKUP([Airtable_Customers.CompanyName],Airtable_Customers.CustomerNumber = customerslist.CustomerNumber)</em></strong></p>
<p id="ebb8" class="ib ic iz id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><em>Where, “Airtable_Customers.CustomerNumber = customerslist.CustomerNumber” is a filter used.</em></p>
<p id="8a7b" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">To get the customer’s orders in the table grid, we will again use LOOKUP().</p>
<p id="c1b3" class="ib ic iz id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong><em>LOOKUP([Airtable_Orders_Status.OrderNumber,Airtable_Orders_Status.OrderDate,Airtable_Orders_Status.RequiredDate,Airtable_Orders_Status.ShippedDate,Airtable_Orders_Status.Status,Airtable_Orders_Status.Comments] , Airtable_Orders_Status.CustomerNumber = customerslist.CustomerNumber)</em></strong></p>
<p id="4de5" class="ib ic iz id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><em>Where, “Airtable_Orders_Status.CustomerNumber = customerslist.CustomerNumber” is a filter used.</em></p>
<p id="902c" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">Similarly, can be done for the <strong class="id kb">payments table</strong>:</p>
<p id="c39c" class="ib ic iz id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong><em>LOOKUP([Airtable_Payment.CheckNumber,Airtable_Payment.PaymentDate,Airtable_Payment.TotalAmount] , Airtable_Payment.CustomerNumber = customerslist.CustomerNumber)</em></strong></p>
<p id="1067" class="ib ic iz id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><em>Where, “ Airtable_Payment.CustomerNumber = customerslist.CustomerNumber” is a filter used.</em></p>
<p id="2917" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">Further, when you click on the customer’s orders, the details of that order will be shown in a pop-up. This means all the products, their code, price of each, and quantity. The process of redirecting when clicked is similar to how we did for customer details.</p>
<p data-selectable-paragraph=""><img class="aligncenter" src="https://miro.medium.com/max/2400/0*dZQ0mjtt_i7mkfRE" alt="Table grid in a pop-up" width="593" height="332" /></p>
<p id="0f37" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">The pop-up will consist of a table grid with the LOOKUP() formula and filter of Order Number (matched with the order selected).</p>
<p id="3ab3" class="ib ic iz id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong><em>LOOKUP([Airtable_Orders_List.Product_Code,Airtable_Orders_List.Order_Quantity,Airtable_Orders_List.Price_Each,Airtable_Orders_List.Total_Cost] , Airtable_Orders_List.Order_Number = customerorders1.OrderNumber)</em></strong></p>
<p id="c91d" class="ib ic iz id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><em>Where, “Airtable_Orders_List.Order_Number = customerorders1.OrderNumber” is a filter used</em><strong><em>.</em></strong></p>

<h3 id="7272" class="ln jb gb as jc lo lp lq jf lr ls lt ji lu lv lw jm lx ly lz jq ma mb mc ju md cr"><strong>Step 3: Add a new customer</strong></h3>
<img class="wp-image-13952 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/13-300x169.png" alt="Creating a new form using existing DronaHQ Sheets" width="621" height="350" />
<p id="c546" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">For adding a new customer, we will start by building a form. You create it from scratch or you can:</p>
<p id="2643" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph=""><strong><em class="iz">Go to +Add &gt; Form &gt; Select your DronaHQ Sheet (where you want the details to be added, when the form is submitted) &gt; Select the input fields &gt; Create.</em></strong></p>
<p data-selectable-paragraph=""><img class="wp-image-13953 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/14-300x169.png" alt="Select your Sheet" width="575" height="324" /></p>
<p id="d2e4" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">For building a form from scratch, you can refer to <a class="cd mn" href="https://www.youtube.com/watch?v=1wz3lZasvRw&amp;list=PLjR7woBxsQ-FTKR54rOdBWDvwEQaXRux6" rel="noopener nofollow">this</a>. After building the form, it looks something like this.</p>
<p data-selectable-paragraph=""><img class=" wp-image-13955 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/12-300x234.png" alt="Form for adding a new customer" width="503" height="392" /></p>
<p id="d972" class="ib ic gb id b ie if ig ih ii ij ik il im in io ip iq ir is it iu iv iw ix iy ex cr" data-selectable-paragraph="">For, navigating from the customers’ list screen to this new form screen, I added an action button (purple one shown in the image below).</p>
<p data-selectable-paragraph=""><em class="iz"><img class=" wp-image-13958 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/098-300x170.png" alt="Action Button" width="651" height="369" /></em></p>
<p id="f61e" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">Now, we need to you can click on the action button on the screen and <a class="az ej" href="https://www.youtube.com/watch?v=2Ddvk1RY7qU" rel="noopener nofollow">use action flow</a> to navigate it to the “Add New Customer” form screen.</p>
<p id="3473" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">For navigation, <em><strong class="ri hv">Click + &gt; Navigate To &gt; Select the Form Screen &gt; Continue &gt; Give your action a name (ex: Add New Customer) &gt; Finish.</strong></em></p>
<p id="4fd2" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">On the same screen, we need to add workflow to handle our server-side’s requests, like updating the database with a new row of customer details.</p>
<p id="3fed" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">I needed my workflow to do 3 things:</p>

<ol>
 	<li id="bad1" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv aca acb acc bz" data-selectable-paragraph="">Add the new customer details in DronaHQ Sheets.</li>
 	<li id="190d" class="yz za xp ri b zb acd zd ze zf ace zh zi zj acf zl zm zn acg zp zq zr ach zt zu zv aca acb acc bz" data-selectable-paragraph="">Adding the new customer details in the Airtable database.</li>
 	<li id="168d" class="yz za xp ri b zb acd zd ze zf ace zh zi zj acf zl zm zn acg zp zq zr ach zt zu zv aca acb acc bz" data-selectable-paragraph="">Sending a Slack message to the channel of the sales representatives, notifying them about the addition to the new customer.</li>
</ol>
<p id="fe28" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">For the task of adding/updating the DronaHQ Sheets in workflow, you can learn it <a class="az ej" href="https://community.dronahq.com/t/update-sheet-task/358" rel="noopener nofollow">here</a>.</p>
<p id="f1b9" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">For adding a new customer in Airtable, you need to go to workflows:</p>
<p id="5d96" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em class="zw">Airtable &gt; Create Row &gt; Choose Account &gt; Add your Base ID and Table Name (where you want to add a new row) in double quotations (“”) &gt; Task Name &gt; Finish</em></strong></p>
<p id="49ee" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong class="ri hv">NOTE: </strong>Adding the Base ID and Table Name in (“”) is extremely important, as the values are being taken by the system as a String.</p>

<p id="41f7" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">For sending a Slack notification to the SDR channel or Sales Manager, you can use this approach:</p>
<p id="4cc5" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em class="zw">Slack &gt; Select a Sub Category (my case — SendMessageToChannel) &gt; Choose Account &gt; Select Channel and write a message you want to send in double quotations (“”) &gt; Task Name &gt; Finish</em></strong></p>
<p id="c4b7" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">This is how my final workflow for adding a new customer looks like:</p>
<p data-selectable-paragraph=""><img class=" wp-image-13961 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/76-300x124.png" alt="Final Workflow" width="665" height="275" /></p>

<h3 id="c557" class="acy zy xp bw fx acz aea aeb sj aec aed aee sn so aef sp sr ss aeg st sv sw aeh sx sz aei bz"><strong>Step 4: Products’ Section</strong></h3>
<p id="9177" class="yz za xp ri b zb abn zd ze zf abo zh zi zj abp zl zm zn abq zp zq zr abr zt zu zv vg bz" data-selectable-paragraph="">In this screen, I have used a list card made in Designer to display different types of products.</p>


<p id="4480" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">As you can see, each card is for a category that contains a title, description, and image. When a click on any of the cards, it navigates to a screen containing a list of products in that particular category using action flows.</p>
<p id="d4db" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">To add the filter in the table grid of only choosing the “Chosen” product type, you will need to configure the <strong class="ri hv">“Find Rows” in Airtable Connector,</strong> as shown in the video below.</p>
<p id="cb1b" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em>Airtable &gt; Find Rows &gt; Choose Account &gt; Give your connector a name (ex: FindMotorcycles) &gt; Choose the column which should be used to initiate the search (ex: ProductType) &gt; What value should be searched for (ex: Motorcycles) &gt; Add your Base ID and Table Name (where you want to search for, ex.ProductsDetails) &gt; Task Name &gt; Finish</em></strong></p>


<p id="9f88" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">After adding a connector, to bind the data to the table grid control, you need the 2 functions — MAPKEYS() and BINDAPI(). The following formula is for the “Motorcycles” category</p>
<p id="6a09" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em>MAPKEYS( BINDAPI( [FindMotorcycles.records.fields]) , “Product_Code:Product Code, Product_Name:Product Name, ProductType:ProductType, Product_Scale:Product Scale, Product_Vendor:Product Vendor, Product_Description:Product Description, Quantity_In_Stock:Quantity In Stock, Buy_Price:Buy Price, MSRP:MSRP”)</em></strong></p>
<p id="6e4e" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><em>Where, “FindMotorcycles” is the connector name, and for the rest of the formula is mapping of variables. For example, in Product_Code:Product Code, the format is destination:source. So Product_Code is the destination and Product Code is the name of the column in my Airtable Database.</em></p>
<p id="6b5b" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">A similar process can be followed for all the categories.</p>
<p data-selectable-paragraph=""><img class=" wp-image-13964 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/36-300x169.png" alt="Mapping variables using BINDAPI()" width="711" height="401" /></p>
<p id="2e77" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong class="ri hv">NOTE: </strong>The destination variable shouldn’t have any spaces, and you can name it anything, not necessarily the same name.</p>
<p id="47b2" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">Read more about <a class="az ej" href="https://community.dronahq.com/t/integrating-airtable-with-dronahq-studio/720" rel="noopener nofollow">Airtable Integration with DronaHQ</a>.</p>

<h3 id="dc2b" class="acy zy xp bw fx acz aea aeb sj aec aed aee sn so aef sp sr ss aeg st sv sw aeh sx sz aei bz"><strong>Step 5: Orders’ Section</strong></h3>
<p id="dfa0" class="yz za xp ri b zb abn zd ze zf abo zh zi zj abp zl zm zn abq zp zq zr abr zt zu zv vg bz" data-selectable-paragraph="">The Order Section will be beneficial for the Customer Success Team.</p>
<p id="1acb" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">Whenever there’s an order issue or just a simple customer request of knowing their order status, this list will be helpful. But simply entering the unique order number or the unique customer number, they will fetch the details and provide support to the customer. This will lead to faster customer handling and giving them a quick and efficient user experience.</p>
<p id="682b" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">Even a Sales Manager who wants to get any details about an order or maybe a disputed order can get it from here.</p>

<p id="c2c9" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">As you can see, the screen will display a list of orders and the status, order date, required data, customer number, and shipped date (if any). So, when an admin or sales representative or customer success member wants to check the order details for a customer, he/she can easily do it using this screen. Once you click on order, a tray screen will display its details and the customer’s basic information.</p>
<p id="93d0" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">The new powerful and robust table grid control offers a quick filter option, which allows you to filter the orders according to the order status.</p>
<p id="7153" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">The process of displaying the orders’ list is similar to what we did until now. For the main table, we will use a LOOKUP() formula (shown in the image below).</p>
<p data-selectable-paragraph=""><img class=" wp-image-13966 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/15-300x169.png" alt="Binding data to the table grid" width="760" height="428" /></p>
<p id="497e" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">For adding the tray screen, we will use a similar method as done in step 2. You can even duplicate the Customer Details screen, and tweak the formulas accordingly.</p>
<p id="8be1" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">For example, for displaying the <strong class="ri hv">company name</strong>:</p>
<p id="7a80" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em>LOOKUP([Airtable_Customers.CompanyName] , Airtable_Customers.CustomerNumber = allorders.CustomerNumber)</em></strong></p>
<p id="392f" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><em>Where, “Airtable_Customers.CustomerNumber = allorders.CustomerNumber” is a filter used.</em></p>
<p id="ff72" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">And for <strong class="ri hv">order details</strong>:</p>
<p id="0bbf" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em>LOOKUP([Airtable_Orders_List.Product_Code,Airtable_Orders_List.Order_Quantity,Airtable_Orders_List.Price_Each] , Airtable_Orders_List.Order_Number = allorders.OrderNumber , Airtable_Orders_List.unique_id , “ASC”)</em></strong></p>
<p id="17b5" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><em>Where, “Airtable_Orders_List.Order_Number = allorders.OrderNumber” is a filter used, and Airtable_Orders_List.unique_id, “ASC” is the order of display, i.e. Ascending Order.</em></p>
<p id="ec44" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">Similarly, you can do all the fields that you want to be displayed when clicked on an order.</p>
<p data-selectable-paragraph=""><img class=" wp-image-13967 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/16-300x110.png" alt="Duplicate screen" width="532" height="195" /></p>
<p id="26b2" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong class="ri hv">NOTE: </strong>You can COPY SCREEN too, but it will only copy the UI and not the formulas.</p>

<h3><strong>Step 6: Employees’ Section</strong></h3>
<p id="4e91" class="yz za xp ri b zb abn zd ze zf abo zh zi zj abp zl zm zn abq zp zq zr abr zt zu zv vg bz" data-selectable-paragraph="">This screen displays a list of all the employees in the organization. A new employee who wants to know an email or contact number or even a phone extension number can quickly access this and carry on with their work, rather than spending time figuring out what he/she has to work due to lack of communication.</p>
<p id="450e" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">The formula for displaying all the list of the workforce:</p>
<p id="681b" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em>LOOKUP([Airtable_Employees.EmployeeNumber,Airtable_Employees.FirstName,Airtable_Employees.LastName,Airtable_Employees.JobTitle,Airtable_Employees.Email,Airtable_Employees.ReportingManager,Airtable_Employees.OfficeCode,Airtable_Employees.Extension],””,Airtable_Employees.EmployeeNumber,”ASC”)</em></strong></p>
<p id="2871" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><em>Where, Airtable_Employees.EmployeeNumber,”ASC” is the order of display, i.e. Ascending Order in terms of the employee number.</em></p>
<p data-selectable-paragraph=""><img class=" wp-image-13968 aligncenter" src="https://www.dronahq.com/wp-content/uploads/2021/04/234-300x171.png" alt="Employees’ Section" width="591" height="337" /></p>

<h2></h2>
<h3 id="e53e" class="zx zy xp bw fx zz aba zd sj abb abc zh sn abd abe abf sr abg abh abi sv abj abk abl sz abm bz"><strong>Building Admin Dashboard</strong></h3>
<p id="492d" class="yz za xp ri b zb abn zd ze zf abo zh zi zj abp zl zm zn abq zp zq zr abr zt zu zv vg bz" data-selectable-paragraph="">There are different reasons to create an Admin Dashboard. It is not generalized to one particular group of organizations or industries. Here are some:</p>

<ul class="">
 	<li id="d897" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv aca acb acc bz" data-selectable-paragraph="">Monitor the health of a business</li>
 	<li id="49f8" class="yz za xp ri b zb acd zd ze zf ace zh zi zj acf zl zm zn acg zp zq zr ach zt zu zv aca acb acc bz" data-selectable-paragraph="">Give a comprehensive view of all the data you need to make decisions on one good comprehensible screen.</li>
 	<li id="94b2" class="yz za xp ri b zb acd zd ze zf ace zh zi zj acf zl zm zn acg zp zq zr ach zt zu zv aca acb acc bz" data-selectable-paragraph="">Monitor the most crucial information about the monthly or yearly operations</li>
 	<li id="5705" class="yz za xp ri b zb acd zd ze zf ace zh zi zj acf zl zm zn acg zp zq zr ach zt zu zv aca acb acc bz" data-selectable-paragraph="">Ensure that the focus of all your workforce is on the same goal through viewing and using the same information to achieve targets</li>
</ul>
<p id="b0e8" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">For all the reasons stated above, the basic admin dashboard using Airtable integration will look something like this:</p>
[video width="1280" height="726" mp4="https://www.dronahq.com/wp-content/uploads/2021/04/Dashboard.mp4" loop="true" autoplay="true"][/video]
<p id="c86a" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">To break it down into 5 parts for easy understanding:</p>

<ol class="">
 	<li id="8384" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv aci acb acc bz" data-selectable-paragraph="">Number of orders of a particular status</li>
 	<li id="b6a9" class="yz za xp ri b zb acd zd ze zf ace zh zi zj acf zl zm zn acg zp zq zr ach zt zu zv aci acb acc bz" data-selectable-paragraph="">Line graph for displaying the number of sales in a particular year</li>
 	<li id="b2e3" class="yz za xp ri b zb acd zd ze zf ace zh zi zj acf zl zm zn acg zp zq zr ach zt zu zv aci acb acc bz" data-selectable-paragraph="">Pie chart depicting the number of products in each category</li>
 	<li id="5828" class="yz za xp ri b zb acd zd ze zf ace zh zi zj acf zl zm zn acg zp zq zr ach zt zu zv aci acb acc bz" data-selectable-paragraph="">Bar graph for the number of sales each sales rep has made</li>
 	<li id="44bb" class="yz za xp ri b zb acd zd ze zf ace zh zi zj acf zl zm zn acg zp zq zr ach zt zu zv aci acb acc bz" data-selectable-paragraph="">Detailed representation of the sales made by each sales representative</li>
</ol>
<h3 id="9f3d" class="acy zy xp bw fx acz aea aeb sj aec aed aee sn so aef sp sr ss aeg st sv sw aeh sx sz aei bz"><strong>Step 1: Order Status Details</strong></h3>
<img class=" wp-image-13972 alignright" src="https://www.dronahq.com/wp-content/uploads/2021/04/1234-209x300.png" alt="Order Status Details" width="268" height="385" />

To display a card about order status and the number of orders, we will use “Find Rows,” Airtable connectors.
<p id="bf6a" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">For finding orders which are <strong class="ri hv">“Shipped”</strong>:</p>
<p id="87af" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em>Airtable &gt; Find Rows &gt; Choose Account &gt; Give your connector a name (ex: FindShippedOrders) &gt; Choose the column which should be used to initiate the search (ex: Order Status) &gt; What value should be searched for (ex: Shipped) &gt; Add Base ID and Table Name (ex. Order Status) &gt; Task Name &gt; Finish</em></strong></p>
<p id="8f3f" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">The formula for displaying the fetched data, using MAPKEYS() and BINDAPI():</p>
<p id="d263" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em>MAPKEYS( BINDAPI( [FindAllShippedOrders.records.fields]) , “Order_Number:Order Number, Customer_Number:Customer Number, Order_Date:Order Date, Required_Date:Required Date, Shipped_Date:Shipped Date, Status:Status, Comments:Comments”)</em></strong></p>
<p id="c3a4" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><em>Where, “FindAllShippedOrders” is the connector name, and for the rest of the formula is mapping of variables.</em></p>
<p data-selectable-paragraph="">This process is similar to the one we used for finding the motorcycle category in the products list. And you can use a similar approach for the rest of the orders’ status.</p>

<h3 id="0ecd" class="acy zy xp bw fx acz aea aeb sj aec aed aee sn so aef sp sr ss aeg st sv sw aeh sx sz aei bz"><strong>Step 2: Yearly Sales Numbers Line Graph</strong></h3>
<img class="size-medium wp-image-13973 alignright" src="https://www.dronahq.com/wp-content/uploads/2021/04/yearly-sales-264x300.png" alt="Yearly Sales Numbers Line Graph" width="264" height="300" />
<p id="f056" class="yz za xp ri b zb abn zd ze zf abo zh zi zj abp zl zm zn abq zp zq zr abr zt zu zv vg bz" data-selectable-paragraph="">The yearly sales line graph is handy for the admins to understand their market growth. Based on the monthly/annual sales numbers, they can strategize their marketing efforts and plans to the month/year which</p>
contributed the most.
<p id="b0c7" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">This control is straightforward to use. For this app, I used two quantities: Month and Monthly Sales. The formula to use this control is a simple LOOK() formula.</p>
<p id="8e5b" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">The working of the formula is such that it compares the chosen year value with the year in the Sheet, and displays the data accordingly.</p>
<p id="9ed3" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em>LOOKUP([Airtable_Yearly_Orders.Month,Airtable_Yearly_Orders.NumberOfOrders],Airtable_Yearly_Orders.Year = chooseyear,Airtable_Yearly_Orders.Month_Number,”ASC”)</em></strong></p>
<p id="34d8" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><em>Where, “Airtable_Yearly_Orders.Year = chooseyear” is a filter used, and Airtable_Yearly_Orders.Month_Number, “ASC” is the order of display, i.e. Ascending Order, according to the month.</em></p>
<p data-selectable-paragraph="">To understand more about how to use a line graph, read more <a class="az ej" href="https://community.dronahq.com/t/line-graph-control/210" rel="noopener nofollow">here</a>.</p>

<h3 id="fb43" class="acy zy xp bw fx acz aea aeb sj aec aed aee sn so aef sp sr ss aeg st sv sw aeh sx sz aei bz"><strong>Step 3: Category-wise Products Division Pie Chart <img class="size-medium wp-image-13975 alignright" src="https://www.dronahq.com/wp-content/uploads/2021/04/2021-04-22-1-288x300.png" alt="Category-wise Products Division Pie Chart" width="288" height="300" /></strong></h3>
The admin can view product division, which will help him/her for further decision-making processes like adding new products to the list, which are less in number, and more.
<p id="5ab4" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">The formula to use this control is a simple LOOKUP() formula:</p>
<p id="cae4" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em>LOOKUP([Airtable_Product_Types.ProductType,Airtable_Product_Types.Total_Quantity])</em></strong></p>
<p id="f529" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">To understand more about how to use a pie chart, read more <a class="az ej" href="https://community.dronahq.com/t/pie-chart-control/213" rel="noopener nofollow">here</a>.</p>

<h3 id="6465" class="acy zy xp bw fx acz aea aeb sj aec aed aee sn so aef sp sr ss aeg st sv sw aeh sx sz aei bz"><strong>Step 4: Sales Numbers of each SDR Bar Graph</strong></h3>
<img class="size-medium wp-image-13977 alignright" src="https://www.dronahq.com/wp-content/uploads/2021/04/2021-04-22-285x300.png" alt="Sales Numbers of each SDR Bar Graph" width="285" height="300" />
<p class="yz za xp ri b zb abn zd ze zf abo zh zi zj abp zl zm zn abq zp zq zr abr zt zu zv vg bz" data-selectable-paragraph="">A Sales Manager must know which of his/her team members are performing well and which are not. This feature will help the manager make decisions like giving appraisals to the best SDR and training those who are not doing well.</p>
<p id="b50a" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">More additions to this can be using a monthly or yearly filter (similar to step 2) and can view SDRs’ monthly or annual performance.</p>
<p id="0a31" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">Giving this holistic view will also help a newly hired executive to understand the picture.</p>
<p id="9b4d" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">For this app, I used two quantities: The name of the SDR (you can use their employee number or email) and the number of sales done. The formula to use this control is a simple LOOK() formula:</p>
<p id="44c7" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em class="xp">LOOKUP([Airtable_SDR_Sales.SDR_Name,Airtable_SDR_Sales.Number_Of_Sales],””,Airtable_SDR_Sales.SDR_Employee_Number,”ASC”)</em></strong></p>
<p id="115b" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">To understand more about how to use a bar graph, read more <a class="az ej" href="https://community.dronahq.com/t/bar-graph-control/212" rel="noopener nofollow">here</a>.</p>

<h3 class="acy zy xp bw fx acz aea aeb sj aec aed aee sn so aef sp sr ss aeg st sv sw aeh sx sz aei bz"><strong class="bf">Step 5: Detailed sales view of each SDR using dropdown and table grid control</strong></h3>
<h3 id="6465" class="acy zy xp bw fx acz aea aeb sj aec aed aee sn so aef sp sr ss aeg st sv sw aeh sx sz aei bz"><strong><img class=" wp-image-13976 alignright" src="https://www.dronahq.com/wp-content/uploads/2021/04/sdr-detailed-236x300.png" alt="Detailed sales view of each SDR using dropdown and table grid control" width="282" height="358" /></strong></h3>
<p class="yz za xp ri b zb abn zd ze zf abo zh zi zj abp zl zm zn abq zp zq zr abr zt zu zv vg bz" data-selectable-paragraph="">This part of the dashboard can be of great use for Admins, Sales Managers, and more.</p>
<p id="1544" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">The dropdown menu will allow them to choose an SDR to view his/her performance. Depending on the chosen SDR, the table grid control will display all the orders associated with the particular SDR (in short, it will show the sales done by that sales rep).</p>
<p id="d2f9" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">Further, clicking on any one order will show a detailed view of the order, like products sold, the quantity of the product, and the price of each.</p>
<p id="8275" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">So even if a newly hired executive is looking through it, he/she will understand the whole picture of the orders, starting from the order date, order status, and if there are any complications in that.</p>
<p id="73b2" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">The formula used in the table grid is:</p>
<p id="c62c" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><strong><em>LOOKUP([Airtable_Customers.CustomerNumber,Airtable_Customers.CompanyName,Airtable_Customers.FirstName,Airtable_Customers.LastName,Airtable_Customers.Country] , Airtable_Customers.SalesRepEmployeeNumber = chooseansdr , Airtable_Customers.CustomerNumber , “ASC”)</em></strong></p>
<p id="d2c2" class="yz za zw ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph=""><em>Where, “Airtable_Customers.SalesRepEmployeeNumber = chooseansdr” is a filter used, “chooseansdr” is the unique name of the dropdown, and Airtable_Customers.CustomerNumber, “ASC” is the order of display, i.e. Ascending Order, according to the month.</em></p>
<p id="3b9a" class="yz za xp ri b zb abn zd ze zf abo zh zi zj abp zl zm zn abq zp zq zr abr zt zu zv vg bz" data-selectable-paragraph="">The custom internal tools you build in DronaHQ can be configured so that you can do much more with your Airtable data. In the Airtable admin panel we just built, you can also -</p>

<ol>
 	<li id="a8b1" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv aca acb acc bz" data-selectable-paragraph="">Integrate the tool with other services like Stripe for payment management, or Gmail to send out transaction update emails or send invoices</li>
 	<li data-selectable-paragraph="">Only grant access to specific users or roles. Say you only want the managers to see this admin tool and have edit rights.</li>
 	<li data-selectable-paragraph="">Set up multiple views for the Airtable data</li>
 	<li data-selectable-paragraph="">Update order status. Add, update, or delete Products</li>
 	<li id="9a59" class="yz za xp ri b zb acd zd ze zf ace zh zi zj acf zl zm zn acg zp zq zr ach zt zu zv aca acb acc bz" data-selectable-paragraph="">Use a a form to add new arrivals of the products, something like managing the product/stock inventory</li>
 	<li id="0a87" class="yz za xp ri b zb acd zd ze zf ace zh zi zj acf zl zm zn acg zp zq zr ach zt zu zv aca acb acc bz" data-selectable-paragraph="">Add discounts or other promotional offers to the products</li>
</ol>
<p id="c9ec" class="yz za xp ri b zb zc zd ze zf zg zh zi zj zk zl zm zn zo zp zq zr zs zt zu zv vg bz" data-selectable-paragraph="">and so much more.</p>


<p data-selectable-paragraph=""><a href="https://www.dronahq.com/signup/"><img class="alignnone size-large wp-image-15695" src="https://www.dronahq.com/wp-content/uploads/2021/05/stitch-data-together-1024x256.png" alt="stitch data together" width="1024" height="256" /></a></p>