This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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
