Food Recipes e-Learning App/ YouTube API/Store Showcasing/ Amazon Affiliate Link Generation

Project Showcase
21

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.

22

So you’re referring to an onboarding process?

I have an example for that in the link above, hope it helps.

23

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?

24

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.

25

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?

26

If you have only 1 tab visible to the user then it automatically hides I think. Can you confirm?

2 Likes
27

Yes, that’s magic by glideapps! Thank you! :grinning:

1 Like
28

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😊

29

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

30

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

31

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

32

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=

For Product Image, Replace ASIN with Number in template column.
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: “,””)
Just Replace amazon.com or whatever.

Here are some links you may rely on:

2 Likes
33

Hi Purvang_Joshi,

Many thanks for your elaborate answer.

I will try to reproduce this in my app.

Cheers
Johanna

1 Like