Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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...
I am trying to add conditions to my nested IF statement, but somehow it’s not working. I want to extract musical key information from the end of file names. The information I am trying to extract is marked bold. BRASS CHORDS DARK G BRASS CHORDS DARK ...