Level Up Your App Development: Mastering Appsheet Best Practices

Рет қаралды 12,128

Күн бұрын

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

Пікірлер: 68

@X1GENERATION 6 күн бұрын

This is a great video. Thank you very much.

@goodmonkeygarage 5 ай бұрын

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!

@FullOfSheets 5 ай бұрын

Glad it was helpful!

@gregmaier5784 6 ай бұрын

Great video, keep them coming! 👍

@FullOfSheets 6 ай бұрын

We will. Please feel free to suggest what we should cover next.

@rafaelfarfan6592 2 ай бұрын

Thanks Pal, You have got a new suscriber of course!

@FullOfSheets 2 ай бұрын

Thanks for the sub!

@dyangkrismoris4553 2 ай бұрын

Salamat dito, dami ko agad napulot. Galing sir!

@FullOfSheets 2 ай бұрын

Salamat, tol. Yan talaga ung para sakin, mga pinaka importante malaman e. Hindi masyado tinuturo ng iba.

@ChrisGibbings-zx1yi 2 ай бұрын

Awesome video. Thank-you! You explain it very well. Nice presentation style, too.

@FullOfSheets 2 ай бұрын

Thank you. I appreciate it a lot!

@zaidalsrory8197 4 ай бұрын

Fantastic video. Thank you so much

@FullOfSheets 4 ай бұрын

You're very welcome! Glad you liked it!

@frenchmoneybags 5 ай бұрын

Easy and awesome!!!

@FullOfSheets 5 ай бұрын

Glad you think so!

@boooney1 Ай бұрын

Thank you for explaining how to properly create record Ids! This is sorely missing from the Google documentation.

@FullOfSheets Ай бұрын

I'm glad it helped.

@sajinj2457 5 ай бұрын

Great video and easy to understand. I subscribed your channel

@FullOfSheets 5 ай бұрын

Thanks for the sub! I appreciate it.

@user-jp88 6 ай бұрын

Very useful! thanks!^^ Please make more videos about appsheet.

@FullOfSheets 6 ай бұрын

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?

@user-jp88 5 ай бұрын

@@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^^

@FullOfSheets 5 ай бұрын

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. 😁

@josephrico51 4 ай бұрын

ME TOO SIR, IM FULL OF SHEETS. 🙂

@FullOfSheets 4 ай бұрын

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. 😉

@laurelozano1446 3 ай бұрын

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?

@FullOfSheets 3 ай бұрын

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.

@hiroyukinumaguchi1984 5 ай бұрын

Great!

@FullOfSheets 5 ай бұрын

Thanks. 😊

@abdulwahabal-anesi1961 4 ай бұрын

Great , Dy you have a video about the Date validation rules

@FullOfSheets 4 ай бұрын

None yet. Can you expound on what you meant by Date Validation Rules?

@kareemelkafi7845 5 ай бұрын

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

@FullOfSheets 5 ай бұрын

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.

@kareemelkafi7845 5 ай бұрын

@@FullOfSheets Very Very Clear ❤ Realy you are great ❤ Continue 💪

@FullOfSheets 5 ай бұрын

Thank you 🫡 I appreciate it.

@20128096 5 ай бұрын

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!

@FullOfSheets 5 ай бұрын

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.

@FullOfSheets 5 ай бұрын

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.

@frenchmoneybags 5 ай бұрын

Golden non-patreon information

@FullOfSheets 5 ай бұрын

Thanks for the nice words. ☺️

@user-tv3pv8tl5i 6 ай бұрын

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?

@FullOfSheets 6 ай бұрын

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 kzfaq.info/get/bejne/f5aEqq5m17WokX0.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.

@user-tv3pv8tl5i 6 ай бұрын

@@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?

@FullOfSheets 6 ай бұрын

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.

@user-tv3pv8tl5i 6 ай бұрын

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

@FullOfSheets 6 ай бұрын

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.

@adonis2846 6 ай бұрын

Hello, are you able to do development? If so, how can I contact you?

@FullOfSheets 6 ай бұрын

Hi, what kind of project do you have in mind?

@FullOfSheets 6 ай бұрын

Please check out my Chennel Description

@Seabrasistemas 4 ай бұрын

can i conect a blueooth device with a SPP code in appsheet?

@FullOfSheets 4 ай бұрын

What's an SPP code?

@Seabrasistemas 4 ай бұрын

@@FullOfSheets serial port

@FullOfSheets 4 ай бұрын

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.

@user-ji7kb4sl5l Ай бұрын

Hi.. Is activating flask icon available in core license? Hindi ko sya makita sakin.

@FullOfSheets Ай бұрын

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.

@user-ji7kb4sl5l Ай бұрын

@@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.

@FullOfSheets Ай бұрын

Talaga? That's weird ha. Kasinkahit sa free plan na gsmit ko, meron nun e.

@user-ji7kb4sl5l Ай бұрын

@@FullOfSheets Yes Sir.. medyo weird nga po.. kahit sa free ko din po wala.. hehehe. anyway, Thanks po! Nice video tutorial, napaka clear.

@user-ji7kb4sl5l Ай бұрын

@@FullOfSheets I got it na po Sir, dapat po pala nasa improved ecitor. im using most of the time kase na legacy. Thanks thanks!