Skip to main content
m1jackson
Inspiring
November 13, 2022
Question

Automation Blocks - Spreadsheet alternate column selection

  • November 13, 2022
  • 1 reply
  • 1274 views

I'm trying to import a file listed in a spreadsheet and can not figure out how to use a column with a simple name in a drop down and then use a different column with the path when executing an import.

I've got a simple spreadsheet to list my asset name, the location, and what type.

I'd like to use a simplified name in the popdown.

This works, but is inelegant and difficult to read.

These are my current blocks

I will also being looking to move the imported asset into a project bin based on the "Type" in column 3 of the spreadsheet.

As always, any insight given will be appreciated. Thanks.

This topic has been closed for replies.

1 reply

Mathias Moehl
Community Expert
Community Expert
November 24, 2022

Here is a minimal example assuming that you have the names in column A and the full paths in column B:

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects
Mathias Moehl
Community Expert
Community Expert
November 24, 2022

by the way, we just started a 50% off discount on Automation Blocks:

https://aescripts.com/automation-blocks-for-after-effects/

Mathias Möhl - Developer of tools like BeatEdit and Automation Blocks for Premiere Pro and After Effects