Sometimes you want to share your spreadsheets with your colleagues, customers or with the world. With Publishing, you can easily transform your spreadsheet into forms, dashboards and shared web apps that anyone can use.
Publishing a spreadsheet
Let’s imagine you built a stock tracker and want to transform it into an app for your team to use.
First, we added a few interactive elements. We’ve turned A2 into an input field and B2 into a button. You will need to add these action elements so that other people can use your app.
To publish the spreadsheet as a web app, simply go to the globe icon on the sidebar and select which views to publish. You can choose to publish a view as private, shared or hidden.
Inside a published view your audience can use the input fields, buttons, or checkboxes you added to the spreadsheet.
Private views are used when you want your users to use their app independently from others.
These are great for forms or calculators, as in this mode each user will only see the changes he/she did to the published spreadsheet. In the case of our stock tracker we want each user to only see the prices for the company he selected, so we will publish it as a private view.
Private views do not support automations (REPEAT and REFRESH). You can always update the base spreadsheet inside the dashdash editor and users will see the updated version of the private view when they refresh the page.
Shared views are used when you want everyone to be looking at the same data.
These are great for team dashboards, shared lists of action items and tools where you want your users to collaborate. In these views, any change done in the spreadsheet editor or in the published spreadsheet will be seen by every user immediately.
In this example, we can see a shared project to-do list. Whenever one user updates the status of one task, it is automatically shared with all other users of the app.
Back to our stock tracker
In our case, we will publish the live tracker as a private view and will keep the over view hidden for later.
Just click “PUBLISH AS APP” and voilá, your app is now live. Copy the app link from your clipboard to a new browser tab and start using your app. No formulas, cells and other spreadsheety things
Insert data from a private view to another view
Adding data from a form to a log is also pretty easy. To do it, you will need a private view (the form) and a hidden view (the log). You cannot send data from a shared view into a private view.
Then, we’ll just add a formula to the published view that, whenever the button is clicked, it sends the ticker and price to table inside our log view. We use the INSERT function to add this logic to our spreadsheet.
Now, our log will always collect the data coming from the form.
That is it! With Publishing, you can create custom web applications only using your spreadsheet skills. Pretty wild.
We can’t wait to hear what you build ,