<img height="1" width="1" src="https://www.facebook.com/tr?id=1824058264555430&amp;ev=PageView &amp;noscript=1">
Subscribe to Our Blog Stay up to date with the latest tips and news.
Filter By:
Sort By:

One App, Many Uses! How to Make an App to Manage Questions Asked in Webinars, Conferences, and Training Sessions

I bet you’re reading this post because whatever profession you are (marketing operations manager, conference organizer, learning and development specialist, teacher, HR manager, etc.), you have one thing in common: the need to effectively communicate. As a marketing manager, I am faced with the same issue. I am communicating all the time about all kinds of things and staying organized is key. Believe it or not, an app can help you with that! In this post, I will show you how to make a communications app. Full disclosure: For those who are new to AppSheet, this app was originally made by Santiago Uribe, AppSheet’s VP of Product. We use this app every Thursday to manage the many questions we get during our wildly successful Ask Office Hours webinars (register here). As with most of the apps we create, this app can be customized to do all sorts of things. Read on to learn about the app and how you can copy and customize it to make it your own. With AppSheet’s Webinar app, you can do the following: Submit questions Manage questions Answer questions Here is how these functions relate to some other communication scenarios: Communication Type Who Submits Questions Who Manages/Answers Questions Sample Question Topics Webinar Attendees, (prospects,  current customers, etc.) Speakers (product marketing managers, sales managers, etc.) Product, company, pricing, etc. Conference Attendees Speakers, panelists, conference organizers, panelist moderators Any question on a keynote, session or panel Training Session Attendees Trainers across any number of functions (like employee or customer onboarding) A concept, an example or suggestions on topics for future sessions. Education Students Teachers, Teaching Assistants An exam, an assignment, a class. Corporate Internal Communication Employees CEOs, Executives, Managers, HR Corporate strategy, product plan, compensation. How to Submit Questions In this app, the Post View (shown below) is how questions are submitted. Keep in mind that you want people to ask questions. So any question submission form must be as simple as possible. Besides Name, Question and Publish, I also include the Question Topic field so that I can monitor the most popular topic categories. How to Manage Questions In this app, the Moderate View is the screen where questions are managed. Of course, attendees don’t need to see this view as it’s meant for the organizer who is tasked with moderating duties. As a result, you will have to grant access permission to those users you want to see this view. To grant permission, go to UX→ Views→ Show If. For example: CONTAINS(USEREMAIL(),"@1track.com") means only people whose email contains @1track.com can see this view. This view organizes questions by the time they were posted and shows the number of votes each question received, whether it was published or not, and the actual question. When clicking on an unpublished question, moderators can take the following actions: publish the question, mark it as answered, or highlight or tweet the question. How to Answer Questions The Question Dashboard View is a dashboard view of all published questions, displaying the question, submitter first name and topic. Just like the Moderate View, you can grant access permissions to see it in UX→ Views→ Show If. That way only certain people can see this View and take action on individual questions. The Question Dashboard View display is dependent on the device you’re using. In a web browser on your laptop or workstation, whenever you click on a question, you will see Available Questions and the Question Details View side by side. On a tablet, whenever you click on a question, you will see Available Questions on the top and Question Details on the bottom. What about Pending Questions? The Pending View displays all published but unanswered questions and enables the audience to vote and comment on questions asked by other people. There are other app customizations you may want to include, such as: Video View: Link questions answered to relevant videos. Topic View: Use a chart to show what topics are the most popular. Feedback View: Ask the audience to submit feedback after the webinar. Notification: Send an SMS or email to the appropriate person when their question is answered. Geo-fencing: Limit questions to people in a specific location. There are lots of other things you can do with this app. Visit AppSheet’s  Sample App page, Support page and YouTube channel to learn more about other features and functionality. What’s Under the Hood? The data backend of my app consists of three sheets: Questions holds all information about the questions asked in the app. Upvotes includes votes and question comments. QuickGuide includes a quick introduction of how the app works and includes links to the webinar registration page and other useful pages. Keep in mind the data in these sheets has been collected over time. So when you start building your app, copy this data and treat it as dummy data for testing purposes. You can then delete the data when the app is up and running. Recommended Reading: How to Turn Google Sheets into a Stock Management App How to Make a Property Management App in 10 Minutes How to Make a Project Management App in 10 Minutes  

