sitesupport.blogg.se - Airtable formulas between tables

Airtable formulas between tables how to#
Airtable formulas between tables update#

Airtable formulas between tables how to#

prefix-label-lang-from-rollup: Shows how to concatenate a prefix with a rollup field (this isn't a Rollup field, but uses one).

Those are more-or-less generic examples meant to be re-used by anyone.

slug-compact: Identical to slug, but one-liner (for those who prefer it).

slug: Slugify a string by removing all special chars to make sure it's URL-compliant and doesn't contain any non-ascii chars.

rollup-extract-attachment-url: Extract the url from a Rollup Attachment field (rollup fields on attachment return an array, this formula returns the asset's url).

is-bank-IBAN-structure-valid: This formula checks if the structure of TODO_REPLACE_WITH_IBAN is correct (each country has its own specification).

TODO_REPLACE_WITH_IBAN: Column name containing the IBAN value (string).It only considers countries that are within the SEPA area. is-bank-SEPA-IBAN-structure-valid: This formula checks if the structure of TODO_REPLACE_WITH_IBAN is correct (each country has its own specification).TODO_REPLACE_WITH_BIC: Column name containing the BIC value (string).is-bank-SEPA-BIC-structure-valid: This formula checks if the structure of TODO_REPLACE_WITH_BIC is correct.has-many-selected-items: Count the items in a multiple select or multiple collaborator field and returns whether there are more than 1 match.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 formulas between tables 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.