Dataclay — Automating Digital Production
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Register
    • Login
    1. Home
    2. Tags
    3. google sheets
    Log in to post
    • All categories
    • vjn86undefined

      Define composition position based on entry in google sheet

      Google Sheets
      • google sheets position • • vjn86
      2
      0
      Votes
      2
      Posts
      504
      Views

      Jonundefined

      @vjn86 (and for anyone else reading this later)

      Yes, you can do this, but you will need to use expressions to accomplish it. You can set numerical values in your data, then map that data to a dynamic text layer in your project. Then, you can use a parseInt() expression to parse the value of the sourceText of the layer into a number that can be used in any numerical value such as position, scale, rotation, etc. See referencing dynamic text layers section.

    • rivalproundefined

      jotform links for images not pulling into Templater

      Data Sources
      • image link jotform google sheets • • rivalpro
      2
      0
      Votes
      2
      Posts
      538
      Views

      Jonundefined

      In case anyone comes across this topic later, it appears that jotform changed something about the way that they serve media files, and they no longer appear to be offering directly hosted files that work with Templater. There is a paid plugin called Uploadcare that I believe still works for file uploads that Templater can import.

    • rivalproundefined

      Using ARRAYFORMULA in Output Column

      Google Sheets
      • google sheets output arrayformula form entry automate • • rivalpro
      2
      0
      Votes
      2
      Posts
      552
      Views

      ariestavundefined

      @rivalpro Unfortunately, what you are encountering here is a known issue with using Bot and Google Sheets. Can you somehow, make an invisible field that does the “stitching” of the other fields in the form and inject that invisible field into the Google Sheet. In other words, the output column should be hard coded. I know this is not what you want to hear, but it is a limitation of writing data back to a Google Sheet using their API.