Everything covered in this video is indeed still available in Sequoia. Nothing has changed.

Hi there - thanks for the question. The template contains 37 Drop Zones so you would need to remove 17 Drop Zones as well as the 17 camera movements related to those deleted Drop Zones. However if you wanted the images evenly spaced within a circle, you would need to figure out the positions of the 20 images. They would need to be 18 degrees apart (for a total of 360 degrees). Then you'll need to use SIN and COS to determine the circular positions of these images. This is more daunting task of course. Hopefully this helps. Thanks for watching!

@@apple-a-day Thanks for that vert quick answer Other questions; 1) can I copy this project (.MOTN), and give it a other name? 2) can I change the precut from 29.97 fps into 25 fps? Because this is what I use in the Netherlands.

@@adrivangool9853 Yes, you can simply copy and rename the project and project folder. And you should also be able to change the Motion Project settings to be 25 fps.

@ I can't change that in your project to 25 fps

Hi there. So to convert the total minutes to hours you can use the DURATION function: =DURATION(0, 0, 0, B2 * 45, 0, 0) B2 is the cell that contains the total parts. That's multiplied by 45 minutes. This is in the MINUTES parameter of the DURATION function. When you display this cell you will need to select Hours and Minutes in the Cell Duration Properties so the style looks like this: 0h 0m Hope this helps. Thanks for watching!

That's a great question! Unfortunately I just chose my delay times to be longer to make sure that they would always work. From my experience cutting down the delay may work most of the time but then there's always gonna be some hiccup which breaks it. Regarding some sequences being faster than others.... it's not really the action of a UI Event which is faster or slower. It's the Application that you're controlling that can cause delays. For instance clicking on a button should have minimal delay but the execution time of the Button response can't be determined... it's going to be different for every Button depending on the internal code. Hope this makes sense!

Thanks for the question. This was a tricky one! The 'CLICK' command doesn't work when selecting an item from a list. I had to use KEYSTROKE instead. I was able to get this to work for me (it was tough because the list isn't named by anything obvious): tell application "System Settings" activate reveal pane id "com.apple.Sound-Settings.extension" delay 1.0 end tell tell application "System Events" tell window 1 of application process "System Settings" tell outline 1 of scroll area 1 of group 2 of scroll area 1 of group 1 of group 2 of splitter group 1 of group 1 of window "Sound" of application process "System Settings" of application "System Events" keystroke "MacbookPro Speakers" end tell end tell end tell Hopefully this works for you as well! Thanks for watching!

Thanks for watching!

You're very welcome, thanks for watching!

Hi there! Unfortunately I don't see a simple way to do this. If I find a solution, I'll post a video on it. Thanks!

@@apple-a-day Is it difficult that way? It's just copy a cell's formula to another cell! I know that you are a great instructor and this will be a very easy to you.

Yeah it’s a really annoying workaround. Thanks for watching!

Hi there. Good question... I think there might be a way to run a script in the background... perhaps with the terminal or with another app running. I'll have to look into it. It might also be something you can do with Xcode. Regarding the color of the shortcut... I just checked the Shortcuts application AppleScript dictionary and a color property exits however it is read only. So it doesn't look like you can change the color programmatically. Thanks for the questions. If I discover a way to run a script in the background, I'll post a video. Thanks for watching!

Thanks so much! Unfortunately I don't see a simple way to do this. If I find a solution, I'll post a video on it. Thanks!

@@apple-a-day Thank you. I got the required answer from another youtube channel. It was very simple.

Glad it helped! Thanks for watching!

Hi there! Thanks for the question. However I'm not sure exactly what you're trying to do. If you like, you can email me at [email protected] and attach your numbers document and hopefully I'll be able to help.

Thanks for watching! Glad you found it helpful.

Great catch. I didn't notice the issue because I didn't have a column header. In any case I did find a workaround. I used the Address of the column instead of the name. I then converted that to ASCII so I could get the column letter. The address of the first column will always be 1 which will represent A. The ASCII value of 'A' is 65, so adding 64 to the address to get the column letter worked for me. Here's the updated code to get the column letter: -- GET THE COLUMN LETTER OF THE COLUMN set theColumnAddress to address of theColumn set theColumnAscii to 64 + theColumnAddress set theColumnLetter to ASCII character theColumnAscii AppleScript has a built in function to convert an number to text: ASCII character Hope this solve the problem on your end as well. Thanks for the question and thanks for watching!