How to Make a Project Management App in 10 Minutes

  You check emails on your phone in a taxi, at an airport or even in a grocery store. You may also edit documents in word, spreadsheet or PowerPoint while you are on the go. But have you ever thought about managing your projects on your phone?     Project management apps are one of the most popular functional areas for AppSheet creators. That’s because pretty much all of us, at one time or another, manage a project or a number of projects. I am no exception to that rule as my role here requires me to manage a ton of projects and project owners! My project management app helps me to ensure that deadlines are met and that work is distributed evenly. After reviewing many project management apps and creating my own, I’ve realized that there are three critical features every project management app must have. Now your project management app may include a number of “other” bells and whistles but these three features are key to project management success: Group projects by field options such as Owner and Time to easily track projects; Automate schedule notifications to increase productivity; Control access to data so that project owners only see what they need to see, improving the user experience. Data Grouping Makes Tracking the Progress of Projects Easier If you’re like me, a project management spreadsheet might look like pretty similar to the one below. It contains a ton of data but is very difficult to navigate due to the number of columns you are traversing. But in reality, you don’t need to see all the columns—you simply need to access those columns that need to be reviewed or updated based on an action. That’s why you need an app. With it, you can group and view your data by Project Owner, Project Start Time, Status, or even Project Category. So instead of eyeballing and mining data, you can effortlessly navigate to the group you want to check. Data grouping can also help to identify the number of projects by time period (in this example, week) and Owner. That way you can easily determine owners that are tasked with too many projects, and if necessary, redistribute the projects or change the time period to ensure that all projects are completed. For example, in the following app, John and Mary each have three to four projects, but Matt has only one project. You may want to redistribute the load so that Matt is working on more projects. To make status tracking even easier, use visual cues. Depending on the level of detail, you may want to use two different types of cues. For example: A pie chart to indicate whether a project is Completed (Full), In Progress (Half) or Not Started (Empty). A color bar to indicate whether an owner has Completed a project (Green), is In Progress (Yellow) or has Not Started (Red). With this feature, in the field or in the office, you can easily locate the projects that need attention and decide what actions to take. Automatic Deadline Alerts Keep Projects and Owners on Track The last thing you want to see is a project delay. To keep everything on track and on schedule, why not automatically send a deadline alert to a project owner when his or her deadline is approaching? You can set up your app to do this for you with some simple settings. For example, I can set up a workflow (you can do this under Reports in AppSheet App Editor) to send an email at a scheduled time. In this case, send deadline alert emails at 8am PST to project owners whose deadlines are two days from now. So, for example, if today is December 14, 2017, anyone whose deadline is December 16, 2017 will receive the Deadline Alert email at 8am today. The default email body can show project details and you can customize it to make it more personal. Below is an example of an automatic notification that is triggered based on a schedule deadline.   Another way to do this is to show all projects whose deadlines are two days away on a separate page, and decide if you want to send deadline alerts through pressing a button.      In either case, instead of manually reminding owners about tasks and deadlines, you have set up an automated process that does this for you. I don’t know about you, but this simple feature has made me so much more productive—no more manual tracking of deadlines! Controlled Data Access: Project Owners See Only What they Need to See Whether you’re working on one complicated project or a number of projects, you can control what project owners can access and update. This has two advantages: Uncluttered user interface for project owners as they only see information about the projects they are responsible for. Higher rates of adoption as the app is easy for project owners to use and update as they see only the information they care about. I’ve set up my app to work this way: all project owners can access my app but they can only see the projects that they own. I am the only one that can see all data in the app. For example, on Ryan’s Owner view/page (Left screenshot), he can only see four projects because those are owned by him but I can see all projects (Right screenshot) including Ryan’s.       Download my project management app below, check my expressions and make your own app!   That’s it for today’s post. As you build your project management app, keep these key features in mind. And please let me know: what other management features do you think are critical? What other function-focused articles do you want to read? Leave your comments below—we are always interested in your point of view! For use cases in the real world, please visit our AppSheet Creator Spotlight. For step-by-step app making instructions and new features, please go to Features, Tips & Webinars.