DTTG - Update sheet action in Shortcuts added

Big thanks for the great update of DTTG, which now contains various improvements for Shortcuts.

One of these brings the possibility to the ‘Update content’ action which now allows for updating a sheet in DTTG. That’s ideal for all kind of situations, like registering a water meter for example.

  • Open DTTG
  • Create a sheet called ‘Water Meter’ in the global inbox
  • Add headings like date and number
  • Open Shortcuts
  • Create a shortcut called Water Meter
  • Add ‘Ask for Input’ action and set action parameters (number)
  • Add the input to a variable called ‘Measurement
  • Add DTTG ‘Update content’ action, select ‘Water Meter’, set to sheet content
  • Click the ‘>’ button to show more of the action
  • Add content as such: “<Current Date>”, “<Measurement>” (using the variable)
  • Select the Append to Sheet option
  • Add the Open Item action

When you run the shortcut, you’ll be asked to enter the measurement and the Shortcuts will then automatically add a new row to the sheet containing the current date and the measurement you entered. Subsequently Shortcuts will take you to the sheet so you can check whether the measurement is registered correctly. Yay!

6 Likes

Interesting example use case. Are you actually using this yourself?

I’m glad that you like the improvements :slight_smile:

1 Like

Yup, for those situations where some meter has to registered. Might also be the odometer in a car while on holiday etc.

I kept the example simple on purpose, but you can imagine the input in Shortcuts can contain all kind of presets or menu items if required. You could even dictate these and have the numbers read back to you before you append them in the DTTG sheet if you want :grinning:

As mentioned previously, I think Shortcuts has the potential to extremely customize the way a users wants to interact with DTTG and lower the number of feature requests or complexity in menu items.

1 Like

We agree that Shortcuts provides a lot of potential for some tpyes of automation.

Regarding sheets, as we don’t have a ton of real-world use cases from people so your example was interesting ot me.

1 Like

Nice use case - collecting successive information in one sheet - thanks for sharing this!

Would be great to have a place with such examples, where the process and creation of shortcuts is visualised with screenshots to help dummies, like me, to learn using shortcuts.

2 Likes

+1

I would prefer to customize my DEVONthink rather than have a lot of features, needed for other users, and not needed for me.

BTW i(Pad)OS Shortcuts + DEVONthink actions are much easier than Automator / Keyboard Maestro + AppleScript.

4 Likes

I would like to add HDMI to that illustration, seems to be missing :grinning:

This is a very subjective statement. I find Shortcuts in iOS to be very limited and also cumbersome to build. But writing an AppleScript or building a smart rule is much faster and more powerful for me. (And yes, that’s also subjective.)

2 Likes

Jim, I agree with“This is a very subjective statement”.

Personally for me, not a programmer, it was

  • difficult to create Keyboard Maestro macros + AppleScript
  • easy to replicate my previous work with Shortcuts + DEVONthink actions

I even created some shortcuts for work with photos, which are too difficult for me to replicate on mac.

The point is, my shortcuts/macros are not complicated — to create some docs with templates, to interlink two or three docs, to import and arrange photos. BUT this simple shortcuts/macros are essential for my work.

So I am starving to get DEVONthink actions on macOS — to be able to replicate my i(Pad)OS shortcuts on mac. Maybe we will even get “Imprint” action :slight_smile:

Thank you, Jim and DEVONthink developers, for DEVONthink actions.

1 Like

Understood and thanks for sharing your experiences!
We are very happy to hear you are getting used out of Shortcuts in general, and our Shortcut actions in specific!

Regarding Shortcuts on the Mac, they are definitely porting over the same experience so you should be quite comfortable with it. It was still **very ** buggy in the last Monterey beta. I haven’t checked on the recent release but will soon.

Cheers!

You have added new row to bottom of sheet? — What if you had possibility to add new row to top of sheet?

I suppose you are interested in “fresh” records, but when you have many records, you have to scroll down.

I would suggest DEVONthink developers to add option to add new data to sheet/markdown/txt into definite line.

Here is my suggestion with pics.

Even me find Shortcuts to be limited :slight_smile:

I tried to create reusable shortcut, which can get currently selected item in DTTG (all of my shortcuts for DTTG are launched from Shortcuts app).

Many of my shortcuts begins with these three actions

I built shortcut “Get DEVONthink item” and tried to get something like this

BUT I could not pass DEVONthink record from one shortcut to another.

Is it real limitation, or is there a way to build a shortcut with such reusable shortcut?