Note: replace “URL” with column’s NAME and make sure the single quotation marks are STRAIGHT.
Hi Airtable Community,
TL;DR I’m trying to write a formula that’ll turn part of a URL into a Primary Field
Specifically, I have a list of URL’s like below. I need to separate the last bit of each URL (e.g. shopify, how to use, square vs paypal, what is credit card processing) and automate it into the Primary Field name - leaving out everything before it. The problem I’m unable to solve is that the part after the main URL is variable. For example, in https://www.usnews.com/360-reviews/credit-card-processing/what-is-credit-card-processing the emboldened part varies in each URL, making it hard to remove it with a formula