# Food Recipes e-Learning App/ YouTube API/Store Showcasing/ Amazon Affiliate Link Generation **URL:** \ **Category:** Project Showcase\ **Created:** [August 27, 2020, 8:37pm UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842 "2020-08-27T20:37:46Z")\ **Posts on this page:** 13\ **Page:** 2
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [November 16, 2020, 2:27pm UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/21 "2020-11-16T14:27:33Z")
Basically, I have a Users sheet, which collects email address automatically since it is connected to User Profile. To the same row, I am trying to add more information by collecting it from the user at the beginning after they sign in using pin. Add Row button adds a new row which doesn’t serve the purpose. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 16, 2020, 2:52pm UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/22 "2020-11-16T14:52:44Z")
So you’re referring to an onboarding process? > [@Copyable: A Tribute To Chadwick Boseman & The World Of Randomness](https://community.glideapps.com/t/copyable-a-tribute-to-chadwick-boseman-the-world-of-randomness/15768): > > Hi Gliders, it has been a while since I shared my last tutorial and I plan to do this once in a while, so here’s my next one. You can view my previous post here: Techniques used in this app: Tab visibility for sign up process Random value from single value column to change image & quote on homepage Combining multiple random values and use split text for gamification Conditional visibility + Cloudinary for a quiz-like experience App link: For this post, I make an app to pay tribute to M… I have an example for that in the link above, hope it helps. ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [November 16, 2020, 11:32pm UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/23 "2020-11-16T23:32:16Z")
Thanks, it helps, I get the idea of making components visible and not visible based on completion conditions for each input. But, how I do direct users to a tab (Welcome tab with onboarding components) connected to the User Profiles sheet right at the beginning, and then show another tab once the onboarding process is completed, but without the Welcome tab shown at the bottom, since it is only for the purpose of onboarding? In Chadwick’s app, there is no tab visible at the bottom at the start, though the condition for that tab is to show when Profiledone is not 1. So, how was the tab hidden from the bottom part, still showing up as the first page? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 17, 2020, 12:08am UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/24 "2020-11-17T00:08:36Z")
> [@vijay](#): > > But, how I do direct users to a tab (Welcome tab with onboarding components) connected to the User Profiles sheet right at the beginning I used the User Profiles sheet for that sign up tab, and filter it by email is signed in user in a details view. When the user logs into the app, they already have a row with their email. I just make entry components for them to add other details to their profile. Then as the ProfileDone is 1 after pushing the button, the Welcome/Sign up tab will be hidden as the ProfileDone is not 1 anymore. ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [November 17, 2020, 1:44am UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/25 "2020-11-17T01:44:19Z")
Yes, that can be done. But, in the above foodcouture app and Chadwick’s app, the onboarding form has no tabs at the bottom. So, how to hide the Welcome/sign up tab, yet show its components? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 17, 2020, 2:34am UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/26 "2020-11-17T02:34:06Z")
If you have only 1 tab visible to the user then it automatically hides I think. Can you confirm? ---
**Author:** ![vijay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vijay/32/3259_2.png) [@vijay](https://community.glideapps.com/u/vijay)\ **Post date:** [November 17, 2020, 5:23am UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/27 "2020-11-17T05:23:46Z")
Yes, that’s magic by glideapps! Thank you! 😀 ---
**Author:** ![Purvang\_Joshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/purvang_joshi/32/12645_2.png) [@Purvang\_Joshi](https://community.glideapps.com/u/Purvang_Joshi)\ **Post date:** [November 20, 2020, 5:23am UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/28 "2020-11-20T05:23:15Z")
Hey, sorry for the late reply. I was bit busy. Hope you get the way of it. I’ve a validation for the user profile Components. Like I’ve validation of if else, it manually checks whether all entry fields are empty or not. When all fields are not empty then one row will convert to true otherwise false. So, when user upload image at the last and then it clicks on the checkbox on my app. All condition went successfully, so it’ll turn into true. Now, for all other tabs I’ve visibility condition that in user profile that particular row should be true. Then within in seconds, tabs are showing out. The real power of Glide. Let me know if you have any doubts or helps. Glad you like my app😊 ---
**Author:** ![Johanna](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/johanna/32/22095_2.png) [@Johanna](https://community.glideapps.com/u/Johanna)\ **Post date:** [September 1, 2021, 6:51am UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/29 "2021-09-01T06:51:04Z")
Hi @Purvang_Joshi , Your app looks great and I am interested in de functionalities that you built. Would it be possible to see the actual table set-up? Or make a copy? Best regards, Johanna ---
**Author:** ![Purvang\_Joshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/purvang_joshi/32/12645_2.png) [@Purvang\_Joshi](https://community.glideapps.com/u/Purvang_Joshi)\ **Post date:** [September 4, 2021, 8:53pm UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/30 "2021-09-04T20:53:13Z")
Hey Johanna, It’s not possible to show you the tables. But It contains relations between user profiles, classes, and paid classes. My sheet is too much complicated to show you. Let me know if you need any help. Thanks ---
**Author:** ![Johanna](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/johanna/32/22095_2.png) [@Johanna](https://community.glideapps.com/u/Johanna)\ **Post date:** [September 15, 2021, 11:54am UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/31 "2021-09-15T11:54:34Z")
Hi Purvang, Thanks for your reply. I am particularly interested in how you imported de amazon affiliate link and have the product shown in you glide app. Quote: ’ _For kitchen appliances/tools, we’re helping the community to get things easily. By submitting the URL of any product from Amazon, it’ll fetch ASIN code from that link. Now, it’ll generate an affiliated link in realtime. Also, a product image will be shown from the ASIN code. ’_ How do you submit these URL’s? I am interested in how this proces works. Thanks Johanna ---
**Author:** ![Purvang\_Joshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/purvang_joshi/32/12645_2.png) [@Purvang\_Joshi](https://community.glideapps.com/u/Purvang_Joshi)\ **Post date:** [September 15, 2021, 12:22pm UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/32 "2021-09-15T12:22:31Z")
Hey Johanna, ASIN No. would be fetched from MID function in google sheets Column 1 is the URL Column. Insert the Formula to 2nd Column: =ARRAYFORMULA(IF(LEN(A2:A)=0, MID(A2:A,26,10))) Here in India, we’ve amazon.in. So, you’ve to shift numbers in function. For .com you’ve to change 27,11. For Generating Affiliate link, create a template column add parameter tag= {Your Unique TAG} [https://www.amazon.in/dp/ASIN?tag=](https://www.amazon.in/dp/B00XRJBOBA?tag=studiodefoodc-21) For Product Image, Replace ASIN with Number in template column. [http://images.amazon.com/images/P/ASIN.01._SCLZZZZZZZ_.jpg](http://images.amazon.com/images/P/ASIN.01._SCLZZZZZZZ_.jpg) For fetching product title/pricing many tools are available online. You can also use google sheets formula for it. =REGEXREPLACE(ImportXML(“[https://www.amazon.in/dp/"&B2,"//title"),"Amazon.com:](https://www.amazon.in/dp/%22&B2,%22//title%22),%22Amazon.com:) “,””) Just Replace [amazon.com](http://amazon.com) or whatever. Here are some links you may rely on: > **[🛒 Amazon Scraper: Unlock Amazon data in Google Sheets - NoDataNoBusiness](https://nodatanobusiness.com/recipes/scrape-amazon-product-data/)** > > As an ecommerce professional, you understand the importance of gaining access to competitor product information and monitoring your own products on major retailers like Amazon. But the effort it takes to manually scrape product data from Amazon,... > **[Pull Amazon Data into Google Sheets - Gorilla ROI](https://www.gorillaroi.com/pull-amazon-data-google-sheets/)** > > Pull Amazon data into Google Sheets. Use our custom spreadsheet formulas and Google functions to import Seller Central Data into Sheets. ---
**Author:** ![Johanna](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/johanna/32/22095_2.png) [@Johanna](https://community.glideapps.com/u/Johanna)\ **Post date:** [September 15, 2021, 2:26pm UTC](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842/33 "2021-09-15T14:26:58Z")
Hi Purvang\_Joshi, Many thanks for your elaborate answer. I will try to reproduce this in my app. Cheers Johanna [Previous page](https://community.glideapps.com/t/food-recipes-e-learning-app-youtube-api-store-showcasing-amazon-affiliate-link-generation/14842.md?page=1)