My need
Well, It turned out that I needed one app where I could add youtube links and watch them inside the App. I was able to do that but I always needed to get the embed link, which was a pain in the neck. Then I thought:
"What if I could just paste the link of the video and run a scrip that extracts its embed link?"
Setting the Appsheet columns
*** It is important to have in mind the SHOW columns will only appear in detail views if you set it in the Column order.
Appscript and automation
1. Go to your google drive and create a Appscript
2. Copy the following link:
Name your file the way you want and save it.
3. Create a BOT automation. The event you choose. I set it as follow:
4. In the process Follow the steps:
choose call a script >> Table name >> Searc and select the Script you created >> Give permissions >> Function Paramenter = The Youtube link column >> Return Value = String >> Specific type = URL
5. Create a new step and set just like that:
In Set these column(s) choose the embed link column and and use the formula
In my case it is [new step].[Output] because this is my process name, it may vary depending on its name.
Result
No need to check for embed links anymore and I can add any video from youtube for every particular entry.
PS: Do not show the embed link for people might "break" it in your app.