Level Up Your App Development: Mastering Appsheet Best Practices
ฝัง
- เผยแพร่เมื่อ 16 มิ.ย. 2024
- If you are using Google Appsheet to streamline and automate your business processes, then you should know these best practices in setting up your apps by now.
Get these best practices as an eBook:
bit.ly/4bh3JSp
Use Coupon Code: imsofullofsheets
(Thanks for your suppport. 🙏)
These recommendations are based on actual experience in developing several Appsheet apps and are highly practical and easy to apply.
Related Videos:
5 ways to create dropdown list in AppSheet
• Top 5 Ways to Make Dro...
Creating Dynamic Dependent Dropdowns
• Say Goodbye to Complex...
=====================================
In this video:
00:00 Welcome to Full of Sheets
01:13 Chapter 1: Setting Default Folder Paths for Appsheet apps
05:00 Using Team Drives as default folder path
06:23 Moving existing AppSheet app project folders
07:10 Chapter 2: App Development Preparations
09:12 Non-negotiable columns for your Appsheet apps (Must have columns/fields)
11:25 Must have: UniqueID() as primary key for Appsheet tables
11:56 Appsheet Unique ID power tips
13:30 Make the formula builder always available for Show, Editable, and Require toggles
16:19 Must have: Date of Submission
18:14 Must have: Submitted by (user who made the entry)
20:53 Chapter 3: App theme and configartions
21:13 Setting up the About page
22:37 Custom branding: Appsheet app theme, colors, logo, header, and footer
24:20 Customizing Appsheet app menu display
25:16 Customizing Column and View display names
27:18 Chapter 4: Appsheet app security controls
27:42 Setting app-level permissions
28:41 Setting user-level permissions
30:18 Setting view or page-level permissions
32:27 Setting table-level permissions
33:30 Setting row or record-level permissions
33:53 Using a slice for row/record-level permissions
36:01 Using table security filters for row/record level permissions
37:19 Questions, Suggestions, Requests and next video line-ups
===========================
#appsheet #tutorials #tips #tricks
#howto #buildingwithappsheet #appsheetforbeginners - แนวปฏิบัติและการใช้ชีวิต
![[TH] VCT Pacific Stage 2 - Week 1 Day 1 // DRX vs ZETA | BLD vs TS](http://i.ytimg.com/vi/AWaOqaxN6Y0/mqdefault.jpg)
Great video, keep them coming! 👍
We will. Please feel free to suggest what we should cover next.
Fantastic video. As a new user with Appsheets you've helped me understand some of the concepts I was not sure about. Thanks for sharing!
Glad it was helpful!
Fantastic video. Thank you so much
You're very welcome! Glad you liked it!
Thanks Pal, You have got a new suscriber of course!
Thanks for the sub!
Easy and awesome!!!
Glad you think so!
Awesome video. Thank-you! You explain it very well. Nice presentation style, too.
Thank you. I appreciate it a lot!
Salamat dito, dami ko agad napulot. Galing sir!
Salamat, tol. Yan talaga ung para sakin, mga pinaka importante malaman e. Hindi masyado tinuturo ng iba.
Very useful! thanks!^^ Please make more videos about appsheet.
Thanl you
There's a lot more to make that I can't decide which one to do first.
Can you suggest? What would you like to learn next?
@@FullOfSheets In my case, table design principle, data backup, appsheet database vs google sheets pros and cons, Refs details, formula and expression assistant details with sample phrases, various actions sample etc.. Too many? haha thanks^^
Wow! Great suggestions. I've added them in my list of videos to make.
Please wait for them because I am still finishing my holdiay vacation. 😁
Great video and easy to understand. I subscribed your channel
Thanks for the sub! I appreciate it.
Thank you for explaining how to properly create record Ids! This is sorely missing from the Google documentation.
I'm glad it helped.
Great!
Thanks. 😊
Thank you for the great tutorial.
Do you have any best practices to share when you want to use an Airtable base as a back end with Appsheet as the front?
Hi Laurel,
The best practices in this video are pretty much universal. Just implement the same things I did in the Google Sheets with your Airtables.
Great , Dy you have a video about the Date validation rules
None yet. Can you expound on what you meant by Date Validation Rules?
ME TOO SIR, IM FULL OF SHEETS. 🙂
Most, if not all, of us work with a lot of Google spreadsheets or Microsoft Workbooks.
And each of our files have multiple sheets or tabs that we try to transform, update, track, monitor, and analyze.
Which is why we all try to find ways to automate as much processes as we can. Because we all want to be more productive and efficient in working with the sheets that we manage.
We are all... full of sheets. 😉
Greaaat Explain ❤❤
I have a question about submitted By and Edited By ..
The two column have function useremail() .. Good
How appsheet will know this is original user and this is Edited user ?
I think when edited user make any modification the two column ((submitted by and edited by)) will change to the email of edited user..
How make seperate between them
The submitted by will never change because we only used USEREMAIL() as an Initial Value. Initial Values are only assigend during first creation of entry.
Except...
If we turn on 'Reset on Edit', as I've shown in the video.
So to summarize.:
SUBMITTED BY
Initial Value : USEREMAIL()
Reset on Edit : No
EDITED BY:
Initial Value : USEREMAIL()
Reset on Edit : Yes
What you are referring to is if you put USEREMAIL() in the column formula instead of in the Initial Value. Because column formulas (1st text box in the app editor) will always recalculate on each edit.
Hope this clarifies.
@@FullOfSheets
Very Very Clear ❤
Realy you are great ❤
Continue 💪
Thank you 🫡
I appreciate it.
Hey! Is there a way in which I can have different views of the same table which show up almost similar, the major difference being one view is where all the edits happen with user level security by using show if and the other which again shows all of the info but renders everything not editable and is a view only type view. Please help!
Yes, it is possible.
There are more than 1 way to do it.
First things first:
Everytime you create a view that is either a Deck or a Table, AppSheet actually automatically creates the ff. for you.
A system generated Form View
A system generated Detail View
A system generated Add action button
A system generated Edit action button
A system generated Delete action button
So if you create another Deck or Table view for the same table, then you should get another set of the system generated views and action buttons.
All you have to do now is Do Not Display the system generated action buttons of the second view.
Another way is to set a table level permission based on the logged in User.
This way, you can just have a single set of views and action buttons, and the table controls who gets access to Add, Edit, and Delete actions.
There are other ways, but those are the one on top of my head right now.
Golden non-patreon information
Thanks for the nice words. ☺️
Hello, are you able to do development? If so, how can I contact you?
Hi, what kind of project do you have in mind?
Please check out my Chennel Description
can i conect a blueooth device with a SPP code in appsheet?
What's an SPP code?
@@FullOfSheets serial port
Well, you don't actually connect to Appsheet. You connect it to your sevice.
If your device can recognize it, then you should be able to use it.
What is it you're trying to do with this bluetooth SPP? So far, you've only described what it has, but you haven't mentioned what it does.
Nice, paano po pag sa viewing restictions. Could I set it using standard enterprise account?
Yes, pwedeng pwede. The security settings I showed in the video are all available from the Core Plan and up.
Enterprise plans even allows you to have team management.
thank you@@FullOfSheets , one more thing I encounter this problem when applying the user settings : Sync Token Is Invalid. Please restart the app , I tried with other users and it's working on them
oh i remove the IN part in security and the + button for tickets showed but when I add the IN(needle,haystack) part in was not functioning
@El-yen10 if you are using the IN(needle, haystack) part, then that means you have a table of your users where one of the columns is the email address correct?
What is the actual IN() expression did you put?
I base my excel database on your excel example: IN(USEREMAIL(),Users[EMAIL]), I have remove it now and the "+" is no where to be found, I'm making a clone app before the security part and assessing what did i do wrong
I would like to add multiple tasks and would like to equally assign it to members automatically.. I'm able to add the task details in the worksheet. But. I'm not able to make equal assignments. Can you help me?
What did you mean by equally assign it to members?
I'm guessing you have a column in the worksheet that would record the Assigned member?
And you want to assign multiple members to the same task?
If i understood correctly, then you would want tou se an EnumList + Valid If, or an EnumList-Ref combination.
See my video th-cam.com/video/I0TwK5rODaI/w-d-xo.htmlsi=diHsgXobw5BpBw3V for more info.
You can then use the IN() function for your slice or security filter, as discussed in this Best Practices video, to make the task appear in the view of your member/s.
@@FullOfSheets Thank you for your response. I have two sheets: a Worksheet and a Master sheet (where I have predefined tasks). I want to update the Worksheet with the predefined tasks from the Master sheet using buttons. I'm able to transfer the number of tasks from the Master sheet to the Worksheet, but I'm having trouble assigning the tasks in the Worksheet equally.
Here's an example: I've updated 10 tasks in the Worksheet, and I have 4 people who will be working. I need to assign the 10 tasks among those 4 people evenly, with each person getting 2 tasks and the first 2 people getting the remaining 2 tasks. I've tried using the RANDOM function with this formula:
- INDEX(Work_Sheet[Ldap], RANDBETWEEN(1, COUNT(Work_Sheet[Ldap])))
However, this method doesn't distribute the tasks evenly. Can you help me with a solution that ensures equal task assignment?
I'm afraid that what you are trying to accomplish is like simulating dealing cards in a poker game.
You can achieve this through looping which means you will have to use the AppSheet API.
I'm working on project management application, where tasks should be equally assigned among the operators. Can you help me with any video of API to achieve? Thanks.@@FullOfSheets
There is not much videos of Appsheet APIs as the # of people using it are very minimal.
I can direct you to some source materials, but do you know how to code? You would need some knowledge of Javascript and JSON to be able to successfully implement it.
Hi.. Is activating flask icon available in core license? Hindi ko sya makita sakin.
Yes available sya sa core plan Are you referring to the flask icons for shw, editable, and require tickboxes in the table editor?
Click mo ung profile icon mo sa top right, then editor settings.
@@FullOfSheets Yes, para hindi mo na need pumunta sa pen button, pero sakin kase hindi ko makita yug option na katulad sayo na pinakita mo dito sa video.
Talaga? That's weird ha. Kasinkahit sa free plan na gsmit ko, meron nun e.
@@FullOfSheets Yes Sir.. medyo weird nga po.. kahit sa free ko din po wala.. hehehe. anyway, Thanks po! Nice video tutorial, napaka clear.
@@FullOfSheets I got it na po Sir, dapat po pala nasa improved ecitor. im using most of the time kase na legacy. Thanks thanks!