100 Questions and Answers for AppSheet

Basics (1–20)

1. Q: What is AppSheet?
   A: A no-code app development platform.
2. Q: Who owns AppSheet?
   A: Google.
3. Q: What type of apps can you build with AppSheet?
   A: Mobile, tablet, and web apps.
4. Q: Do you need coding knowledge to use AppSheet?
   A: No, it’s a no-code platform.
5. Q: Can AppSheet connect to Excel files?
   A: Yes, including Excel on OneDrive and Dropbox.
6. Q: What is the function of a table in AppSheet?
   A: It stores your app’s data.
7. Q: What is a view?
   A: A way to display data in different formats like table or form.
8. Q: What is a form view?
   A: Used to add or edit data.
9. Q: What is the default view type?
   A: Table view.
10. Q: What is a key column?
    A: A unique identifier for each row.
11. Q: Can AppSheet apps work offline?
    A: Yes.
12. Q: What is the data tab used for?
    A: To manage tables, columns, and slices.
13. Q: What is a slice?
    A: A filtered version of a table.
14. Q: What is UX in AppSheet?
    A: User experience; controls views and navigation.
15. Q: Can you hide views in AppSheet?
    A: Yes, using show_if expressions.
16. Q: What is a virtual column?
    A: A calculated column not stored in the data source.
17. Q: Can you have multiple tables in one app?
    A: Yes.
18. Q: What is a dashboard view?
    A: A combination of multiple views.
19. Q: What is the purpose of actions?
    A: To perform tasks like adding data or navigation.
20. Q: What is a bot in AppSheet?
    A: An automation tool using events and processes.

Data & Columns (21–40)

21. Q: What is a column type?
    A: It defines the kind of data, like Text, Number, Enum.
22. Q: What does the Enum type do?
    A: Creates a dropdown list of options.
23. Q: What does Ref type mean?
    A: It’s a reference to another table.
24. Q: What does the Show type do?
    A: Displays static text or images in forms.
25. Q: What does the ChangeCounter type do?
    A: Counts how many times a column changes.
26. Q: What does Valid_If do?
    A: Limits or validates input values.
27. Q: What is an initial value?
    A: A default value for a new entry.
28. Q: What is an App Formula?
    A: A dynamic formula that auto-updates based on changes.
29. Q: What is Editable_If?
    A: Controls if a column is editable.
30. Q: Can you use dropdowns in forms?
    A: Yes, with Enum or Valid_If.
31. Q: What is the purpose of ISBLANK()?
    A: Checks if a value is empty.
32. Q: What does NOW() return?
    A: The current date and time.
33. Q: What does TODAY() return?
    A: The current date.
34. Q: What is a dependent dropdown?
    A: A dropdown based on another column’s value.
35. Q: What is the difference between App Formula and Initial Value?
    A: App Formula is dynamic; Initial Value is static.
36. Q: What does CONCATENATE() do?
    A: Joins multiple values into one.
37. Q: What is the TEXT() function used for?
    A: Formats values as text.
38. Q: What does SELECT() do?
    A: Retrieves a list of values from a column based on a condition.
39. Q: What does LOOKUP() do?
    A: Finds a single value from a row in another table.
40. Q: What does ANY() do?
    A: Returns one value from a list, usually the first.

UX & Views (41–60)

41. Q: Can you customize icons in AppSheet?
    A: Yes.
42. Q: Can you change the order of views?
    A: Yes, in the UX > Views tab.
43. Q: What are system views?
    A: Auto-generated views for your tables.
44. Q: What is a map view?
    A: Displays data with location coordinates on a map.
45. Q: What view type is used for charts?
    A: Chart view.
46. Q: Can you group rows in a table view?
    A: Yes, using Group by options.
47. Q: Can you change the app theme?
    A: Yes, under UX > Brand.
48. Q: Can you display images in a view?
    A: Yes, using an Image column.
49. Q: What does a detail view show?
    A: One record’s full details.
50. Q: What is the use of a gallery view?
    A: Displays images in a grid layout.
51. Q: What is Quick Edit?
    A: Allows editing directly in a detail view.
