Support

Articles in this section

Add a line break using \n

Basic calculations using the formula field

Build a custom form URL filler using ENCODE_URL_COMPONENT

Calculate the difference between two dates

Comparing numeric values using IF

Convert a serial date from Excel to a readable date

Convert unix / epoch time to current date

Displaying quarters in a fiscal year

Extract the file name from attachments

Formula writing tips for beginners

See more

Add a line break using \n

Basic calculations using the formula field

Build a custom form URL filler using ENCODE_URL_COMPONENT

Calculate the difference between two dates

Comparing numeric values using IF

Convert a serial date from Excel to a readable date

Convert unix / epoch time to current date

Displaying quarters in a fiscal year

Extract the file name from attachments

Formula writing tips for beginners

See more

Extract the file name from attachments

If you'd like to extract the file name from a file in the attachment field, you can do so with a formula like the example below:

LEFT({Attachment Field},FIND("(",{Attachment Field})-1)

Screen_Shot_2019-09-04_at_6.22.20_PM.jpg

Note that this formula only accounts for attachment fields with a single file attached. For more details on using formulas in Airtable, please see our formula field reference.