I LOVE this video-and I've watched many, many other how tos-because you have no BS, no introduction, no talk about yourself, no blather, just "do this, then do this, then do this." It's great. I've subscribed.
@kiransankarpati
Жыл бұрын
This is the best apple oriented channel , And I will not be tired to say it over and over again. ❤❤😊
@ivo1107
Жыл бұрын
Congratulations for the video. I was looking for ways to create automation to control my credit card expenses. Worked perfectly. Thank you very much.
@SoNowWhat
2 жыл бұрын
Gary - thanks for this. I'm slooooowwwwwly starting to see the value of Shortcuts (and how to build them)!
@damiantosd8720
11 ай бұрын
This was really helpful. I have never really used numbers but I wanted this to log quickly a customers time off a support bucket without opening excel and adding it etc now I can do it on the go. Awesome.
@martrom0
3 ай бұрын
Man, you are the best !! With these native macOS functionalities you can automate complex databases !! What about using Siri !? It would be wonderful ! the more I follow your tutorials the more I realized how macOS and Apple ecosystem in general is so powerful, even it seems simple ! Thank you !!
@Alvinladen
2 ай бұрын
You are changing my life! Many many thanks!
@StusReviewsUK
Жыл бұрын
Great tutorial, thanks!
@gabebarton
Жыл бұрын
I just made a medication tracker with an NFC tag trigger with this info. Thanks for the informative video!
@djsotosmc
2 жыл бұрын
Hey Gary! Really loved that one! What intrigued me most is the part with the scripting for manual input in cells. Tried it on my own spreadsheet and worked like a charm. What I would really want, though, is to make an automation with shortcuts and a little scripting, for tracking my daily expenses in my existing spreadsheet. Unfortunately, I don't know how to script my daily expenses to be added in the appropriate cells.. would be really neat if I figured out a way to just input the daily amount and the rest be done automatically.
@macmost
2 жыл бұрын
If an expense is a "row" in a table, then just use the main Shortcuts technique I show here to add a new row to the end of that table. Every time you have a new expense, add it to the end of that table. Then build whatever you want around that "Database" of expenses using other tables and sheets.
@FelipeMC0810
2 жыл бұрын
@@macmost I have just created one shortcut for that. Awesome Now I work in a JavaScript to pull the total expense for the period and show in the screen at the end of the shortcut run.
@fabiofossati309
3 ай бұрын
Thank you I finally did it. You save me a lot of work
@michaellina5124
9 ай бұрын
Hi Gary Just would like to thank you for! All your tips are so useful 😊
@erikasellshomes
2 ай бұрын
Fantastic video, you made it so simple. Thank you,
@woonyag
Жыл бұрын
You are very good at explaining! I could understand in just one time! Thank you so much😊
@TheMechanicalBob
Жыл бұрын
Thank you for the straight-forward and simple video, it helped me a lot! 👌🏽
@pumpkinspice1456
Жыл бұрын
Soo helpful! Thank you… I had a very complicated shortcut solution for this. You made it way easier for me 🙏
@99cya
4 ай бұрын
that was very helpful. thanks. its a pity i cannot run this shortcut from my apple watch. i would have used it to record my distances in my different running shoes. it works great on iphone/mac tho.
@Craig-MItchell
Жыл бұрын
All these seldom used tips are very useful 👍🏻 Thanks a mil 🍀
@JustinZymbaluk
2 жыл бұрын
This is awesome, and I love how this tutorial works for iOS shortcuts too! Cool system and thanks for the video. Subscribed!
@jovalero8798
Жыл бұрын
Hey Gary. Great introduction to use shortcuts with numbers. Can you make a video how to copy a value of an internet site within shortcuts and THEN create a new row in numbers ? Would be very helpful
@macmost
Жыл бұрын
Just start this shortcut with getting the contents of the clipboard to use in the data you are inserting.
@Alnasrlina
Жыл бұрын
Incredible! Excel and windows doesn't really have an equivalent as well implemented as this.
@fast-end
Жыл бұрын
Are u sure? I'm two steps away from buying excell because of data scraping functionality and some addin features like maps. I don't know how to handle a map directly in numbers, perhaps you know. But I think the shortcuts app is extremly powerful - I haven't seen a ms equivalent yet. I need to get more in to it, perhaps this will help me with my questions.
@dgol10
5 ай бұрын
This is amazing! You explain everything so well! What if instead of an event, I wanted to add a reoccurring number every time and not have to click anything. Is that possible?
@macmost
5 ай бұрын
Do you mean an incremental number? Like 47 on the last row, and then 48 on the row below? You wouldn't have that as part of the insert, but a formula on that row that looks at the cell above and adds one, like =A9+1 (that's what it would look like in A10, etc). But to skip that cell you need to use Shortcuts to create a List first, then skip the value in the list for that cell. Then insert that list. So you'll need some more Shortcuts programming skills to do it.
@964cuplove
4 ай бұрын
Sweet !! I’m looking into recording worktimes. Can I choose the line based on the date in column 1 and then fill in my starting time / ending time with two shortcuts ?! Could you display a dialog and ask for the breaks duration for that day ? Could you throw up a dialogue if the field ready contains a value ?
@macmost
4 ай бұрын
You can do a lot of that. Play around with it.
@loisskiathitis8926
2 жыл бұрын
A very useful video tutorial today! 👏🏻❤️
@Chrisdgallego
5 ай бұрын
I'm gonna try this with cooordinates and numers from ios. I wonder if I could use google sheets instead.
@venkataramayya4266
2 жыл бұрын
May I suggest that there is a Swim Lane chart to describe the process?
@vrajesh2576
Жыл бұрын
Nice video ❤ thanks for sharing
@GoatsFantasy
8 ай бұрын
How can I make it to have multiple cells. My table has 12 cells with each one having multiple options to fill so a list would be too big. Anything you recommend to alter this shortcut?
@bobcleaver
2 жыл бұрын
incredible, thank you
@celkat
2 ай бұрын
Thank you for this excellent tutorial. When following along, it seems that I need to have the Numbers document open in order for Shortcuts to write to it, whereas you state at 4:06 that the shortcut writes to the spreadsheet whether open or closed. How can I get Shortcuts to write to the Numbers file in the background (i.e. no visual foregrounding of any apps during the process) and without explicitly opening the Numbers app? Thanks! Edit: I'm using MacOS Sonoma 14.5
@macmost
2 ай бұрын
It will open the document for you. Numbers has to be open to take the action.
@alvink9842
2 жыл бұрын
Thanks for this, Gary! By the way, if you build the shortcut on the Mac, will the same shortcut work when it’s being run on the iPhone?
@marke2401
2 жыл бұрын
I was curious about that as well.
@macmost
2 жыл бұрын
Yes. These actions are on the iPhone too. As long as the spreadsheet is in iCloud so it is available in both places, it should work. Try it and see.
@thomahammer9581
2 жыл бұрын
Gary, you are amazing, but i have to slow your presentation down to 75% in order for me to stay on track.
@harryhellerman474
2 жыл бұрын
Very helpful!
@marke2401
2 жыл бұрын
That is awesome Gary! I was thinking if there is a way to do it, could you make a video teaching us how to use Siri with a similar Shortcut to record receipts into such a spreadsheet. Say for restaurants or groceries for example.
@macmost
2 жыл бұрын
You can do that, yes. It would be a long Shortcut though, not difficult, but lots of steps. Might do it.
@andreajaquelinearellanodia6250
Жыл бұрын
I would love to see this too! I use google spreadsheets to track my expenses
@marke2401
Жыл бұрын
@@andreajaquelinearellanodia6250 he posted a follow up video to this. I set it up on my iPhone and use it all the time using Siri. Very handy.
@HrSamstag
2 жыл бұрын
Exactly what I was searching for, very good explained! Thanks!
@HrSamstag
2 жыл бұрын
But what confuses me that the „quit app“ on the iPad iOS version is not available. 🤔
@sxgroups
7 ай бұрын
Amazing piece of information on using shortcut into Numbers. THANK YOU.
@ar01464
7 ай бұрын
Hi, can you please do a video on how to use the apple pay automation to log expenses in numbers spreadsheet. 🙏
@macmost
7 ай бұрын
Just give it a try. Select Transaction as an automation. It may even show an action to add to a Numbers document as the very first suggestion after that.
@robynbirde
Жыл бұрын
This is soo helpful! A quick question, how do I create a new spreadsheet and then have the new rows be added to the new spreadsheet? When I use the add row action, it only seems to let me choose from an existing file in File Picker. Do I have to create an action to save the new spreadsheet first? Then add to it?
@desertpatient
2 жыл бұрын
Thanks bunches
@jasperjames7934
2 жыл бұрын
Hey Gary love your videos! For some reason I cannot get this to work though. When I add in the second variable (choose item) it deletes the current date variable. It shows both until I run the shortcut and only the chosen item from list appears. Any ideas on how to fix this? Thanks!
@Mahdi.jamalll
Жыл бұрын
Thx 🙏🏻
@mattb9371
11 ай бұрын
Gary, this is a great tutorial. How would I also ask for input for same row, but column B3? (i.e. more data on same row)
@macmost
11 ай бұрын
You can't. There is just this one action to add a new row. The idea is to design your tables so one row = one data record.
@apeel2008
2 жыл бұрын
Is there some sort of manual or user guide for the Shortcuts app?
@macmost
2 жыл бұрын
Launch Shortcuts. Go to Help, Shortcuts Help.
@apeel2008
2 жыл бұрын
@@macmost Thanks. Great tip!
@pseudomino3
10 ай бұрын
Can I add more than one input per line? I wanted to add a description and a number value into different cells on the same line.
@macmost
10 ай бұрын
Yes. I show that here.
@markvulcano7095
7 ай бұрын
Love your channel. Good information! Question, is there a way to create a keyboard shortcut for adding a Comment to a cell in Numbers so I don't have to keep going up to the tool bar to click on this?
@macmost
7 ай бұрын
If you look in the Menu Bar you'll find the Comment command in the Insert menu. And you'll see the keyboard shortcut for it right there.
@markvulcano7095
7 ай бұрын
Ty, I see this but it doesn't work, and its 3 keystrokes. is there a way to change this to just one keystroke?@@macmost
@macmost
7 ай бұрын
@@markvulcano7095 Not sure what you mean. Just one step when I try it: Shift+Command+K. Then I can immediately type in the comment. Do you mean you want it to be a single key and not a three-key combination? Only so many keys on the keyboard, but I suppose you could assign it to an F-Key. kzitem.info/news/bejne/1Gx4smamkIt_mXY
@markvulcano7095
7 ай бұрын
Yes, I want to assign this to just one key, not 3. I will check out the link you sent. thank you!@@macmost
@prodigaldoctor
6 ай бұрын
Could we also enter data into the tables in apple notes through apple shortcuts. Though I have been automatically feeding the data in apple notes through shortcut but is it possible to feed data into tables of apple notes through shortcuts? Please let me know.
@macmost
6 ай бұрын
I don't think so.
@mortadharaad5892
2 жыл бұрын
Hey Gary It’s really good illustration Thank you I have a question? Can i run javascript on iPad to change specific cell in number sheet to specific value provided by shortcut
@macmost
2 жыл бұрын
No, JavaScript isn't an option on an iPad.
@RandallLeeReetz
10 ай бұрын
Gary, Nice. So was wondering how to reference a Shortcuts variable within the javascript (to insert the contents of a variable instead of a string as you have shown). I want to add the contents of the DateTime var we've defined in shortcuts to the javascript youve shown such that I can fill a particular numbers cell with that variable instead of the quoted string your example shows.
@macmost
10 ай бұрын
One way is to right+click in the text of the script and insert the variable right in there.
@dawesten
2 жыл бұрын
Works Great! Tried to make it work for Excel, but get error message that the script expected ";" after "Excel".
@macmost
2 жыл бұрын
This is for Numbers, not Excel.
@dawesten
2 жыл бұрын
@@macmost Yes, I know it is for Numbers. It works perfectly. Can you point me to a source where I could find javascript to do the same thing for Excel (and run the Java code with Shortcuts)?
@macmost
2 жыл бұрын
@@dawesten Sorry, I don't know of any source for code that will do it in Excel. Excel would need to have the hooks built into the app to work with such JavaScript/AppleScript code and I'm not sure if it does (JavaScript is different than Java so don't use "Java" when searching BTW).
@HoneyLaBronx
5 ай бұрын
I'm a spreadsheet addict and would REALLY prefer to stick with Google Sheets rather than Number. Does anybody have instructions on how to do this using Google Sheets (via IFTTT)?
@dane480
3 ай бұрын
I’M THE EXACT OPPOSITE! I’m newer to spreadsheets so I don’t have years of using one over the other. I love the iOS ecosystem because I have an iPhone and I’m broke so it’s pretty much my computer. Trying to use the native apps is tough because numbers doesn’t have as many tutorials as sheets or excel..
@ineedvicky
Ай бұрын
I’m with you on this, I’m studying this tutorial as hard as I can to try and figure out how to do this either with google sheets or with excel. I’d particularly love to figure out a way to automatically export data from numbers into excel, because that’s where my programmer husband set up a spreadsheet where he likes me to do my business bookkeeping (to make it easier on us when it’s time to do our taxes)
@MortyP
11 ай бұрын
I love this. How would I use this as a food log to monitor our diet if considering adding more details to it. For example, a 'Rating' column could be included to assess the quality of our meals. I could also introduce a 'Person' column to denote who is making the entry.
@macmost
11 ай бұрын
Yes, you certainly can build it out to do that.
@MortyP
11 ай бұрын
@@macmost @macmost That’s great - thank you. However, I’m having a hard time figuring out where in the shortcut the ‘path,’ for lack of a better word, for the respective column is to input further information. Are there not only four variables here: the date, sheet name, the sheets table, and the path of the Numbers document on your computer. Correct? How do I tell it to input info into the additional yet to added column/s i.e.; "Rating," "Food name," and "person rated" columns? Thanks again, Gary. Your videos through the years have made me a more efficient Mac user.
@macmost
11 ай бұрын
@@MortyP They are just in order, one after the other. I assume you are using the Add Row to Top Or Bottom of Table shortcut action.
@MortyP
11 ай бұрын
@@macmost Precisely. I was looking for greater flexibility in adding information across various columns within the same row. It seems a Google Form might be better suited for data entry to a spreadsheet. This method might also overcome the issues with sharing shortcuts and the sheet, although it would necessitate an internet connection for completion. I must admit, I have a strong preference for your sheets, especially the shortcut input on iOS, over a Google Form.
@richxps
2 жыл бұрын
Thank you this is awesome .....is it possible to create something like a checkbook registry with a running balance
@macmost
2 жыл бұрын
kzitem.info/news/bejne/q6t7t2mak2d8lXo
@melinalamura2857
Жыл бұрын
Great video! Thanks! I was really looking forward to have something to control my expenses. Just one question...On the computer works perfectly but on my iphone can't open the file, even if it is located in the iCloud Drive folder. Do you know how can I solve this problem?
@macmost
Жыл бұрын
Sorry, not sure why it won't open. Try it again. Test with another Numbers file, etc.
@jamesdavis3528
10 ай бұрын
was pretty good but would be great to know how also insert a numerical value into another column........thanks though
@macmost
10 ай бұрын
For that you'd need to get into coding with AppleScript/JavaScript.
@jamesdavis3528
10 ай бұрын
thanks for the prompt reply, Gary :D@@macmost
@tomeksokalski6321
2 ай бұрын
I have a question. How and where to set the shortcuts to display questions that I would answer by entering text. Then, this text should be placed in subsequent columns of the numbers sheet.
@macmost
2 ай бұрын
I don't understand what you are asking.
@tomeksokalski6321
2 ай бұрын
@@macmost I'd like shortcuts to display questions on my iphone or iPad that I could answer by typing in text. I would like this text to be inserted sequentially into the Numbers columns.
@macmost
2 ай бұрын
@@tomeksokalski6321 Yes, you can do that. Study the actions you can use in Shortcuts. There are ones that will prompt you for text. Then use that text in the variables to be inserted in, using a Shortcut like this one.
@sajidrockstar007
Жыл бұрын
Not working in iphone
@SanjaySinghChauhan007
8 ай бұрын
Can we record macro just like in excel...?
@macmost
8 ай бұрын
Not in Numbers. But you can always just use Excel if you need that.
@makor2817
Жыл бұрын
How can I add data from a variable instead of "Testing 123", I can't seem to have the variable into the Javascript code
@macmost
Жыл бұрын
Try Control+clicking on the field.
@Bigrichtay
8 ай бұрын
Is there a way to do this without shortcuts my mac is older
@macmost
8 ай бұрын
Just typing the date is probably a good option. Just a few keystrokes.
@mikegr3648
2 жыл бұрын
Gary in google docs you can create a test in forms and the answers are saved to a spreadsheet is this similar?
@macmost
2 жыл бұрын
With Google Forms you are creating something that gets published to the web so other people can fill out the form. This is very different than what I am showing here where this exists on your Mac, not the web. It is just for you to be able to add data, not the whole world.
@drsatishtk
Жыл бұрын
“Quit” function is not available in iOS
@somicotube
2 жыл бұрын
Thank you so much for this useful video. In my Shortcuts I can't see numbers app, I run Numbers 11.1. Is there a way to add Numbers or other apps to Shortcuts? Thank you so much!
@macmost
2 жыл бұрын
Update Numbers to the current version. Maybe that will work.
@somicotube
2 жыл бұрын
@@macmost thank you so much! it worked 👍
@restrella520
Жыл бұрын
Wow did not know this was possible. Question. Is one able to speak an input like a number value, and have that number value added to a certain cell next to one with today's date already in it beforehand, within a table within a spreadsheet. I would truly appreciate your answer. 😂
@macmost
Жыл бұрын
Should be able to. Combine this tutorial with this one: kzitem.info/news/bejne/lGmc3XyjipWdd34
@alan-vale
Жыл бұрын
Does anybody know how to duplicate a sheet inside my numbers file? I don't think there is a way to do it from shortcuts actions but perhaps by using the script action?
@murataksu6496
Жыл бұрын
Hi. I would like to add some commodity prices to Numbers file instead of Google spreadsheet or Excel. I want to track gold price. How can I do that? TIA!
@macmost
Жыл бұрын
Just figure out the symbol for it used by Yahoo Finance and then use that same symbol in the STOCK functions. See kzitem.info/news/bejne/zmewzJ6YcWeTqY4
@murataksu6496
Жыл бұрын
@@macmost Thank you so much.
@digitonsam
Жыл бұрын
What do I need to do to add one more column to the right and add data in it?
@macmost
Жыл бұрын
Doesn't work with columns. Rows should be using in spreadsheets to represent "records" of data.
@amberstockdale1368
Жыл бұрын
I badly want to use this but numbers is not an option I can select in shortcuts. How do I add it into shortcuts to be able to follow your tutorial?
@macmost
Жыл бұрын
Perhaps you are using an older version of macOS or Numbers?
@diosis77
Жыл бұрын
I tried to create this by asking for an additional value after date and time so it would ask for input to add to the same row after the date and time but all it does is adding the input instead of the date in the first Column. Any idea what I’m doing wrong?
@macmost
Жыл бұрын
Hard to say what could be wrong with your changes. Just look through it carefully.
@georgefrangoudes5951
Жыл бұрын
When I search for numbers on Shortcuts it doesn't appear =(
@macmost
Жыл бұрын
Are you up-to-date?
@sam_stones
2 жыл бұрын
Hey Gary, is there any way to have it delete a row of data?
@macmost
2 жыл бұрын
No, there's no Shortcuts action for that.
@sam_stones
2 жыл бұрын
@@macmost ahh ok no problem was worth a try, thanks!
@jeffharmed1616
Жыл бұрын
Nice presentation. Too bad Shortcuts is a dogs breakfast.
@bob1784free
Жыл бұрын
Quit no longer exists in iPad is 16.1.1. Any ideas on how to achieve the same result?…
@macmost
Жыл бұрын
Quit? Not sure what you mean.
@johnhurley9353
Жыл бұрын
The action “Quit” is no longer available so when you finish adding data to the numbers file it just stays in numbers and doesn’t quit the app
@macmost
Жыл бұрын
@@johnhurley9353 There is no "quit" for apps in iOS or iPadOS. Those OSes don't work that way. If you want to do something else after the value is added, like switch to another app, add that to the Shortcut.
@damiantosd8720
11 ай бұрын
Can numbers return a value
@macmost
11 ай бұрын
Not sure what you mean.
@damiantosd8720
11 ай бұрын
@@macmost say for example this input of data altered a calculation in numbers. Could it return that number to the siri shortcut?
@macmost
11 ай бұрын
@@damiantosd8720 You could use coding (AppleScript or JavaScript) to get the value of a cell in a table in Numbers, yes.
@civilengineering7227
11 ай бұрын
Hello , what is the code to get a value from numbers file and return it to Siri shortcut
@macmost
11 ай бұрын
@@civilengineering7227 See kzitem.info/news/bejne/uKCcl4V-hHqBo34
@timlay4504
2 жыл бұрын
How does one pass varibles from apple shortcuts to the javascript?
@macmost
2 жыл бұрын
Just add the JavaScript action and there is a "with" at the top. Set that to whatever you want. Then in the JavaScript the "input" is the object that contains that data. So usually input[0] for the first thing.
@timlay4504
2 жыл бұрын
@@macmost Hi i have a "Set Variable" set before hand passing text into javascript . When I put in line 'var value = input[0];' - I get "error cant find input"
@macmost
2 жыл бұрын
@@timlay4504 hard to visualize what you have, but it definitely works if you set it up right. Keep trying.
@timlay4504
2 жыл бұрын
@@macmost tried loads of things dont suppose you could update your video to demonstrate it ?
@macmost
2 жыл бұрын
@@timlay4504 I may do a video on that in the future, we'll see.
@Instasamps
Ай бұрын
Can I add transactions from Apple Pay into a certain column in my budget spreadsheet? So I don’t have enter it each time I spend on my card?
@macmost
Ай бұрын
Apple Pay isn't a stand-alone payment source. It is just a way to use your existing accounts and credit cards. Usually your credit card account online would have transactions that you can copy and paste or export as spreadsheet files.
Пікірлер: 146