52. Q: Can you use custom branding in your app?
    A: Yes.
53. Q: What is the primary view?
    A: The default view shown when the app opens.
54. Q: Can you rename views?
    A: Yes.
55. Q: What does the Display Name setting do?
    A: Controls how column or view names appear in the app.
56. Q: What’s the use of the “Show If” property?
    A: Controls conditional visibility of views or columns.
57. Q: What view type shows multiple views at once?
    A: Dashboard view.
58. Q: What is a reference view?
    A: A view shown when linked from another table.
59. Q: Can you create custom menus in AppSheet?
    A: Yes, using grouped actions or menu views.
60. Q: Can you show different views based on user roles?
    A: Yes, with Show_If and USEREMAIL().

Automation & Integration (61–80)

61. Q: What is a bot?
    A: A tool to automate processes.
62. Q: What are events in a bot?
    A: Triggers like adding or updating a row.
63. Q: What are processes in a bot?
    A: Steps to execute when an event occurs.
64. Q: What is a task in AppSheet automation?
    A: A specific action like sending an email or creating a file.
65. Q: What file formats can AppSheet automation generate?
    A: PDF, CSV.
66. Q: Can AppSheet send SMS?
    A: Yes, through Twilio integration.
67. Q: Can you send push notifications?
    A: Yes.
68. Q: Can you schedule automations?
    A: Yes, using scheduled bots.
69. Q: What function sends an email?
    A: Use automation with an Email task.
70. Q: What template format is used for documents?
    A: Google Docs, Word, or Excel templates.
71. Q: Can AppSheet integrate with Google Drive?
    A: Yes.
72. Q: Can you automate workflows without user interaction?
    A: Yes, using bots.
73. Q: What does USEREMAIL() return?
    A: The logged-in user’s email.
74. Q: What is the purpose of user roles?
    A: To create permission-based access.
75. Q: What does the CONTEXT() function return?
    A: Info about the current app context, like view name.
76. Q: Can you log app usage?
    A: Yes, using audit history.
77. Q: Can AppSheet apps use barcodes?
    A: Yes, using a Barcode column type.
78. Q: Can you filter views based on users?
    A: Yes, with expressions like USEREMAIL().
79. Q: Can AppSheet update connected sheets automatically?
    A: Yes, when data is added or edited.
80. Q: What is the automation monitor used for?
    A: To test and debug automation processes.

Advanced Features (81–100)

81. Q: What is security filter used for?
    A: To limit data downloaded to the device.
82. Q: Can AppSheet apps be white-labeled?
    A: Yes, with a Business plan.
83. Q: What is AppSheet’s pricing model?
    A: Based on per user/month or per app.
84. Q: Can you use AppSheet with MySQL?
    A: Yes.
85. Q: Can you use Google Maps in AppSheet?
    A: Yes, with address or LatLong columns.
86. Q: Can users log in to AppSheet apps?
    A: Yes, using Google, Microsoft, or other providers.
87. Q: What is the audit history?
    A: A log of user actions and app activity.
88. Q: What are app versions?
    A: A snapshot of your app’s state for rollback or reference.
89. Q: Can you use API with AppSheet?
    A: Yes, AppSheet provides REST API support.
90. Q: What’s the use of Deployment Check?
    A: To test if your app is ready for users.
91. Q: What is the App Gallery?
    A: A list of sample apps provided by AppSheet.
92. Q: Can AppSheet use OCR?
    A: Yes, for text recognition from images.
93. Q: What is column order used for?
    A: To rearrange column display in forms.
94. Q: Can you share apps with others?
    A: Yes, by inviting users or publishing.
95. Q: What is AppSheet Emulator?
    A: A preview of how your app looks on devices.
96. Q: Can you restore deleted data in AppSheet?
    A: Not directly—restore from your data source.
97. Q: What is data validity?
    A: Ensuring correct input using constraints.
98. Q: Can you use multiple languages in one app?
    A: Yes, with expressions and translations.
99. Q: Can AppSheet be embedded in a website?
    A: Yes, using iframe embedding.
100. Q: Is AppSheet HIPAA compliant?
     A: Yes, with the appropriate plan and configuration.