Apple Shortcuts Stopped Adding Rows to Numbers Spreadsheets

Question

Level 1

10 points

Apple Shortcuts Stopped Adding Rows to Numbers Spreadsheets

I have a couple of shortcuts that were working correctly, adding populated rows to the bottom of tables in Numbers spreadsheets. Now (due to a recent update???) these shortcuts have stopped working correctly. They open the spreadsheets, but do not add rows to the bottom. I’ve tried removing and re-adding the operation in the shortcuts, but cannot get them to work again. Shortcuts that write to files other than Numbers still work fine.

This is an issue on both my iPad Air, and my iPhone SE.

Does anyone else have this issue?

iPad Air, iPadOS 14

Posted on Mar 25, 2021 8:25 AM

Reply

Answer 1

Best reply

jeffpage

Level 1

21 points

Apr 1, 2021 6:48 AM in response to Jfshelton

I'm having the same problem, but have found two workarounds, albeit both are "wonky".

Apparently the problem is Numbers is taking too long to "get it's **** together" and the shortcuts are sending info too fast, so essentially, you have to manually slow down the process.

To do that,

(1) I moved the Get File to the start of the shortcut (it'll run in the background as the rest of the shortcut runs).

(2) I added an Open File right after the Get File (that seems to help, but I'm not sure why but saw it in other support replies).

(3) Then I collect all the data (three pieces, in my case)

(4) Finally I inserted a wait. On my iPhone 11 Pro Max I had to wait 10 seconds.

There's still a delay in actually seeing the data appear, but I finally got it working after messing with it for a week.

One instance of this question seems to be getting some traction (my question from last week went ignored), in case you want to follow it https://discussions.apple.com/thread/252597941

Reply

Answer 2

Jfshelton Author

Level 1

10 points

Mar 26, 2021 5:00 PM in response to jdo_apple

No, this has nothing to do with Keyboard Shortcuts. This is a problem with Apple’s Shortcuts app. The shortcuts that write to Numbers spreadsheets were working correctly. Now they are not. My other shortcuts (that write to other files) still function correctly. I haven’t changed anything (other than potential automatic updates).

Reply

Answer 3

jdo_apple

Community Specialist

Mar 26, 2021 9:51 AM in response to Jfshelton

Hi Jfshelton,

We know how time saving shortcuts are when using the Numbers App. Take a look at these shortcuts to help correct your issue.

Keyboard shortcuts for Numbers on iPad

Have a good day.

Reply

Answer 4

Jfshelton Author

Level 1

10 points

Apr 1, 2021 6:00 PM in response to jeffpage

Thanks jeffpage! This solved my problem! In my case I don’t even need to insert the wait - I just need to put the get file and an explicit open file at the start of the shortcut.

Reply

Apple Shortcuts Stopped Adding Rows to Numbers Spreadsheets

Similar questions