Hello sir make a video on how to Calculate work days example. If the work hours is 8AM to 5PM, after the user log out at 5PM it will Automatically Calculate the day as "1" day. And also make for Absents (0) and Half Days (0.5)
I have an attendance system under development in appsheet and I want when I add record for a specified day 'it will automatically detect that is a holiday if it is so.Shall I use lookup for the sheet with the holidays or is there any other way?
very nice video, and very nice feature grandmaster Aris. You should have told, that this script only works as it is bound to a sheet. But ... nevertheless i have another problem. In Appsheet there is a calendar view ... and i would like to have holidays in it ( i tried it with the google calendar ( i can see the holidays, but i cannot put an item ( calendar bound ) in it. Google told me that this is not possible.
Hello sir make a video on how to Calculate work days example. If the work hours is 8AM to 5PM, after the user log out at 5PM it will Automatically Calculate the day as "1" day. And also make for Absents (0) and Half Days (0.5)
I have an attendance system
under development in appsheet and I want when I add record for a specified day 'it will automatically detect that is a holiday if it is so.Shall I use lookup for the sheet with the holidays or is there any other way?
very nice video, and very nice feature grandmaster Aris. You should have told, that this script only works as it is bound to a sheet. But ... nevertheless i have another problem. In Appsheet there is a calendar view ... and i would like to have holidays in it ( i tried it with the google calendar ( i can see the holidays, but i cannot put an item ( calendar bound ) in it. Google told me that this is not possible.
Ah! my bad Sir Alberich! yes, this is bound to sheet but there's another way we can sync it with calendar. I will make one soon just for you
@@aris_azhar ohhhh ... just for me ..... and many thousand others ( so i hope ) .... keep cool and warm my one and only grandmaster ❤️