• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
1

Automation Blocks - Pulling from Spreadsheet

Participant ,
Jun 26, 2023 Jun 26, 2023

Copy link to clipboard

Copied

It's been a few minutes since I had a question as I've been working on a project where Automation Blocks absolutely changed my life and productivity level. I'm back trying to clean up some scripts and improve them where possible.

 

So, first thing I'd like to do is pull info from multiple columns of a selected line in a spreadsheet. We've gone thru a bit of this back here.

 

I've got a spreadsheet that has a lot of data export from ShotGun pertaining to the shot.

 

When I make my selection in the input dialog for the show, how do I pull data from other columns in the "line" to make variables of them and apply them? i.e. I'd like to set variables for Frame Rate, Output X, Output Y, etc.

SetProject.png

It seems like I should know this, but I'm drawing a blank. Thanks for you help.

 

I plan on sharing a video once I've wrapped up my changes now that the show is done! Is there an update planned, and if so, when can we hope for it?

 

Mike

TOPICS
Scripting

Views

611

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Jun 27, 2023 Jun 27, 2023

Hi Mike,

 

in a nutshell, after the user made his choice, you need to loop over all rows of the spreadsheet again until you found the one that the user has chosen.

 

For that, you could duplicate your green "for each row in spreadsheet" block to loop over the entire spreadsheet again after you've shown the dialog.

In this duplicate, instead of the statement, which insert the "column project name" into the "name project" list, you use an if statement to check if "colum project name" equals "name

...

Votes

Translate

Translate
Community Expert ,
Jun 27, 2023 Jun 27, 2023

Copy link to clipboard

Copied

Hi Mike,

 

in a nutshell, after the user made his choice, you need to loop over all rows of the spreadsheet again until you found the one that the user has chosen.

 

For that, you could duplicate your green "for each row in spreadsheet" block to loop over the entire spreadsheet again after you've shown the dialog.

In this duplicate, instead of the statement, which insert the "column project name" into the "name project" list, you use an if statement to check if "colum project name" equals "name project". If they are equal, you know that you are currently looking at the row which the user has chosen in the dialog. Hence, inside the if-block you can then do everything you want to do for that chosen project (and all the variables initialized in the green block will then have the values of that row).

 

I am currently very busy preparing the release for Automation Blocks for Premiere Pro. After that, new features for Ae could be an interesting next topic again 🙂

 

 

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Jun 30, 2023 Jun 30, 2023

Copy link to clipboard

Copied

Mathias,

I got it to work and wanted to share what your answer looked like for others.

 

SetProjectInfo.png

I've got a lot of variables with so I broke them into functions to keep it a little easier to look at. The four "set Project" functions pull from the main spreadsheet and write out "save settings" to the preferences for use later by other scripts.

 

Since I've got you here and you might be looking for interface feedback for the next version, please...

  • Add snaping to a grid as an option.
  • Add grouping of objects. The above group as an example would be something I would want to group and move together. Kind of like a group node in Nuke or Fusion.Group.png
  • It'd be great to get some more description in the popout of each "item". Right now, when there are a lot of items, I can't tell where I'm inserting, cause they're all just "Item"Item Names.png

As always thank you for your input. I look forward to sharing more soon.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jul 01, 2023 Jul 01, 2023

Copy link to clipboard

Copied

LATEST

This is very interesting feedback, Mike! Thanks a lot - also for sharing your solution 🙂

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines