Shortcuts App: Add row to Number Table (Numbers 11.0 update)

Question

Level 1

21 points

Shortcuts App: Add row to Number Table (Numbers 11.0 update)

I have a very simple Shortcut that gets the date & time, gets an existing file from iCloud, and writes a record to the bottom of the spreadsheet. This has worked through numerous updates to Numbers. Now with Numbers 11.0, the shortcut looks like it's working (correctly gathering the data, opening the file) but doesn't actually write the record to the spreadsheet. I've replaced both the Get File action and the Add to Numbers action (as those have broken in the past with updates and adding them again presents the "new-and-improved" action options). I've tried everything I can think of, but I can't get the records to write to Numbers. Has anybody had any luck resolving this?

The last image shows the test Numbers spreadsheet to illustrate that it's formatted correctly and has worked in the past.

iPhone 11 Pro Max, iOS 14

Posted on Mar 24, 2021 9:05 AM

Reply

Answer 1

Top-ranking reply

jeffpage Author

Level 1

21 points

Apr 1, 2021 6:51 AM in response to jeffpage

In case you're following this support request, I found a workaround, albeit it's pretty 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

(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

Shortcuts App: Add row to Number Table (Numbers 11.0 update)

Similar questions