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. 😉
@@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^^
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?
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.
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.
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.
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 czcams.com/video/I0TwK5rODaI/video.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.
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.
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.
Thank you! Very helpful tips
You're so welcome!
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!
Thanks Pal, You have got a new suscriber of course!
Thanks for the sub!
Thanks!
Thanks for the coffee treat! I appreciate it! 😊
Great video, keep them coming! 👍
We will. Please feel free to suggest what we should cover next.
Thank you for explaining how to properly create record Ids! This is sorely missing from the Google documentation.
I'm glad it helped.
Awesome video. Thank-you! You explain it very well. Nice presentation style, too.
Thank you. I appreciate it a lot!
This is a great video. Thank you very much.
Glad it was helpful!
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. 😉
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. 😁
Fantastic video. Thank you so much
You're very welcome! Glad you liked it!
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 video and easy to understand. I subscribed your channel
Thanks for the sub! I appreciate it.
Easy and awesome!!!
Glad you think so!
Great , Dy you have a video about the Date validation rules
None yet. Can you expound on what you meant by Date Validation Rules?
Great!
Thanks. 😊
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.
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 czcams.com/video/I0TwK5rODaI/video.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!