Help center

    Start for free Sign in search

      Get Started Add Content Billing FAQs

      Automation action: Formula Editor

      Thy Nguyen

      Updated on August 11th, 2023

      Table of Contents

      When creating an Automation with the “Formula Editor” action, it’ll execute a function whenever the Automation runs successfully. 

      With the Formula Editor action, you can now run Gridly formulas on other columns that are not the Formula, File and Reference column types.

      image1.gif

      Setup 

      After creating the Automation, you need to configure the trigger and action. 

      In this example, we’ll create an Automation that returns the length of the (source_enUS)English column to the Character Limitation column in the String translations template.

      Add “Record Updated” trigger

      1. Click Add Trigger, then select “Record updated” from the dropdown list.
      2. In the “Watching columns” section, select the Source language column (Source_enUS). image2.gif

      Add “Formula Editor” action

      1. Click Add Step and select Formula Editor in the list of actions.
      2. Enter the formula in the payload. Click Select input value for action to add the column value. 
      3. Select Output column to hold the result.

      image3.gif

      Test Automation

      1. Switch the toggle on to turn on the Automation.
      2. Click Test Automation. If your Automation is not turned on, Gridly will require you to turn on the Automation in the pop-up message. Click on the toggle to turn on and select Test again.

      Was this article helpful?


      0 out of 0 found this helpful

      Still need some help?

      Contact Support