8 - Airtable Astronomer
8 - Airtable Astronomer
since ‎Sep 23, 2015
‎Nov 29, 2022

User Statistics

  • 88 Posts
  • 1 Solutions
  • 8 Kudos given
  • 69 Kudos received

User Activity

I am trying to solve the following problem. I have thousands of registration numbers that always start with a “T” and are followed by 10 digits. This is how they are delivered to me T3090728379. But they all need to look like this T-309072837-9 which...
I have a formula that’s doing what I want it to do. But I’d like the field {ACTUAL VALUE} to be currency formatted like {EST. VALUE} - I’d also like to get a SUM at the bottom of this column, so I need it to be a number. This is what I have so far....
If someone could help me with this, I’d be extremely grateful. I can’t figure this out. This is what I"d like to achieve through a formula: Most Track Titles have a name followed by a “space hyphen space” and a suffix. I’d like to automatically dele...
I have an interesting problem. I need to create database-sort-friendly versions of names, where all definite and indefinite articles are dropped from the beginning of each name. I came up with this formula: IF(REGEX_MATCH(Name,'^THE'), SUBSTITUTE(Na...
Users have been calling for a simple TITLE CASE / PROPER function since 2016. And I know, there is @Bill.French’s wonderful script - Field Tweaker - that allows you to reformat a field as either UPPER, LOWER, or TITLE CASE. Field Tw...