Automation to link multiple records upon output of...

[Yuzer]

Goal: A user can create a post including any version of a youtube or twitch URL. When the post is created it appears in a repeating group and the link appears as an embedded video. 

Current State: The entire site is already built using a combination of airtable and bubble.io. This is the last feature that I need. 

Work: I am open to ideas. What I know right now is that it can be done either with a Regex Formula or JavaScript Automation using the video id. 

Budget: Hopefully, under $200. But we can discuss it, based on your idea. 

[TheTimeSavingCo]

The only way I can think of doing this involves having a list of the possible URL patterns and just hardcoding it really.  Do you have a list like that?

[Yuzer]

I am ok with hardcoding. I figured for the first solution I would have to. Here are the different versions of links I think I'll need to cover. Please let me know what you think. 

Embed link: (what I need)

• https://www.youtube.com/embed/iogcY_4xGjo
• https://clips.twitch.tv/embed?clip=BlindingPatientSandstormOSfrog-KIUnsyhNkYdrUJ9g

Submittable Links

• https://www.youtube.com/watch?v=vCCC3gth0Zg
• https://youtube.com/watch?v=vCCC3gth0Zg
• https://m.youtube.com/watch?v=vCCC3gth0Zg
• https://www.youtu.be/vCCC3gth0Zg
• https://youtu.be/vCCC3gth0Zg
• https://m.youtu.be/vCCC3gth0Zg
• https://twitch.tv/erikgriffingaming/clip/AdorableRelentlessCockroachNinjaGrumpy-OfuYEkZopF3C-4Us
• https://www.twitch.tv/erikgriffingaming/clip/AdorableRelentlessCockroachNinjaGrumpy-OfuYEkZopF3C-4Us
• https://www.twitch.tv/erikgriffingaming/clip/AdorableRelentlessCockroachNinjaGrumpy-OfuYEkZopF3C-4Us...
• https://clips.twitch.tv/WanderingAliveFloofRickroll-EBdSDVXzS1t0Xxch
• https://www.clips.twitch.tv/WanderingAliveFloofRickroll-EBdSDVXzS1t0Xxch

[Yuzer]

Hardcoding is what I expected. Here is a list of the URLs examples...

Embed Link Examples

• https://www.youtube.com/embed/HTo_LNYLoKU
• https://clips.twitch.tv/embed?clip=DeadKawaiiMangoRalpherZ-g7CCWMJStQxSTgMk 

Submittable Link Examples

• https://www.youtube.com/watch?v=vCCC3gth0Zg
• https://youtube.com/watch?v=vCCC3gth0Zg
• https://m.youtube.com/watch?v=vCCC3gth0Zg
• https://www.youtu.be/vCCC3gth0Zg
• https://youtu.be/vCCC3gth0Zg
• https://m.youtu.be/vCCC3gth0Zg
• https://twitch.tv/erikgriffingaming/clip/AdorableRelentlessCockroachNinjaGrumpy-OfuYEkZopF3C-4Us
• https://www.twitch.tv/erikgriffingaming/clip/AdorableRelentlessCockroachNinjaGrumpy-OfuYEkZopF3C-4Us
• https://www.twitch.tv/erikgriffingaming/clip/AdorableRelentlessCockroachNinjaGrumpy-OfuYEkZopF3C-4Us...
• https://clips.twitch.tv/WanderingAliveFloofRickroll-EBdSDVXzS1t0Xxch
• https://www.clips.twitch.tv/WanderingAliveFloofRickroll-EBdSDVXzS1t0Xxch

[Yuzer]

@TheTimeSavingCo  Hardcoding is what I expected, so that would work for me. Attached is a list of the email examples

[TheTimeSavingCo · Accepted solution]

Roger that, here

And the formula used is:

IF(
  FIND(
    "twitch.tv",
    {Embed Link Examples}
  ),
  "https://clips.twitch.tv/embed?clip=",
  IF(
    OR(
      FIND(
        "youtube.com/",
        {Embed Link Examples}
      ),
      FIND(
        "youtu.be/",
        {Embed Link Examples}
      )
    ),
    "https://www.youtube.com/embed/"
  )
) & 
SUBSTITUTE(
  REGEX_EXTRACT(
    {Embed Link Examples},
    "[^/]*$"
  ),
  "watch?v=",
  ""
)