Hi there! This will clear contents of the specified cell range (Note that this is assuming the first table within the first sheet within the active document): tell application "Numbers" tell document 1 tell sheet 1 tell table 1 set value of every cell of range "C2:C15" to "" set value of every cell of range "E2:E15" to "" end tell end tell end tell end tell

@@apple-a-day Thank you very much for your prompt reply and great help. Can you choose for me the best book or online site to use for learning the Apple Script commands?

@@Abbasfathy I have a handful of AppleScript videos in this playlist: kzbin.info/www/bejne/g4DHenl7ipaKjJo I found this playlist from another KZbinr: kzbin.info/www/bejne/m2qlZHiVedOhjdk That should be enough to get you going. Good luck on your AppleScript journey!

Thanks so much! Glad it was helpful. Thanks for watching!

That's so great to hear! Glad this was helpful. Thanks for watching!

Wow! That's fantastic! So glad you were able to put this to use in a real world situation. Thanks for watching!

Hi there! Thanks so much and thanks for watching!

Hi there! Great question! I just did a quick test and multiplying the source value by 2 before rounding seems to work. Here's the formula: =ROUND(B1 × 2, 1) ÷ 2 B1 is the cell containing the number (eg. 1.84, 1.82, 12.78, etc). That cell value is multiplied by 2 and then it is rounded to 1 decimal point. The result of that is then divided by 2 to get the proper answer. Hope that helps! Thanks for watching!

Hi there! Thanks for the question. The result from a Display Dialog statement is actually a record containing multiple values. To get the text that was entered in, you have to get the TEXT RETURNED. Here's and example: set theResult to (display dialog "What is your age?" default answer "") set theAge to text returned of theResult The variable 'theAge' now stored the value that was entered. Hope this helps. Thanks for watching!

Hi there. Unfortunately this Motion template will only work in Final Cut Pro. In the future I'll be doing a template like this in Davinci using Fusion.

@ ok. Thanks for your response 🙂

HI there! This can be done using COUNTIFS. Th following formula will count a row if these 2 conditions are met: 1) The CHECKBOX under column B is true 2) The CELL under column C is blank =COUNTIFS(B3:B10, "=TRUE", C3:C10, "=") B3:B10 is the range containing checkboxes C3:C10 is the range containing the cells - the condition "=" checks for blank values Hopefully this is what you were asking. Thanks for watching!

@@apple-a-day Thank you for your great HELP. Your answer is correct. 😍

@@Abbasfathy Awesome! Great to hear!

I don't think it will work out to be exactly the same. It depends on the movement of course. The Throw behaviour is certainly more predictable than using Continuous keyframes. I find that sometimes when I switch a keyframe to Continuous it doesn't do what I expect. It's all trial and error!

@@apple-a-day thanks for the reply! I'll try to use it in both ways! and once more thank you for your work! looking forward to see more tutorials on Apple Motion :)

@@DmitriyHandpandojo Thanks so much! Glad you find them helpful!

hey there again :) I've found your tutorial about drop zones and videos and looks like there is some way to control video appearance.. so I think If I'll adjust audio fades in the compound clips so it also should work! thank you once more for your ideas!

Hi there! That's great that you found that video. I was going to refer that video to you with regards to handling Video in Drop Zones. Thanks for watching!

That's great to hear!! Thanks for watching!

Hello! Good question - unfortunately there's no way you can do something like this in Numbers. There isn't a way to capture a mouse click onto a cell and then perform an action.

@ is there any way to quickly capture current date and or time? Like if I start typing in new row or column it will auto populate. That’s for the quick response.

@@brandonfreeman5614 Not automatically but under the Table Menu, near the bottom there are two options: INSERT CURRENT DATE and INSERT CURRENT TIME. They also have keyboard shortcuts which will make it a bit faster.

That's great to hear! Thanks so much!

The closet I got was to just have daisy disk running and refresh on the folder to see the sizes of all the nested folders

Hi there, good question. Unfortunately there does not appear to be a way to do this. You can only show folder sizes in List View.

@@SogMosee Interesting. It's a shame it's just not built into the Finder to show that info in views other than List View.

That's great to hear! Thanks for watching!

That's great to hear! Thanks for watching!

Hello, These are the Apple Motion features used in this tutorial: Drop Zones Camera Framing Behavior Throw Behavior Saving a Final Cut Generator Thanks for watching!

Hi there! Yeah, I get that. Even though they more or less do the same thing, the approach to using Numbers and Excel are different enough to make it hard to learn. I haven't used Office in at least 10 years... I've been able to get by using the Apple suite (Numbers, Pages, Keynote). Thanks for watching!

