Видео

No, I think it was a test app and has now been re-integrated into Tuya Cloud. So I had to remove it and am back to using Tuya Cloud & Local Tuya (Grrrrrr!)

@@MaxDrake ok cool, yeah that makes sense. I also remember having to do the user code and scan to get Tuya working a bit while back, after all my devices disappeared. I haven't done the Local Tuya because I can't find the local key (I think that is what it is called) 😂

@@renaulth2009 I use python script for Github repo that gets the local key. Look in github.com/jasonacox/tinytuya and download tinytuya and then run the scripts for python -m tinytuya wizard & python -m tinytuya scan and it makes local json files with all the details of your devices (as well as ones on Zigbee) so you can get local keys. It’s a better way than trying to get them by trying to connect to Tuya Cloud, although you have to set that up first. All vey painful and not intuitive. You'd think they would try and make it easy.

@@MaxDrake ah thanks, will check it out. Yeah man, it's a lot of finicky atuff, I wish there could be a completely open hardware company for automation stuff.

Hi Michael G, I haven't used the program for a while now. So can't directly help you. Suggestions: 1. Forum, here is a link to the forum, forum.jmgr.net/viewforum.php?f=35, some of its in French so you may need to do a google translate. 2. In your script, you could execute only part of it, with Highlighting a few steps and execute selection (R.Hand context menu) - if you are debugging a script. 3. Does Sing4Y@urSupp3rhe ESC key work as 'abort'? It does in some scripts 3. Ctrl + Alt+ Del and bring up Task Manager & SSing4Y@urSupp3rop the program. 4. I found this on forum - forum.jmgr.net/viewtopic.php?p=2461&hilit=stop#p2461 If you are in a loop and need to break out you can get it to check a key press (eg key =1)in the loop prior to running the rest of the loop so if its in infinite loop you have if key press =1 then stop. The graphical interface is quite nice. I use AutoHotKeys now and directly code scripts that I want, but that takes longer, I hope you find a solution to your issue, Sorry I cannot help you further, kind regards,

​@MaxDrake couldn't figure it out. My main solution now to break infinite loops is just to bring up the lock screen with Window Key + L. That always stops the program. I like the idea of programming a check key function before running rest of loop tho, how do you do that

