The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hi all,I can't keep my work partner from accidentally adding options to our single select fields. He forgets they are single select fields and just types in his value—often misspelling them. Is there a way to prevent this? One that doesn't depend on ...
Not sure how to make suggestions to Airtable developers, so I'm putting mine here. Am I the only one who would think it'd be cool if we could reorder the items in a linked field's cell? The way that, say, one could reorder songs in a playlist in Spot...
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...
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...