Select Page
📣

Formulas now work with Arrays and Rollups - New Formulas added

NEW FEATURES

  • If Airtable Field is deleted, then will show an Error warning by the field once the Meta Data is synced. An error will be logged if a form submission happens with deleted field
  • Formulas and Static Text Custom Fields now have way to save the result back to a Text/Num/Long Text field in Airtable. New menu item of Airtable Storage to select optional field for saving. If a field is selected here, then it can't be used as a normal form field, and vice versa if a field is already on the form, then can't be used here for saving the formula/text. This is great use case to use Formulas or Text fields as a Template Engine to populate with data from Airtable and save back the populated value to Airtable in another field.

UPDATES

  • Formulas now working with Arrays (Linked Record Values). Supporting same formulas as Airtable within the Rollup: JOIN, CONCATENATE, MAX, MIN, SUM, AVERAGE, COUNT, COUNTA, COUNTALL, OR, AND, XOR, UNIQUE, COMPACT, FLATTEN,
  • Implemented some common array formulas from Lodash library (https://lodash.com/docs/4.17.15) INCLUDES, NTH, LAST, FIRST, REVERSE, SORT_ASC, SORT_DESC, SAMPLE, SAMPLE_SIZE, SHUFFLE, INTERSECTION, DIFFERENCE