High there, great question! I just checked out the calendar template and I think the issue is that this template doesn't account for contents/events for each date. Why you add text to the cell (eg. Wife's Birthday), that cell is constant throughout the entire calendar. Also when the month is changed, it's not flipping pages or anything fancy like that, it's simply recalculating the contents of each date block to display the proper date. So I guess the template is really not that useful if you wanted to use it to actually enter events, etc. Thanks for watching!

@@apple-a-day So appreciate your response. Thanks for taking the time.

HI there! Good questions. I would probably publish the template as a Final Cut Generator. The reason it's cropped might be because the resolutions don't match. If you created an HD project in Final Cut Pro then used the template does that work? If so then try changing your Motion Project to 4k to see if that solves the issue. Keep me posted. Thanks for watching!

@@apple-a-day thank you for the suggestions. I tried your idea saving as a generator, unfortunately no change was visible. Both FCP and Motion are set for 4K. The Motion project is cropped when placed in FCP. The result looks like you've cropped the top down to the center and the left to the middle. Only the bottom right quadrant contains the Motion title. It's really too bad. The 'Superman' title is really great looking in Motion. I exported the title as a .mov and imported to FCP. This worked properly but the text developed some artifacts that do not appear in Motion. I'm going to look at each element and do a deep dive into their properties. Hoping for success.

@@wallacedavidg Thanks for the additional feedback. I recreated the titles myself and am seeing a similar issue in Final Cut Pro when saving the Motion Project as a generator. There must be a problem with the Replicator in a Motion Project when in Final Cut Pro. I've not yet been able to solve it. I'll take another look over the next week to see if I can find a solution.

@@apple-a-day Not sure what this means or solves ... I recreated your Superman Credits on an older MacBook Pro using Motion 5.4.3 and it looks just like the one in Motion 5.9. I saved it to my older version of FCP 10.4.6 and it worked. The title was centered and behaved just how it looks in Motion. I then opened the old version Motion title in Motion 5.9 and everything looked great. I saved it to FCP 11.0 and got the same bad results with the title only in the lower right quadrant. Not sure where the incompatibility lies Motion 5.9 or FCP 11. It is still a great looking credit! I was hoping to use it in one of my videos.

@apple-a-day The final test was using the title generated in the older Motion version, that worked in the older FCP version, and placing that file inside FCP 11.0. Unfortunately I got the same bad results.

Haha that's great! Thanks for watching!

Hi there! That's the reason I made this video... it was bugging me too until I finally took the time to find out how to change it. Thanks for watching!

Hello! Thanks, I'm glad this was helpful. I think it's more up to Microsoft to keep improving Excel for the Mac. I wonder if they don't bother because Apple has near equivalents (Numbers, Pages, Keynote instead of Excel, Word, Powerpoint) In any case, if you're using a Mac mostly for non-video work, a MacBook Air will be more than adequate and even the smaller one supports an external display so you can use it as a desktop with a larger monitor. Hope this helps. Thanks for watching!

@@apple-a-day yes, it does. Thanks a lot.

Hello, I used the Screenflow application to record the screen. I was actually surprised that it recorded the zoom for me. I know that in Zoom calls that screen zoom is ignored so it most likely is a limitation of the screen sharing software.

Hi there. Unfortunately this feature is not available in Apple Numbers. Thanks for watching!

Hi there. Unfortunately this feature is not available in Apple Numbers :(

That's great to hear! Thanks for watching!

Hi there, good question! As far as I can tell, you'll have to separate the tracks into separate files. Thanks for watching!

Thanks! And thanks for watching!

Hi there! Good question - I looked into it and I couldn't find a way to change the screen shot date format. I found a way to change the name but not the date portion. If I ever discover a way to do it, I'll post a video. Thanks for watching!

Hi there! Thanks for the question. I was able to achieve this using the SWITCH function since this makes it easy to test for multiple values for the month. This formula works for January and February: =SWITCH( MONTH(A1), 1, B1×C1, 2, D1×E1) So SWITCH checks the value of the first parameter... in the above example this is MONTH(A1). That will return the month number (1 = January, 2 = February, etc.) Then this is followed by a series or pairs: 1, B1xC1 2, D1xE1 The first value in each pair is the month number. The second value is the value to display. I've only put it 2 pairs but this can be unlimited with the SWITCH function. Hopefully this works for you! Thanks for watching!

Thanks! I'm glad it was helpful!

Heh heh, thanks Jim! Thanks for watching!

You're very welcome! Glad you enjoyed it!