@@ndskykng Inside the loop you have an IF/ELSE statement. So the IF statement says if keys (say Ctrl + 1) are pressed then exit loop, ELSE do the loping that you want to do, so each time it goes through the loop it checks first if the key (say Ctrl + 1) is pressed otherwise it just carries on doing the ELSE part of the loop. So if you have a counter outside, a variable x=1 then go into the loop and in the ELSE part it runs X=X+1, in this case maybe processing all the files in a specific directory, so it looks to see if there are files, if there are then it reads first file, checks its name and records it in a text file say, then goes back into the loop where X=2 now, so keeps going through the loop process until the last file is reached (then you need to tell it to quit/exit loop, if no more files then it stops. But each time it increments X=x+1 it passes through the IF statement so you have opportunity to press Ctrl+1 key to break the script and exit the loop. A A bit of a verbose explanation, sorry, but I hope it helps, good luck with your project, kind regards

Hi robertnegro9083 , I haven't been paying with 3DPDF's for quite a while now. I think I used proprietary programs to create the 3DPDFs so the window size was created in those programs , I used SimLab Soft program to create a 3D PDF from a Autodesk REVIT Bim Model. There were a few other 3D PDF programs but they were associated with BIM programs and Revit wrote the file to their PDF format. So the window sizes were already set - So long and short of it, sorry, cant help you there. How are you generating your 3D Images or are you getting them from somewhere else? Sorry I can't help you further, Good luck with your endeavour, Kind regards,

Hi edmel144, I did another video on using python to activate python scripts here : ruclips.net/video/JqPifb-qu7k/видео.html that may be of interest to you. I did start writing book on Python hotkeys with message box last year and didn't quite get around to publishing it, I used the PySimpleGui package instead of Tkinter, I found it a much easier package to use for the GUI's. Kind regards,

there is also AutoHotKey , that has a lot of things you can script yourself. 2 others I use all the time are executor.dk/ and maxlauncher.sourceforge.io/. MaxLauncher is versatile and you can put lots of things under keys, web pages and scripts, and handy place to store lots of scripts that you'd otherwise have difficulty remembering the keys for launching that particular script/app etc. I've made RUclips vid on MaxLauncher (ruclips.net/video/PgjgGRWJ4no/видео.html) and other free productivity tools playlist (studio.ruclips.net/user/playlistPLefQD9ccYWsiYt3AaW3tj-DQyrnBCu2nX/videos), I hope that helps, kind regards,

Thank you, I'll check those. I use QAP that is based on AHK. I'm a senior process technician for Intel Corp and we have so many reports and programs to use that keyboard and mouse overuse is #1 in injuries. I use a 15 button Stream deck with QAP. I got lazy after finding QAP and stopped programming in AHK V1. I mainly work with SSRS, SQL and advanced Excel. I do most of the scripts for my shift. I got one of your books.@@MaxDrake

Hi @sv4647, I did this a while ago- not sure if it automatically saw what theme I was using on my PC (Win10) or if I specifically coded for it. There is this RUclips video for Dark Theme ruclips.net/video/iUgNIFrVejc/видео.html You can also download my code from Here: drive.google.com/drive/folders/1exzHognJY59XdaSSHZzXuPARFdLyf7s0?usp=sharing I had a quick look at the AppC2.py file for streamlit app and under: ## Config streamlit page there does not seem to be anything specific for theme, so I think its getting it from my Browser (firefox ) , but Just checked and dark in Edge too. I think its taking theme setting from Win 10 system theme. Hope that helps, Happy New Year to you, kind regards,

@@MaxDrake Thank you!

Yes you can, but I'd ask why you would want to? The method: You would create a simple AutoHotKey file with the script you have for opening Watsapp. You do not need to give this a hotkey in the script ( ie the Tab + w) as there is only one function/script that just activates the watsapp .exe file , name the AutoHotKey file watsx.ahk You can then, in MaxLauncher select a button (eg Tab 1 and button D say) for activating this script and using the target (in edit mode) point to that AutoHotKey script watsx.ahk Then when you activate MaxLauncher (in my case using Ctrl+ Spacebar, I'd then hit the D key on the keyboard and it would activate the AutoHotKey script that would then activate the Watsapp. Alternatively, instead of creating that script, you could, in MaxLauncher select a button (eg Tab 1 and button D say) and using the target (in edit mode) point to where Watsapp.exe is directly. That will work just as well, and you do not need to use AutoHotKey at all. This brings me to another point. generally have all With your AutoHotKey method, you just need to remember the hotkey ( ie the Tab + w) and activate the watsapp program. This is fine if you use it all the time. But if you open Watsapp infrequently and can't remember the hotkey you assigned to it, then using MaxLauncher you can look on the different tabs for where you located it. I generally have a lot (30) on tab 1 that is default tab so I can look for things I use all the time and don't want as hotkey for. With MaxLauncher it is a 2 hotkey process. First you have to use your default hotkey to open MaxLauncher, as stated before, for me this is ctrl + spacebar, then you need to select the key to activate the specific program that you want, in this case the D key. So what you currently have in AutoHotKey is more efficient and as long as you have lots of hotkeys spare to use. If one the other hand you want hotkeys for a lot of things you use less frequently, then MaxLauncher is great for that. I personally use 1/ Hotkeys, 2/MaxLauncher and also 3/Executor, and 4/Quick Access Popup (useful for middle key on mouse (pressing roller) which brings up file menues and scripts) I also use aText as well for other hotheys and text expander as its great for adding a quick Expander or script on the fly and can use Hotstrings to activate. I personally find hotstrings easier to remember but it means typing two or more keys one after the other to trigger the hotstrings eg 'em' for email or 'st' for my stuff news site in NZ that will open browser and then the url of the stuff website. MaxLauncher is great for having stand alone AutoHotKey scripts such as turning on/ off cross hairs on my screen (2 MaxLauncher buttons with 2 separate AutoHotKey files. I also have AutoHotKey scripts with multiple hotkeys and hotstrings and have a MaxLuncher seperate buttons to 1/ open the AutoHotKey scriptss for editing, 2/Reloading the AutoHotKey scripts after editing 3/ Loading those AutoHotKey scripts from scratch if I do not load them on startup (which I commonly do for my most popular ones). Its worth getting familiar with and playing around with as it’s a great program. Seasons greetings and best wishes for the New Year, kind regards,

Hi, Good luck with that. I did quite a bit of work trying to set it all up a while ago. Here are some article links on doing it: cr8ive.tk/?s=openMaint Also , you may want to consider Asset Tiger. cr8ive.tk/?s=asset+Tiger Its in the cloud and so far less for you to manage. There may be costs depending on the size/quantity of your assets but far less effort to get up and running. Good luck with your project, Kind regards,

Hi @thepragmatic6383, I haven't been doing anything in this space for a while and am away at the moment, so can only give a couple of suggestions. 1. There are a couple of other videos you can look at for setting up AHK2 with VS Code: ruclips.net/video/QPl1sla67Bo/видео.html ruclips.net/video/lriIagKo9rY/видео.html ruclips.net/video/TUwmf2qSuXs/видео.html also on ahk forum www.autohotkey.com/boards/viewtopic.php?t=102798 2. The /ErrorStdOut=utf-8 error the utf-8 is the file encoding. So what this is saying is that it is trying to read the C:\Program Files\Autohotkey\v2\AutoHotkey64.exe file as a text file, not executing the .exe file so absolutely nothing to do with French version of Windows 10, or keyboard configured in French/Canada 3. If you were to try and run a AHK 2 script, say 123.ahk, then you could do this with a batch file, or on command line in the command console by pointing to the ahk executable, we will assume its C:\Program Files\Autohotkey\v2\AutoHotkey64.exe and then at the script you want to run, so on command line c:> C:\Program Files\Autohotkey\v2\AutoHotkey64.exe 123.ahk So this would run the AutoHotkey64.exe executable then run the script file 123.ahk So what I think is happening is that you have not created a ahk environment/configuration in VS Code that associates the .ahk with the program it needs to run it, in this case C:\Program Files\Autohotkey\v2\AutoHotkey64.exe I cannot recollect offhand how I did that. One suggestion on the forum : '' If you install AutoHotkey v2, it will ask you which editor to use the first time you attempt to edit a script. VS Code should be detected automatically, so you can select it from the list. This list can also be accessed from the Dash at any time, to change the default editor." I hope you get it sorted soon, kind regards,

Hi balkiraly_ , Glideapp wanted to push their new template format so closed their classic app format, of which the above app was developed in. So sorry, it is no longer available through the Glide Template store. I wish you well with your project, kind regards,

@@MaxDrake Thank you for your reply! I am sad to hear it, but keep up the good work Max!

If you look at the description below video you will see a link there for code. kind regards,

​@@MaxDrake thanks sir🙌

Hi sese, I presume you are on PC. The Python Tesseract package was pretty good . If you are on PC why don't you downoad PowerToys (learn.microsoft.com/en-us/windows/powertoys/) that has a text extractor from a screenshot, a much faster workflow. I do find when getting text from OCR that its rarely 100% correct so you have to back edit, so something I personally would explore is something like OCR (Optical Character Recognition) with world-class Google Cloud AI (cloud.google.com/use-cases/ocr) as the AI part may do some correcting for you and speed up the process and reduce back checking. Good luck with your project , kind regards

I reread your comment sese and if its in spreadsheet format I came across this feature in Excel (support.microsoft.com/en-us/office/insert-data-from-picture-3c1bb58d-2c59-4bc0-b04a-a671a6868fd7) that may be of use. It does require you to have excel but you may be able to get a trial version. There are a few text to speech packages for python (duckduckgo.com/?t=ffab&q=python+text+to+speech&atb=v305-1&ia=web), I personally find the voices a bit mechanical. Kind regards

It sounds as if you have a much better understanding of classes than I do, perhaps you'll make a video and send me a link? I'm just trying to slowly figure them out, and recording the steps I'm taking, so that on my next attempt I don't fall back into the same trap as previous attempts when I fail.

@@MaxDrake ​ @Max Drake I see. I literally started trying to understand classes watching your videos. I wrote some advanced scripts using regular functions and commands, but I felt that I need to learn more about classes if I want to branch out to JavaScript or python or even to Autohotkey v2. Here's what I know about variables. Autohotkey documentation says this about static variables: "Static variables are always implicitly local, but differ from locals because their values are remembered between calls." While reading the code to run it, the value of a static variable would get affected and remembered. That's why static B:=2 is remembered. but only inside that instance of the method. another instance can have another value for B. These values can be changed at any time for any instance, and the new value will be remembered within each instance. But local variables (or instance variables) will be forgotten as soon as the method/function finishes, even if their value was read. That's why a := 1 is forgotten and returns empty. It is equivalent to "local a:= 1". they are only made to be used internally within the function/method (or maybe returned with "return a"). Global and super-global variables are a bit more complex. A super-Global variable needs to be declared outside of functions, and functions can access its value (the function looks first for a local variable with that name, and if it doesn't find one, it looks for superglobals that have that name). Ex: global MySuperGlobalVariable := 1 MyFunction{ msgbox, The value of MySuperGlobalVariable is %MySuperGlobalVariable % ;;; this would return 1 } but the function won't be able to modify the value of the superglobal: Ex: global MySuperGlobalVariable := 1 MyFunction1{ msgbox, The value of MySuperGlobalVariable is %MySuperGlobalVariable% ;;; this would return 1 MySuperGlobalVariable := 3 } MyFunction2{ msgbox, The value of MySuperGlobalVariable is %MySuperGlobalVariable % ;;; this would return 1, not 3 } This code will keep the value of MySuperGlobalVariable equal to 1, to be read by any other function. It won't be modified by MyFunction1. MyFunction1 will instead create a local variable also named "MySuperGlobalVariable " to work with it internally, but keep the value of the super global intact. This however will tell MyFunction1 to modify the value of the super global, instead of creating a local variable with the same name: Ex: global MySuperGlobalVariable := 1 MyFunction1{ global MySuperGlobalVariable msgbox, The value of MySuperGlobalVariable is %MySuperGlobalVariable% ;;; this would return 1 MySuperGlobalVariable := 3 } MyFunction2{ msgbox, The value of MySuperGlobalVariable is %MySuperGlobalVariable % ;;; this would return 3, since we instructed MyFunction1 to change the value of the super global }

?

​@@MaxDrake sorry. It's a joke because she's large and rude. Thanks for the video very informative!!

Hi Pucho, AHK command picker by deadlydog. from github.com/deadlydog/AHKCommandPicker This is a little fiddly setting up and he has good videos on it. I also made a video about it ruclips.net/video/bSoZLhUuRxk/видео.html Lexikos wrote it for Version 2 based on another in version 1. (lexikos.github.io/v2/docs/scripts/index.htm#KeyboardOnScreen) www.autohotkey.com/docs/v2/scripts/index.htm#KeyboardOnScreen I hope this is of help to you, kind regards,

Glad it helped.

Thanks. Have you any tips/tricks for aText? I'd love to know about them. This is one of my Go-to productivity tools and use it hourly throughout the day.

I´m sorry Max. What I have achived with aText is nothing next to you.

@@IFRAASESORES I'm sure you'll be doing good stuff with it. When you do do something that you find really useful and helpful share it around, so we can all use it more effectively. kind regards,

Hi Zitrolena, thanks for pointing that out. I also found this video by Sergio: ruclips.net/video/qt4g7Djy5AE/видео.html That shows him embedding a video into a note and it shows the thumbnail in edit & preview mode. This works for me as I usually just work in edit mode only. Sergio's method does not require the Simple Embed plugin, but I do note that the plugin is for other embeds such as twitter, instegram, Reddit and others. As I generally just have RUclips vids I'll personally go with the embed process. Thank you very much for pointing the plugin out, I hope that will help others too, kind regards,

That sounds interesting. So not the Obsidian sync but the one at syncthing.net/. I had to look that up (an article- beingpax.medium.com/how-to-sync-obsidian-notes-across-different-devices-for-free-326423218597). So the Obsidian folder is on your main PC? Or stored in the cloud? I'm wondering if you have to have the main computer on all the time to allow the Syncthing to work (my scenario is I hop between 2 laptops during the day). This sounds like a great solution for accessing it on mobile, my current solution doesn't work for that. Thank you for sharing that, I may have to explore using syncthing, currently playing with single folder and Obsidian & Logsec both linking to the same place. kind regards,

@@MaxDrake Hi. I've got syncthing installed and set up in my desktop pc - with ubuntu, my laptop - with manjaro, and on my android xiaomi smartphone. It syncs without issues between the 3 machines. That means, for the sync to happen, you have to have at least 2 machines running at the same time during the sync proces, not a problem I think. The other thing is, do not edit the same file on 2 machines at the same time - you might run into issues. But there's a version controlo in syncthing, that I've never used - maybe that could help you even further.

@@GustavoMontanha Thanks for that, I like the idea of having it on mobile. The editing on 2 places before a sync would be an issue but generally that isn't going to happen. I watched a video on it and that persons setup was to sync with a NAS as central repository (so would always be on) and I'm going to explore that scenario. I appreciate you highlighting the syncthing program, I was totally unaware f it and I'm currently having backup issues so this could be a nice piece of the puzzle for smaller more critical folders I work with. So thank you again for bringing it to my attention and describing the program and how you use it, kind regards

Hi Ernesto, Thanks for telling me about Logseq. I wasn't aware of it. I came to Obsidian from a different direction, found it worked and have been using it since. This looks like it is a similar Knowledge Base tool. I'll have to download it and give it a try. I presume you are using Logseq. In your opinion what are the outstanding features that make this better/different/more useful than Obsidian if you were recommending it to others? Thanks again for pointing this out, kind regards,

I hope it helps. Thanks for your kind comment, kind regards

Hi Peter, Sorry this is not a good time for me as I'm away from home visiting my daughter. So have not go access to my normal information. I haven't been using glideapps for a while so I'm a bit rusty. I would suggest you look at Learn Google Spreadsheets- his playlist here for GAS ruclips.net/video/aPJ-2U45BpA/видео.html, or else post a query on the glideapps community forum, community.glideapps.com/. Someone there should be able to help you more quickly. If I recollect you let the data from Glideapps go to one Google Spreadsheet and then have a GAS script running on another Google Sheet that listens to the first sheet. When new data is added (from Glide to the Google sheet) it takes that data and copies it across into your GAS ssheet where you can then do operations to it. will be away for two weeks. If you have not found a solution by then please contact me again in the same way and I'll try and resolve the issue you have. I'm sorry I cannot be of more help at this moment. Good luck with your project, kind regards,

@@MaxDrake I so grateful for your advice, I will contact the glide community to see if they will help. Thanks so much.

Hi Roulette, Here is link to the app, testpfapp.glideapp.io/, this may/may not work. I haven't been working on /glide Apps for a while , but here is code you asked for. A please would have not gone amiss. Best of luck in your project, GAS script below: //This adds menu in Sheet function onOpen() { var ss = SpreadsheetApp.getActiveSpreadsheet(), options = [ {name:"onEditDateTime", functionName:"onEditDateTime"}, {name:" display-CopyFormula", functionName:" CopyFormula"}, {name:"datetime-CopyFormula", functionName:"CopyFormula1"}, // {name:"Say Goodbye", functionName:"sayGoodbye"} ]; ss.addMenu("Scripts", options); } //THIS IS FOR SPENDING SHEET //Creates a Date Stamp if a column is edited. //CORE VARIABLES // The column you want to check if something is entered. var COLUMNTOCHECK = 1; // Where you want the date time stamp offset from the input location. [row, column] var DATELOCATION = [0,0]; // Where you want the date time stamp offset from the input location. [row, column] //var TIMELOCATION = [0,16]; // Sheet you are working on var SHEETNAME = 'out' function onEditDateTime2(e) { //return; var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); //checks that we're on the correct sheet. if( sheet.getSheetName() == SHEETNAME ) { var selectedCell = ss.getActiveCell(); //checks the column to ensure it is on the one we want to cause the date to appear. if( selectedCell.getColumn() == COLUMNTOCHECK) { var dateCell = selectedCell.offset(DATELOCATION[0],DATELOCATION[1]); //var dateCell = selectedCell.offset(0,-1);// dateCell.setValue(new Date()); //formatting date/time for calendar on app dateCell.setNumberFormat("mm/dd/yy hh:mm"); } } } //this does display- So concatenates a few things function CopyFormula3() { var ss= SpreadsheetApp.getActiveSpreadsheet(); var sht = ss.getActiveSheet(); if( sht.getSheetName() == SHEETNAME ) { ss.getRange ("I2").setFormula("=CONCATENATE(\"$\",B2,$K$1,C2,$K$1,D2,$K$1,H2)"); var lastr=sht.getLastRow(); // column 10 (col 9?) var fillDownRange= sht.getRange(2,9,lastr-1); ss.getRange("I2").copyTo(fillDownRange); } } //this does datetime function CopyFormula4() { var ss= SpreadsheetApp.getActiveSpreadsheet(); var sht = ss.getActiveSheet(); if( sht.getSheetName() == SHEETNAME ) { ss.getRange ("J2").setFormula("=A2"); var lastr=sht.getLastRow(); //col 11 (col 10?) var fillDownRange= sht.getRange(2,10,lastr-1); ss.getRange("J2").copyTo(fillDownRange); } } ////this does time - dummy for calendar view //function CopyFormula2() { // var ss= SpreadsheetApp.getActiveSpreadsheet(); // var sht = ss.getActiveSheet(); // if( sht.getSheetName() == SHEETNAME ) { // ss.getRange ("Q2").setFormula("=$R$1"); // var lastr=sht.getLastRow(); // //col 17 // var fillDownRange= sht.getRange(2,17,lastr-1); // ss.getRange("Q2").copyTo(fillDownRange); // } //} // this is for formatting dates/currency on function FormatCols2() { var ss= SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); if( sheet.getSheetName() == SHEETNAME ) { // Single column var col0Date = sheet.getRange("A2:A"); var col1Date = sheet.getRange("B2:B"); // Simple date format col0Date.setNumberFormat("mm/dd/yyyy hh:mm"); // Simple currency number format col1Date.setNumberFormat("$#,##0.00;$(#,##0.00)"); } } //THIS IS FOR JOURNAL SHEET /* I don't think var selectedCell = ss.getActiveCell(); is working, Maybe find lasrt row nextSheet = ss.getSheetByName("Fixed"), */ function onDate2(e) { //return; var SHTNAME = 'Journal' var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); //checks that we're on the correct sheet. if( sheet.getSheetName() == SHTNAME ) { var col0Date = sheet.getRange("A2:A"); //PUTS IN DATE AUTOMATICALLY ON NEW ENTRY var lastRow = sheet.getLastRow(); sheet.getRange(lastRow,1).setValue(new Date()); //FORMATS DATE // Simple date format col0Date.setNumberFormat("mm/dd/yy hh:mm"); } }

Hi Георгий Лаврентьев, Depending on your duration time slots, say .5h, If someone wanted 2 periods, they would have to select each separately and enter each as an individual booking. On the main page, once they had selected a date, in my example for barber, say they wanted a service that takes an hour, they would need to see if there were 2 available times, side by side then they would need to book them both. You could set up that each day had instead of all .5hr slots that it also had specific 1 hour or 1,5 hour slots as well if you wished, so someone could book one of those. In the app its for booking, not paying, so they will pay when they come for service. I hope that answers your question, kind regards,

Hi, an interesting thought. I do recollect in the GlideApp chat that someone was developing their own booking app, that was a while ago. I suggest you 1/ look at the Glide Templates, see if there is one there that has been pre-built, 2/ Look on the GlideApp forum, Ask the support at GlideApp if they know of anyone doing that and see if they will get them to get in touch with you. Best of luck with your project, kind regards,

Hi Maxat, Thanks for letting me know, I've added a line at the top to highlight your update. kind regards,

Hi Intimatical, I suggest you go to the developers website for more information (www.dropitproject.com/). I did that video a while back (2019) and haven't used the program for a while as I use AutoHotKey s to do my file management tasks What I'd suggest you do is make a few dummy folders and put a few files into those and make a few rules and see if they work. Then you can use it for your main files. best of luck with your project, kind regards

Maybe one day!