I’m back with a puzzle it wouldn’t have occurred to me to even attempt if I hadn’t seen some miraculous-seeming formulas early on in my Airtable forays. I sell books that I inherited from my dad. In my Books table, there’s an Author field that someti...
Hi All,
I’m in the process of creating a catalog of related books that I can hopefully email out to customers, and, so far, that’s involved creating an Entries rollup field in my Catalogs table that pulls from my Books table using the ARRAYUNIQUE(val...
Hi there!
I am trying to figure out a way to create book catalogs to automatically email customers from specific table views. I do something similar for sales: When the Shipped field from my Sales table is checked, an email notification automatically...
Hi everyone,
For the freelancing part of my making-ends-meet endeavors, I have started tracking tasks. Usually, that’s no problem with Airtable. But once in a while, I’ll forget to enter a task when I start it, and, instead, enter it when I remember ...
My {Decimal} field is indeed a number and, therefore, removing the quotation marks worked like a charm. Thanks, John_B2, for the solution. And thanks, kuovonne, for sharing suggestions in case the field wasn't a number. I really appreciate the help! ...
Also, the preference for the catalog stuff I’m working on is to get all the fields to be Last, First. So the reverse of the formula you provided. Thanks for that, by the way! It’s been a long day but where are my manners?
Ah, I just realized there’s an extra obstacle: some Author cells have multiple authors listed in them. Is there a way to write the formula so that the cells with multiple commas get ignored? I’ll give you some examples pulled at random:
Chesterton, G...
Thank you! Again, you’re right: I did have a floating “$” in the Entry formula. I was so focused on the Price Reformatted formula that I forgot to re-check the Entry formula.
That brings this project to a close, and I’m so grateful for your help. Tha...
Hi kuovonne,
It seems like you may be thinking I’m using another formula Ben mentioned. This is the one I use in the Price Reformatted field and it doesn’t use the word “line” at all . . .
IF(
{Price},
IF(
FIND(
“.”,
{Price} & “”
),
IF(
REGEX_MATCH(
...
