Hey friends, is there any formula I can use to replace HTML with regular text? I’m zapping in excerpts that contain ’ where a single apostrophe ( ’ ) should be.
Hi all,
I’m trying to make it easier for my teammates to create records, and would love it if I could format the text in a formula field so that its items separated by a comma are displayed in vertical list format. This is the formula I’m using right...
I have four fields:
Unix Timestamp - a single line text field that contains the unix timestamp
Date & Time - a formula field that converts the unix timestamp into a readable date and time using the following formula: DATEADD(‘1/1/1970’,{Unix Timest...
Hi AirTable friends,
I have records that each have a long text field which is TOO long. That long text field is called “Excerpt.” What I’d like to do is create a formula field called “Trimmed Excerpt” that copies the content from “Excerpt” field but ...
Hi Airtable Friends,
I want to combine four things in my primary field: (1) Story ID#, (2) Date, (3) Storyteller, and (4) Story Title – all separated by a " - ", of course. I was able to get the first two things with this formula:
({Story ID#} & " - ...
Kuovonne to the rescue again! Thanks! The date and time formulas worked perfectly. The last formula didn’t work for me, but I don’t mind having an extra column that I could hide. :slightly_smiling_face:
Just realized I could go with the “Name” Single Line Text field that’s connected to the form. Duh. Works like gangbusters now. Thanks, guys! :heart_eyes:
Deleting the T({Storyteller}) line did the trick! Now I’ll just have to figure out how to get the author’s name in there. Maybe using a Lookup instead of the Linked
