TODO_REPLACE_WITH_DUPLICATED_TEXT_TO_FIND: Text you want to check for duplicates (string).has-duplicated-text: Checks whether text field contains duplicated text value.TODO_REPLACE_WITH_DESIRED_POSITION: Position you're seeking (integer).find-word-at-position: Find any word based on its position.Updated on 2020 October 24 to handle filenames that contains parenthesis a bit better.TODO_REPLACE_WITH_YOUR_ATTACHMENT_FIELD_NAME: Attachment column name you want to process (string).find-attachment-url: Find the url of an Attachment field.find-attachment-filename: Find the filename from an Attachment field (not its url).currency-string-to-euro ⚠️ (Doesn't work, WIP, use currency-integer-to-euro-string as an alternative).TODO_REPLACE_WITH_YOUR_COLUMN_NAME: Column name you want to process (integer) (decimals aren't supported).count-unique-relationship-records: Count the number of unique linked records.TODO_REPLACE_WITH_YOUR_COLUMN_NAME: Column name you want to process (string).Rollup field needs to use & '' to be converted to string, before concatenation happens TODO_REPLACE_WITH_YOUR_ROLLUP_FIELD: Rollup field to use (string).TODO_REPLACE_WITH_YOUR_STRING_PREFIX: Prefix (string).count-selected-items: Count the items in a multiple select or multiple collaborator field.attachments-count: Count the number of attachments in an Attachment field.Those are generic formulas meant to be re-used by anyone.
Airtable rollup update#
vLookup3d: This script can be used to resolve a value from a "range" table, based on a value in a "source" table and update a field in the "destination" table.Those are generic scripts meant to be re-used by anyone. (recommended for all your bases, really useful!) List all fields of all tables: List all tables and all fields of the current base.This repo is mostly about Airtable utilities to centralise formulas and such.
0 kommentar(er)
