Please enable JavaScript.
Coggle requires JavaScript to display documents.
AppSheet (Security (Q&A (Who can acess my data?
No users can directly…
AppSheet
Security
-
-
-
-
-
Q&A
-
How do I control that?
- Require Sign-In (Pay by User model ONLY)
- Authentication Provider( s) (cloud data provider)
- Manage user whiltelist
Can I limit the actions or capabilities that specific users of the app can do?
Create a different app pointing to the same data.
What happens if an app user leaves my organization and I want them to stop using my app?
Either remove user from whitelist or make a copy and re-distribute a new one.
-
Data Type
Date, DateTime, Time
Mobile/Browser Local Setting
-
-
-
-
Form
Form
- Only for create new entry case
Multi-Page Form
Page_Header: used to create a new page within the form
Section_Header: used to create a new section within the same form page
Text: used to show some descriptive text
Url: used to show a clickable url
Here's an example of the Url Type Qualifier format:
{"Category":"Url", "Content":"http://www.your-url.com"}
Image: used to show a static image
Here's an example of the Image Type Qualifier format:
{"Category":"Image","Content":"http://www.your-url.com/your-image.png"}
More guidelines on images
Video: used to show an MP4 video or Youtube video (For MP4 videos, use the hosted link. For Youtube videos, use the embed link.)
-
-
Condition
-
IN([_THIS], {"ImportantToMatch"})
Links
Images, PDF
Relative: /images/*.png
Url: full path
Google Drive Url
Email Template
Place Holder
- <<Column Name>>
- <<Any AppSheet Expression>>
- <<[OrderRef].[Order Date]+7>>
- <<_ATTACHMENTNAME>>
- <<Built-In Variables>>
D-Reference Column
- Set "Ref" on foriegn Key
- Set "App Fomula" to [Foreign Key Column].[Referrd Column]
- You can do both: Set Ref and specify drop down
-
-
-
Signature
The word "Signature" in the column header will automatically generate a field to capture pen/touch input so you can capture signatures or small notes.
-
Field Value Can be Set:
- Human Data Entry
- Action triggering set value
- App Formula
- System initial value or change types