The reception lobby is monitoring the employee usage of sleeping quarters, gym, music room, billiards, gaming (playstation & xbox), table tennis, and netflix. Instead of manually logging the data to excel sheet by the receptionist, I am working on a self-service appsheet using employee ID. Employee inputs their ID, where employee details such as name and department will autofill including the timestamp, then add a selection for which facility they are using. The app will be accessible in an iPad on the reception desk, while receptionist validates the data entry on her desk monitor before issuing access to said facility. In the future revisions of this app, I will include usage statistics too. I’m currently creating this appsheet as of writing. But who knows, you might come with something brilliant! 😊
Brilliant! this is a detailed explanation to your case and i have my own version running in my mind. I will start working on it and share it to everyone soon! Thank you for sharing your brilliant use case.
Hi Aris, I'm impressed how you explain al these functions. I am looking for a good example for how to use "REF" in a relational maner like using an identifier like name and being able to extract data to an other table with the help of this "REF" function. Keep up the good work.
Hello Sir! It's a pleasure seeing you here. Thank you for your kind words and support. It means a lot to me. Anyways, regarding REF...i will be doing a junction table video this week and that would give you some ideas on how the REF would fit in most situation. I do find REF helpful most of the time.
This work fine to a certain point for me, but I'm trying to have a certain date from one sheet updated automatically in a second sheet. I only get the first entry, but when I add a new date it would update. For example, I enter next appointment for patient A to be 06/21/24. When patient comes to the appointment and I enter the new appointment date 7/20/24 for example the new date doesn't show only the firtst date I enter 06/21/24 shows. I need that each time I enter a new appointment date that new date replace the previous date. And it won't let me use "date" as the data type I hacve to use "text" and type the date instead of just clicking on a calendar. How can I do that?
Hi Aris, thanks for sharing the great tips. But something doubting me, why we want to have a duplicate set of data in a two different tables. What if the value is change in the master table, like the name is change in the Employee table, will the name inn the transaction table is auto update? By the way, I have subscribe ur channel, and will keep watch you video. Thank you
Hi there! first of all thank you for your support and kind words! It means a lot to me. Now going on to your question. It's simply a Master - transaction table relationship. Definitely there's other ways to do it such as linking the keys between both tables or joint tables for that matter. The example that i used is just merely the basic ones that i can share. To answer your doubt whether the data would change in transaction if master changes..the answer would definitely be no, but then it's by design. If you like to ensure transaction updates as well then i would highly suggest the use the alternatives above mentioned. That's the beauty of this activity. It's endless ;)
Hello sir may i ask, what about if we want to prefill the form from the data within the same table? My case is, i want it to be: if the ID has been registered before, he can just put in the ID NUMBER (uniqueid) and all the remaining details (name, address) is automatically filled in once he put in the ID Number. Can this be done using the same formula?
Hello and Salam Sir Fuad..yes you can actually..just tie back the other columns based on the ID or any other "hook" you prefer Example : name , email, etc pull from unique ID / Order ID
@@aris_azhar or if the lookup does not match any ID number, the other field will be empty so that other ID Number can be registered. Thanks2 alot for your informative videos.
So nice tutorial, clear and useful. I search and study for online database topics many years, you are the best!
Wow, thanks! you made my day! thank you o'friend!
I’ve been looking to your videos to reference for my next automation project for our reception lobby. Glad I found this. Cheers!
I am actually doing one series for your case.mind sharing some background on your project so that i can share something as well 🙏
The reception lobby is monitoring the employee usage of sleeping quarters, gym, music room, billiards, gaming (playstation & xbox), table tennis, and netflix. Instead of manually logging the data to excel sheet by the receptionist, I am working on a self-service appsheet using employee ID. Employee inputs their ID, where employee details such as name and department will autofill including the timestamp, then add a selection for which facility they are using. The app will be accessible in an iPad on the reception desk, while receptionist validates the data entry on her desk monitor before issuing access to said facility. In the future revisions of this app, I will include usage statistics too.
I’m currently creating this appsheet as of writing. But who knows, you might come with something brilliant! 😊
Brilliant! this is a detailed explanation to your case and i have my own version running in my mind. I will start working on it and share it to everyone soon! Thank you for sharing your brilliant use case.
great! even in the google appsheet comunity i have found a valid explanation. in this video, i got one. Thanks a lot!
Glad it helped! so happy to hear it is working for you Marcel
Hi Aris, I'm impressed how you explain al these functions. I am looking for a good example for how to use "REF" in a relational maner like using an identifier like name and being able to extract data to an other table with the help of this "REF" function.
Keep up the good work.
Hello Sir! It's a pleasure seeing you here. Thank you for your kind words and support. It means a lot to me. Anyways, regarding REF...i will be doing a junction table video this week and that would give you some ideas on how the REF would fit in most situation. I do find REF helpful most of the time.
Thanks a lot, sir. I could't find This instructions in anywhere.
No worries! I'm happy this video is able to do some justice to you Sir
great video but i have a question how i can configure an connexion page so that the user might fulfill it before go to the home page
This is something that came across my mind earlier today..i will do a tutorial on it soon! Thanks for the prompt!
VOCÊ É FODAAAA!! OBRIGADO GUY!!!
This work fine to a certain point for me, but I'm trying to have a certain date from one sheet updated automatically in a second sheet. I only get the first entry, but when I add a new date it would update. For example, I enter next appointment for patient A to be 06/21/24. When patient comes to the appointment and I enter the new appointment date 7/20/24 for example the new date doesn't show only the firtst date I enter 06/21/24 shows. I need that each time I enter a new appointment date that new date replace the previous date. And it won't let me use "date" as the data type I hacve to use "text" and type the date instead of just clicking on a calendar. How can I do that?
Why on tutorials everything often working ?
Aha!! I'm not too sure myself but if there's anything i can do to assist you do let me know. I am more than happy to help
Thank you Sir
You're most welcome!
Thanks a lot
You're most welcome!
Hi Aris, thanks for sharing the great tips. But something doubting me, why we want to have a duplicate set of data in a two different tables. What if the value is change in the master table, like the name is change in the Employee table, will the name inn the transaction table is auto update?
By the way, I have subscribe ur channel, and will keep watch you video.
Thank you
Hi there! first of all thank you for your support and kind words! It means a lot to me.
Now going on to your question. It's simply a Master - transaction table relationship. Definitely there's other ways to do it such as linking the keys between both tables or joint tables for that matter. The example that i used is just merely the basic ones that i can share. To answer your doubt whether the data would change in transaction if master changes..the answer would definitely be no, but then it's by design.
If you like to ensure transaction updates as well then i would highly suggest the use the alternatives above mentioned.
That's the beauty of this activity. It's endless ;)
Hello sir may i ask, what about if we want to prefill the form from the data within the same table?
My case is, i want it to be: if the ID has been registered before, he can just put in the ID NUMBER (uniqueid) and all the remaining details (name, address) is automatically filled in once he put in the ID Number.
Can this be done using the same formula?
Hello and Salam Sir Fuad..yes you can actually..just tie back the other columns based on the ID or any other "hook" you prefer
Example : name , email, etc pull from unique ID / Order ID
@@aris_azhar or if the lookup does not match any ID number, the other field will be empty so that other ID Number can be registered. Thanks2 alot for your informative videos.
look up function dont appear on mobile screen, only on web
how to add a auto "UID" in first fill??
Use " UNIQUEID()" in initial value under the auto compute section of your data settings