Jump to content

ixium

Member
  • Content Count

    70
  • Joined

  • Last visited

  1. ok that sounds like the avenue I should head down, thank you so much for looking at this for me, you have been quite helpful throughout the years!
  2. Awesome, thank you, this is written in googles script editor, I have no idea how to get it to link back to my alfred, thank you function newClient() { var clientName = ('Last Name, First Name - Company Name'); var clientFolder = DriveApp.createFolder(clientName); var masterClientFolder = DriveApp.getFolderById("0B2Xyh0kSszIcYXJtemlSSUNlYUE"); masterClientFolder.addFolder(clientFolder); DriveApp.getRootFolder().removeFolder(clientFolder); var clientFilesFolder = DriveApp.createFolder('Files'); var clientNotesFolder = DriveApp.createFolder('Notes'); var clientReportsFolder = DriveApp.createFolder('Reports'); //add new folders to new client folder and remove extra root drive folders clientFolder.addFolder(clientFilesFolder); DriveApp.getRootFolder().removeFolder(clientFilesFolder); clientFolder.addFolder(clientNotesFolder); DriveApp.getRootFolder().removeFolder(clientNotesFolder); clientFolder.addFolder(clientReportsFolder); DriveApp.getRootFolder().removeFolder(clientReportsFolder); var ss = SpreadsheetApp.openById("1BEcSVNy2esknAtcKc5-W_cV-PQy0yJAKt4rdLizrgNc"); var newSS = ss.copy(ss.getName () + " for " + (clientName)); // Move to original folder var newSSFile = DriveApp.getFileById(newSS.getId()); clientFolder.addFile(newSSFile); DriveApp.getRootFolder().removeFile(newSSFile); var ss2 = SpreadsheetApp.openById("1uIbex2ACiIa8AINjivwfLQldQSvMqMZ-Hyl1msbj8Tg"); var newSS2 = ss2.copy(ss2.getName () + " for " + (clientName)); // Move to original folder var newSS2File = DriveApp.getFileById(newSS2.getId()); clientFolder.addFile(newSS2File); DriveApp.getRootFolder().removeFile(newSS2File); var ss3 = SpreadsheetApp.openById("1rbyaBq5dQuYMwOtv1isZg0Bf2OHY3W3eaL4zP_wayhY"); var newSS3 = ss3.copy(ss3.getName () + " for " + (clientName)); // Move to original folder var newSS3File = DriveApp.getFileById(newSS3.getId()); clientNotesFolder.addFile(newSS3File); DriveApp.getRootFolder().removeFile(newSS3File); } So its just taking my input of name (Last name, first name - Company) and making copies of files I have in a template folder. So all I need to do is be able to run this script from within alfred and have it pass the argument to the var ClientName Thank you so much for looking at this
  3. well thats a good sign. Ok to add script here? It references files but I dont think anyone could access them without being in my account right? Or should censor it or PM you the code?
  4. I havent had any luck with this as I know its pretty complicated. I do have one more question for you if you dont mind (and thank you so much for all the help you have provided throughout the years!) The script I wrote about above is a google script and only requires one thing to be changed, the name field, which propogates all the documents with the right names. What im wondering is, is there any way to trigger this script from within alfred and pass the one variable I need to the script. Right now I have to open the script (which I do with an alfred shortcut) change the varialbe I need and then run it, Im just wondering if I can hotkey open alfred, type the name and hit enter to run the script. Just not sure if Alfred can interact with google that way. Thank you so much!
  5. Hmm not sure how that would implement, thinking about it now, maybe I could do it with IFTTT and another program, not really sure how to accomplish this, thank you for taking a look
  6. Good Morning, I am writing on a whim here so no rush or urgency, I just have always had great success bringing my ideas to the table here and seeing what others think. I run a web hosting / design company, and use Alfred every day all day for many of my tasks. One of my organizational techniques is Google Drive with a huge client folder structure where each client has a folder (last name, first name - Company name) and then inside each folder I have sub folder (files, notes, etc) and even a password doc that gets changed for each client (Passwords for Last Name, First Name - Company name) and the same with general information. I tell you all of this so you can see how it connects with alfred. I then use the a Drive workflow from this forum to query the drive for the files im looking for quickly. IE: Open Alred >> D passwords for clients name shows me that document and I can open right there. First thing I want to know, and I know this is a long shot. Any way to make it show the contents of that doc in alfred (I would imagine it couldnt pull the data, but just wanted to throw it out there0 Then my main question. Is there any way I can use this same type of flow, (make a google docs file called Notes for Client Name) and be able to add content to it straight from alfred. It would be extremely helpful to have a way to add a quick 1 line note to a clients files for when we make changes that need to be documented or time lined. So I would say Open Afred >> Notes for client name >> Made changes to adword account 8/24/2018, and that would be written write into that notes file I created, and every time I did that it would just be added to a new line (could be a spreadsheet) Any thoughts, I know its a long shot but ive seen that great workflow I sheet you not that interacts with sheets. Thank you for any suggestions!
  7. Wow thank you for taking the time to explain that to me, I understand a little more and now this command is working flawlessly, thank you so much! You are always an amazing help deanishe
  8. yep that what I was using, but how would I run this command through script ssh <host> pmset sleepnow´╗┐ Wouldnt I need to call terminal and everything, sorry im very novice with all of this
  9. Hmm so the code is working great (was having a hard time with being on the right network) but now Im running into how to close terminal after the command is complete. I can send through the command+q command and that works well, except when the command is still running, any way to make it exit after finishing the command? I know im knit-picking now so no problem if not! Thank you both for your amazing help
  10. Worked perfect once, now its hanging, not sure whats going on, may try the other method
  11. ssh <host> pmset sleepnow´╗┐ Seems to do exactly what I needed, thank you so much!
  12. gonna take a stab at all this now will let you know what I see
  13. Im sorry I should have clarified, I do have keys set up I believe as it doesnt require password anymore
  14. Good morning, this is one I've been trying to accomplish a few times but have hit walls many times as my knowledge is limited. I have a computer in the office (imac) that we use as a display only. I want a simple workflow to run on my macbook that would sleep the machine. I can do it with a few commands manually by SSH into the machine, then run osascript -e 'tell application "System Events" to sleep'. But for some reason I cant get past this. I see 2 ways forward and havent figure out how to do it either way. Firstly I believe theres a way to send the command via SSH without first logging in, but I cant get this to do anything so im sure my syntax is wrong, I am trying to do it like this ssh username@192.168.1.xx 'osascript -e 'tell application "System Events" to sleep'' so im sure thats wrong as when I run that from my computer nothing at all happens. So in light of that not running I was thinking, make alfred run the ssh command, then paste in the second part osascript -e 'tell application "System Events" to sleep' press enter, wait then clsoe terminal, but for some reason this isnt working either, which makes no sense as Im doing the same thing I manually do just through alfred simulations Not really sure what to do, anyone got any ideas? I feel like its really simple and I just lack the knowledge
  15. wow, well that was a much different solution than I thought. But that worked, it opened a new instance of chrome that allowed me to sign in to a different account, what exactly is happening with this, because it asked me to make chrome default, like it was a completely fresh install. Also, thank you so much for your help with this!
×
×
  • Create New...