Help

I want to add a formula field to check the URL with parameters that has the source name and if its present type that particular platform name in the column

Topic Labels: Automations
401 1
cancel
Showing results for 
Search instead for 
Did you mean: 
satya_raju
4 - Data Explorer
4 - Data Explorer

The URL will contain the source as PlatformA or PlatformB.So I want to find out what is present and if it matches type the same in the column.

Tried using the following IF statement but irrespective of what’s there in the URL its always showing up PlatformB in the column.

IF(“URL = PlatformA”, “PlatformA”,IF(“URL = PlatformB”,“PlatformB”," NoSource"))

Thanks

1 Reply 1
Ben_Young1
10 - Mercury
10 - Mercury

Hey @satya_raju! Welcome in!

The solution to your exact problem is with a formula like this:

IF(
    {URL PlatformA},
    {PlatformA},
    IF(
        {URL PlatformB},
        {PlatformB},
        "⛔ Missing Source!"
    )
)

In production, it will look like this:

image

Quotations in Airtable’s formula syntax indicate a string, rather than a variable input.
Curly brackets achieve what you’re looking for.


Bonus Content!

It kinda depends on your context, but you can write the formula in a way that does not require the two fields that contain the names of the platforms.

Using this formula:

IF(
    {URL PlatformA},
    "Cool Platform",
    IF(
        {URL PlatformB},
        "The Best Platform",
        "🛑 Missing Source!"
    )
)

You will get this:

image

This removes the two fields that just contain the names of the platforms.
It helps with data bloat/congestion from dedicating two fields from just holding names of the platforms.

In Airtable, the ideal structure is to use linked records, however, if you want to stick to your original method, this is a solid way to keep everything clean and streamlined.

Just food for thought.