John_Dlouhy - profile

John_Dlouhy · Aug 22, 2024

Greetings Airtable CommunityI have a long text field with RTF formatting enabled. The text includes links to web pages, emails, and phone numbers. The web links are working perfectly, as are the email links (using mailto:)—but the phone numbers are n...

John_Dlouhy · Jul 17, 2024

Hello Airtable Community,My table includes an event title field as well as one for an event date.Event Title:The Chemical Regulations LandscapeEvent Date:June 6, 2004Formula:LEFT({Event Title}, 16)&" - "&{Date}Formula Result:The Chemical Reg - 6/6/20...

John_Dlouhy · Jul 21, 2022

Greetings Airtable Community, Several weeks ago I received great assistance with a formula quandary involving the combination of two multi-select fields: {College(s)} & IF({Department(s)}, " and " & {Department(s)}) This formula assumed that the {Col...

John_Dlouhy · Jul 13, 2022

Greetings Airtable Community! I have a base with 6 tables that is shared with two collaborators. The most frequently used “master” table—named Events—is at the far left of the upper tab structure. Each time I open the base, this “master” table is sel...

John_Dlouhy · Jul 07, 2022

Greetings, Airtable Community! All the tables and views in my base are locked, “…to prevent anyone from editing the view configuration until it is unlocked by a collaborator with creator permissions.” I have two collaborators at the Editor level. Wit...

John_Dlouhy · Aug 23, 2024

Go BHAM!! Thanks for the suggestion—it’s an interesting idea, one that I’ll definitely keep in mind as I sort through this issue. Cheers and thanks again!

John_Dlouhy · Aug 23, 2024

Thank you for these great suggestions! I will explore which workaround does the job!

John_Dlouhy · Jul 18, 2024

Thank you very much! Greatly appreciated!

John_Dlouhy · Jul 22, 2022

B R I L L I A N T !! And truly appreciated. Thanks so much for this solution, Ben. If you’re willing/able to provide that “bit more of an explanation”, I’d certainly be interested in learning more.

John_Dlouhy · Jul 13, 2022

Many thanks for clarifying this for me @ScottWorld! Much appreciated!! :white_check_mark:

User Statistics

User Activity

Phone numbers in a Long Text Field

Formula to Correct #ERROR! for Empty Date Field

Formatting a Formula

Designate a default table when opening Airtable?

Locked Views and Field Editing

Re: Phone numbers in a Long Text Field

Re: Phone numbers in a Long Text Field

Re: Formula to Correct #ERROR! for Empty Date Field

Re: Formatting a Formula

Re: Designate a default table when opening Airtable?