{"id":3293,"date":"2024-07-10T13:02:54","date_gmt":"2024-07-10T05:02:54","guid":{"rendered":"https:\/\/five.co\/?p=3293"},"modified":"2024-07-12T08:36:00","modified_gmt":"2024-07-12T00:36:00","slug":"how-to-build-a-frontend-for-google-sheets","status":"publish","type":"post","link":"https:\/\/preview-php85.dzine.org\/five\/blog\/how-to-build-a-frontend-for-google-sheets\/","title":{"rendered":"How to Build a Frontend for Google Sheets\u00a0(Fast &#038; Easy)"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">How to Build a Google Sheets Frontend: Step-by-Step Guide<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Are you looking to turn your Google Sheet into a dynamic web frontend? This beginner-friendly tutorial will guide you through the process of converting a Google Sheet into a frontend using Five. No coding experience required!<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n<div class=\"root-eb-toc-4yd8a wp-block-essential-blocks-table-of-contents\"><div class=\"eb-parent-wrapper eb-parent-eb-toc-4yd8a \"><div class=\"eb-toc-container eb-toc-4yd8a  eb-toc-is-not-sticky eb-toc-not-collapsible eb-toc-initially-not-collapsed eb-toc-scrollToTop style-1 list-style-none\" data-scroll-top=\"false\" data-scroll-top-icon=\"fas fa-angle-up\" data-collapsible=\"false\" data-sticky-hide-mobile=\"false\" data-sticky=\"false\" data-scroll-target=\"scroll_to_toc\" data-copy-link=\"false\" data-editor-type=\"\" data-hide-desktop=\"false\" data-hide-tab=\"false\" data-hide-mobile=\"false\" data-itemcollapsed=\"false\" data-highlight-scroll=\"false\"><div class=\"eb-toc-header\"><h2 class=\"eb-toc-title\">Table of Contents<\/h2><\/div><div class=\"eb-toc-wrapper \" data-headers=\"[{&quot;level&quot;:2,&quot;content&quot;:&quot;How to Build a Google Sheets Frontend: Step-by-Step Guide&quot;,&quot;text&quot;:&quot;How to Build a Google Sheets Frontend: Step-by-Step Guide&quot;,&quot;link&quot;:&quot;how-to-build-a-google-sheets-frontend-step-by-step-guide&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Step 1: Clean Up Your Spreadsheet&quot;,&quot;text&quot;:&quot;Step 1: Clean Up Your Spreadsheet&quot;,&quot;link&quot;:&quot;step-1-clean-up-your-spreadsheet&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Organize Your Google Sheets Data&quot;,&quot;text&quot;:&quot;Organize Your Google Sheets Data&quot;,&quot;link&quot;:&quot;organize-your-google-sheets-data&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Clean Your Data&quot;,&quot;text&quot;:&quot;Clean Your Data&quot;,&quot;link&quot;:&quot;clean-your-data&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Step 2: Setting Up Your Database and Importing Data&quot;,&quot;text&quot;:&quot;Step 2: Setting Up Your Database and Importing Data&quot;,&quot;link&quot;:&quot;step-2-setting-up-your-database-and-importing-data&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Create a New Application in Five&quot;,&quot;text&quot;:&quot;Create a New Application in Five&quot;,&quot;link&quot;:&quot;create-a-new-application-in-five&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Create Your Database and Import Data&quot;,&quot;text&quot;:&quot;Create Your Database and Import Data&quot;,&quot;link&quot;:&quot;create-your-database-and-import-data&quot;},{&quot;level&quot;:4,&quot;content&quot;:&quot;Creating Your Database Table&quot;,&quot;text&quot;:&quot;Creating Your Database Table&quot;,&quot;link&quot;:&quot;creating-your-database-table&quot;},{&quot;level&quot;:4,&quot;content&quot;:&quot;Importing Data from Google Sheets&quot;,&quot;text&quot;:&quot;Importing Data from Google Sheets&quot;,&quot;link&quot;:&quot;importing-data-from-google-sheets&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Step 3: Adding a Form and Previewing Your Frontend&quot;,&quot;text&quot;:&quot;Step 3: Adding a Form and Previewing Your Frontend&quot;,&quot;link&quot;:&quot;step-3-adding-a-form-and-previewing-your-frontend&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Adding a Form&quot;,&quot;text&quot;:&quot;Adding a Form&quot;,&quot;link&quot;:&quot;adding-a-form&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Preview Your Frontend&quot;,&quot;text&quot;:&quot;Preview Your Frontend&quot;,&quot;link&quot;:&quot;preview-your-frontend&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;What Your Frontend Application Includes&quot;,&quot;text&quot;:&quot;What Your Frontend Application Includes&quot;,&quot;link&quot;:&quot;what-your-frontend-application-includes&quot;},{&quot;level&quot;:2,&quot;content&quot;:&quot;Next Steps: Build a Frontend for Google Sheets&quot;,&quot;text&quot;:&quot;Next Steps: Build a Frontend for Google Sheets&quot;,&quot;link&quot;:&quot;next-steps-build-a-frontend-for-google-sheets&quot;},{&quot;level&quot;:3,&quot;content&quot;:&quot;Resources for Further Development&quot;,&quot;text&quot;:&quot;Resources for Further Development&quot;,&quot;link&quot;:&quot;resources-for-further-development&quot;}]\" data-visible=\"[true,true,true,true,true,true]\" data-delete-headers=\"[{&quot;label&quot;:&quot;How to Build a Google Sheets Frontend: Step-by-Step Guide&quot;,&quot;value&quot;:&quot;how-to-build-a-google-sheets-frontend-step-by-step-guide&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 1: Clean Up Your Spreadsheet&quot;,&quot;value&quot;:&quot;step-1-clean-up-your-spreadsheet&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Organize Your Google Sheets Data&quot;,&quot;value&quot;:&quot;organize-your-google-sheets-data&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Clean Your Data&quot;,&quot;value&quot;:&quot;clean-your-data&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Step 2: Setting Up Your Database and Importing Data&quot;,&quot;value&quot;:&quot;step-2-setting-up-your-database-and-importing-data&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Create a New Application in Five&quot;,&quot;value&quot;:&quot;create-a-new-application-in-five&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Create Your Database and Import Data&quot;,&quot;value&quot;:&quot;create-your-database-and-import-data&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Creating Your Database Table&quot;,&quot;value&quot;:&quot;creating-your-database-table&quot;,&quot;isDelete&quot;:true},{&quot;label&quot;:&quot;Importing Data from Google Sheets&quot;,&quot;value&quot;:&quot;importing-data-from-google-sheets&quot;,&quot;isDelete&quot;:true},{&quot;label&quot;:&quot;Step 3: Adding a Form and Previewing Your Frontend&quot;,&quot;value&quot;:&quot;step-3-adding-a-form-and-previewing-your-frontend&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Adding a Form&quot;,&quot;value&quot;:&quot;adding-a-form&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Preview Your Frontend&quot;,&quot;value&quot;:&quot;preview-your-frontend&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;What Your Frontend Application Includes&quot;,&quot;value&quot;:&quot;what-your-frontend-application-includes&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Next Steps: Build a Frontend for Google Sheets&quot;,&quot;value&quot;:&quot;next-steps-build-a-frontend-for-google-sheets&quot;,&quot;isDelete&quot;:false},{&quot;label&quot;:&quot;Resources for Further Development&quot;,&quot;value&quot;:&quot;resources-for-further-development&quot;,&quot;isDelete&quot;:false}]\" data-smooth=\"true\" data-top-offset=\"\"><div class=\"eb-toc__list-wrap\"><ul class=\"eb-toc__list\"><li><a href=\"#how-to-build-a-google-sheets-frontend-step-by-step-guide\">How to Build a Google Sheets Frontend: Step-by-Step Guide<\/a><li><a href=\"#step-1-clean-up-your-spreadsheet\">Step 1: Clean Up Your Spreadsheet<\/a><ul class=\"eb-toc__list\"><li><a href=\"#organize-your-google-sheets-data\">Organize Your Google Sheets Data<\/a><li><a href=\"#clean-your-data\">Clean Your Data<\/a><\/li><\/ul><li><a href=\"#step-2-setting-up-your-database-and-importing-data\">Step 2: Setting Up Your Database and Importing Data<\/a><ul class=\"eb-toc__list\"><li><a href=\"#create-a-new-application-in-five\">Create a New Application in Five<\/a><li><a href=\"#create-your-database-and-import-data\">Create Your Database and Import Data<\/a><\/li><\/ul><li><a href=\"#step-3-adding-a-form-and-previewing-your-frontend\">Step 3: Adding a Form and Previewing Your Frontend<\/a><ul class=\"eb-toc__list\"><li><a href=\"#adding-a-form\">Adding a Form<\/a><li><a href=\"#preview-your-frontend\">Preview Your Frontend<\/a><li><a href=\"#what-your-frontend-application-includes\">What Your Frontend Application Includes<\/a><\/li><\/ul><li><a href=\"#next-steps-build-a-frontend-for-google-sheets\">Next Steps: Build a Frontend for Google Sheets<\/a><ul class=\"eb-toc__list\"><li><a href=\"#resources-for-further-development\">Resources for Further Development<\/a><\/li><\/ul><\/ul><\/div><\/div><\/div><\/div><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Step 1: Clean Up Your Spreadsheet<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before we can build a Google Sheets Frontend, your data must be organized correctly. Proper data formatting is essential for a smooth transition.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Organize Your Google Sheets Data<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Descriptive Headers<\/strong> Make sure the first row of your Google Sheet contains clear and descriptive names for each column. For example: <\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Product<\/th><th>Price<\/th><th>Quantity<\/th><\/tr><\/thead><tbody><tr><td>Product 1<\/td><td>4.99<\/td><td>100<\/td><\/tr><tr><td>Product 2<\/td><td>5.99<\/td><td>4<\/td><\/tr><tr><td>Product 3<\/td><td>100.99<\/td><td>58<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Avoid Redundancy<\/strong> Do not repeat the same type of information in multiple columns. For instance, instead of having separate columns for &#8220;Products (non-perishable)&#8221; and &#8220;Products (perishable)&#8221;, use a single &#8220;Product&#8221; column and another column to classify them as &#8220;Perishable&#8221; or &#8220;Non-Perishable&#8221;.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Product<\/th><th>Price<\/th><th>Quantity<\/th><th>Type<\/th><\/tr><\/thead><tbody><tr><td>Product 1<\/td><td>4.99<\/td><td>100<\/td><td>Non-Perishable<\/td><\/tr><tr><td>Product 2<\/td><td>5.99<\/td><td>4<\/td><td>Perishable<\/td><\/tr><tr><td>Product 3<\/td><td>100.99<\/td><td>58<\/td><td>Non-Perishable<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Single Data Entries per Cell<\/strong> Each cell should contain only one piece of data. Avoid combining data points like &#8220;5.99 (discounted to 4.99)&#8221; in a single cell. Instead, use separate columns for price and discount information.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Product<\/th><th>Price<\/th><th>Discounted Price<\/th><\/tr><\/thead><tbody><tr><td>Product 1<\/td><td>5.99<\/td><td>4.99<\/td><\/tr><tr><td>Product 2<\/td><td>7.99<\/td><td>6.99<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Separate Multiple Values<\/strong> If you have multiple values of the same type, such as multiple email addresses for a customer, create separate columns for each, like &#8220;Primary Email&#8221; and &#8220;Secondary Email&#8221;.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Customer<\/th><th>Primary Email<\/th><th>Secondary Email<\/th><\/tr><\/thead><tbody><tr><td>John Doe<\/td><td>john@example.com<\/td><td>john.doe@example.com<\/td><\/tr><tr><td>Jane Smith<\/td><td>jane@example.com<\/td><td>jane.smith@example.com<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Clean Your Data<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Here are some useful Google Sheets functions to ensure your data is clean:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>TRIM Function<\/strong>: Removes extra spaces from text. Useful for correcting formatting issues like merged or improperly spaced words.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#abb2bf;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#282c34\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"  =TRIM(A1)\" style=\"color:#abb2bf;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki one-dark-pro\" style=\"background-color: #282c34\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #56B6C2\">=<\/span><span style=\"color: #56B6C2\">TRIM<\/span><span style=\"color: #ABB2BF\">(A1)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>CLEAN Function<\/strong>: Removes all non-printable characters from text. Useful for cleaning up pasted data with special characters.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#abb2bf;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#282c34\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"  =CLEAN(A1)\" style=\"color:#abb2bf;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki one-dark-pro\" style=\"background-color: #282c34\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #56B6C2\">=<\/span><span style=\"color: #ABB2BF\">CLEAN(A1)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>PROPER Function<\/strong>: Converts the first character of each word to uppercase and the rest to lowercase.<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro cbp-has-line-numbers\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.875rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;--cbp-line-number-color:#abb2bf;--cbp-line-number-width:calc(1 * 0.6 * .875rem);line-height:1.25rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#282c34\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" data-code=\"  =PROPER(A1)\" style=\"color:#abb2bf;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki one-dark-pro\" style=\"background-color: #282c34\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #ABB2BF\">  <\/span><span style=\"color: #56B6C2\">=<\/span><span style=\"color: #ABB2BF\">PROPER(A1)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">By following these steps, your Google Sheet will be well-prepared for conversion into a frontend. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ready to move forward?<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Step 2: Setting Up Your Database and Importing Data<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Creating a robust backend with a <a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/what-is-mysql\/\">MySQL<\/a> database is crucial for converting Google Sheets into a frontend. MySQL is a reliable and popular open-source database, and Five offers an easy-to-use visual interface for managing it.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Create a New Application in Five<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">First, ensure you have free access to Five . Follow these steps to create a new application:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Launch Five.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"649\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Landing-Page-1024x649-2-1.png\" alt=\"\" class=\"wp-image-3297\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Landing-Page-1024x649-2-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Landing-Page-1024x649-2-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Landing-Page-1024x649-2-1-768x487.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Navigate to &#8220;Applications&#8221; near the top left corner of the screen, just below the hamburger menu icon.<\/li>\n\n\n\n<li>Click the yellow Plus icon. A &#8220;New Applications Record&#8221; window will appear.<\/li>\n\n\n\n<li>Enter a title for your application, such as &#8220;My First App&#8221;.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"648\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/image-16-1024x648-1.png\" alt=\"\" class=\"wp-image-3298\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/image-16-1024x648-1.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/image-16-1024x648-1-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/image-16-1024x648-1-768x486.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Save your new application by clicking the Tick Mark in the top right corner.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Your screen should now show your new application listed on the left side.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Create Your Database and Import Data<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">With your application set up, it\u2019s time to build your database and import your data from Google Sheets.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Creating Your Database Table<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click the blue Manage button at the top right of the screen near the Five logo.<\/li>\n\n\n\n<li>Navigate to &#8220;Data&#8221; and then select &#8220;Table Wizard&#8221;.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"649\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Table-Wizard-1024x649-5.png\" alt=\"\" class=\"wp-image-3299\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Table-Wizard-1024x649-5.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Table-Wizard-1024x649-5-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Table-Wizard-1024x649-5-768x487.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Name your table &#8220;Inventory&#8221;.<\/li>\n\n\n\n<li>Click the Plus icon on the right side of the screen three times to add three fields:<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Field 1<\/strong>: Name it &#8220;Product&#8221;, select &#8220;text&#8221; as the data type, and set the size to 100.<\/li>\n\n\n\n<li><strong>Field 2<\/strong>: Name it &#8220;Price&#8221;, select &#8220;float&#8221; as the data type, and choose &#8220;float.2&#8221; for the display type.<\/li>\n\n\n\n<li><strong>Field 3<\/strong>: Name it &#8220;Quantity&#8221;, select &#8220;integer&#8221; for both the data and display type.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"627\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Create-a-Table-with-the-Table-Wizard-1024x627-2.png\" alt=\"\" class=\"wp-image-3300\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Create-a-Table-with-the-Table-Wizard-1024x627-2.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Create-a-Table-with-the-Table-Wizard-1024x627-2-300x184.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Create-a-Table-with-the-Table-Wizard-1024x627-2-768x470.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Save your table by clicking the Tick mark.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\">Importing Data from Google Sheets<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ensure your data is stored in a CSV file. If you don\u2019t have one, <a href=\"https:\/\/preview-php85.dzine.org\/five\/download\/source\/Inventory.csv\">you can download an example Inventory CSV file.<\/a><\/li>\n\n\n\n<li>Go to Data &gt; Tables and click the Import CSV into Table icon (located to the left of the yellow plus icon with a small arrow pointing down into a box).<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Data-Import-1024x650-4.png\" alt=\"\" class=\"wp-image-3301\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Data-Import-1024x650-4.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Data-Import-1024x650-4-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Data-Import-1024x650-4-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Select your Inventory table from the dropdown box.<\/li>\n\n\n\n<li>Click on Choose File and locate your Inventory.csv file. Upload it.<\/li>\n\n\n\n<li>Five will automatically map the fields from your CSV file to the corresponding database fields, assuming the field names match.<\/li>\n\n\n\n<li>For InventoryKey, select Generated to let Five create a unique primary key for each record.<\/li>\n\n\n\n<li>Click the Tick mark to complete the upload.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"932\" height=\"594\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Mapping-a-CSV-to-your-database.png\" alt=\"\" class=\"wp-image-3302\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Mapping-a-CSV-to-your-database.png 932w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Mapping-a-CSV-to-your-database-300x191.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Mapping-a-CSV-to-your-database-768x489.png 768w\" sizes=\"(max-width: 932px) 100vw, 932px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Congratulations! You&#8217;ve successfully created a MySQL database table and populated it with data from your Google Sheet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the next step, we will add a form to your application and launch it for a preview. <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Step 3: Adding a Form and Previewing Your Frontend<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">We\u2019ve already set up our database with a table for products, prices, and quantities. Now, it&#8217;s time to build a frontend so users can easily interact with this data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Adding a Form<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Five simplifies the process of building forms for end-users. Follow these steps to create your form:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on &#8220;Visual&#8221; in the top menu and then select &#8220;Form Wizard&#8221;.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Form-Wizard-1024x650-8.png\" alt=\"\" class=\"wp-image-3303\" style=\"width:840px;height:auto\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Form-Wizard-1024x650-8.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Form-Wizard-1024x650-8-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Form-Wizard-1024x650-8-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>In the Form Wizard, select &#8220;Inventory&#8221; as your main table.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img width=\"1024\" height=\"656\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Form-Wizard-Creating-a-form-1024x656-5.png\" alt=\"\" class=\"wp-image-3304\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Form-Wizard-Creating-a-form-1024x656-5.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Form-Wizard-Creating-a-form-1024x656-5-300x192.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-Form-Wizard-Creating-a-form-1024x656-5-768x492.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>Save your form by clicking the Tick mark.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Preview Your Frontend<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">With the form created, it&#8217;s time to preview your google sheets frontend:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click the &#8220;Run&#8221; button at the top right corner. This will open your application in a new window.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img width=\"1024\" height=\"652\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/image-24-1024x652-3.png\" alt=\"\" class=\"wp-image-3305\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/image-24-1024x652-3.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/image-24-1024x652-3-300x191.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/image-24-1024x652-3-768x489.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">What Your Frontend Application Includes<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">After launching, you will see a fully auto-generated front-end, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Menu<\/strong>: A navigation menu on the left side.<\/li>\n\n\n\n<li><strong>Search Bar<\/strong>: Located at the top for quick data searches.<\/li>\n\n\n\n<li><strong>Filter<\/strong>: Next to the search bar for refining your data view.<\/li>\n\n\n\n<li><strong>Data Management<\/strong>: The ability to add, edit, or delete records directly through the GUI.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img width=\"1024\" height=\"650\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/image-25-1024x650-2.png\" alt=\"\" class=\"wp-image-3306\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/image-25-1024x650-2.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/image-25-1024x650-2-300x190.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/image-25-1024x650-2-768x488.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Congratulations! You&#8217;ve just created the first prototype of your web frontend, turning your Google Sheet into a searchable online database.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Next Steps: Build a Frontend for Google Sheets<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Now that your application is up and running, let&#8217;s explore further enhancements and customizations:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Add Calculations<\/strong>: Learn how to add <a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/add-a-calculation-to-your-web-app\/\">calculations to your forms<\/a>, such as computing the total field in your form.<\/li>\n\n\n\n<li><strong>Customize the Design<\/strong>: <a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/make-your-application-look-good-themes\/\">Add a theme<\/a> to your application to make it look professional and unique.<\/li>\n\n\n\n<li><strong>Implement User Authentication<\/strong>:<a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/how-to-make-a-multiuser-app-in-2-steps\/\"> Add a login screen and terms &amp; conditions<\/a> consent to manage user access and permissions.<\/li>\n\n\n\n<li><strong>Create Charts and Dashboards<\/strong>: Incorporate analytics and business intelligence features for <a href=\"https:\/\/preview-php85.dzine.org\/five\/blog\/charts-dashboards\/\">data visualization.<\/a><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img width=\"1024\" height=\"576\" src=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-SQL-Dashboard-3-1024x576.png\" alt=\"\" class=\"wp-image-3307\" srcset=\"https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-SQL-Dashboard-3-1024x576.png 1024w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-SQL-Dashboard-3-300x169.png 300w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-SQL-Dashboard-3-768x432.png 768w, https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-SQL-Dashboard-3.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">Resources for Further Development<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you need help or inspiration while developing your application, here are some useful resources:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Five\u2019s User Community<\/strong>: Visit <a href=\"https:\/\/five.org\" rel=\"nofollow noopener\" target=\"_blank\">Five\u2019s User Community<\/a> to ask questions or get ideas from other users.<\/li>\n\n\n\n<li><strong>Five\u2019s Documentation<\/strong>: Access <a href=\"https:\/\/help.five.org\" rel=\"nofollow noopener\" target=\"_blank\">Five\u2019s comprehensive documentation<\/a> for detailed guides and information.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>How to Build a Google Sheets Frontend: Step-by-Step Guide Are you looking to turn your Google Sheet into a dynamic web frontend? This beginner-friendly tutorial will guide you through the process of converting a Google Sheet into a frontend using Five. No coding experience required! Step 1: Clean Up Your Spreadsheet Before we can build [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":3308,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","_uag_custom_page_level_css":"","footnotes":""},"categories":[21],"tags":[],"class_list":["post-3293","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog"],"acf":[],"uagb_featured_image_src":{"full":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Frontend-for-Google-Sheets.png",1280,720,false],"thumbnail":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Frontend-for-Google-Sheets-150x150.png",150,150,true],"medium":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Frontend-for-Google-Sheets-300x169.png",300,169,true],"medium_large":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Frontend-for-Google-Sheets-768x432.png",768,432,true],"large":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Frontend-for-Google-Sheets-1024x576.png",1024,576,true],"1536x1536":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Frontend-for-Google-Sheets.png",1280,720,false],"2048x2048":["https:\/\/preview-php85.dzine.org\/five\/wp-content\/uploads\/2024\/07\/Five.Co-How-to-Build-a-Frontend-for-Google-Sheets.png",1280,720,false]},"uagb_author_info":{"display_name":"Ryan Forrester","author_link":"https:\/\/preview-php85.dzine.org\/five\/author\/f1v5_ed9_au\/"},"uagb_comment_info":0,"uagb_excerpt":"How to Build a Google Sheets Frontend: Step-by-Step Guide Are you looking to turn your Google Sheet into a dynamic web frontend? This beginner-friendly tutorial will guide you through the process of converting a Google Sheet into a frontend using Five. No coding experience required! Step 1: Clean Up Your Spreadsheet Before we can build&hellip;","_links":{"self":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts\/3293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/comments?post=3293"}],"version-history":[{"count":0,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/posts\/3293\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/media\/3308"}],"wp:attachment":[{"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/media?parent=3293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/categories?post=3293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/preview-php85.dzine.org\/five\/wp-json\/wp\/v2\/tags?post=3293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}