Hey guys, hope all is well.
im making a travel app with all the destinations around the world. therefore I allow users to write a review about the destination which then will allow all users using the application to see the review. so i know i need to use cloud variables but how will i do that? I’ve been looking at cloud variable docs and videos but still dont get it 
help please. thanks!
A while back, our friends at No Code Devs did a tutorial on creating a Yelp-like app using Xano. You could apply the same logic but replace app or stored variables with cloud variables and connect to Firebase instead of using the Xano API.
Hi @matt_conroy, is there the project link that I can take a look at? Because the video is very fast paced an im not able to see all the code to understand the logic in it.
thanks
Could we see the code?
From what I can think of so far, you could probably use a google sheets that when someone submits a review, it creates a row in the sheets with their name, destination, review, and other stuff you may want to include.
yes but what i want is that under the destination, you will see reviews, i dont want a page of just random reviews if you get what i mean. please let me know if u think i have misunderstood u
No, you know what I mean, if there aren’t too many destinations, you could include a seperate sheet for each destination, however, if there are a lot of destinations, a method I used was filtering them out.
Here is a screenshot of my code I used for the project I am working on at the moment.
Tell me if you need some clarification into how it works.
hi i dont get the use of the objects.
sorry, im just really new to object blocks and data sources. hope you dont mind
It’s okay.
I only starting using the object thing recently too (around a month ago)
Basically, in a data source, you can get a row object, and to search up what value is in that row for a certain column, you use it. For example:
| Destination | Review | Notes | |
|---|---|---|---|
| Paris | 4/5 | Very good!!! | |
| Rome | 4.5/5 | I love it!! |
if this was in a spreadsheet called Destination App, and the spreadsheet was called Destination reviews, the purple block above would be
get row object from Destination App
in Destination reviews
in default view
for row id (insert the row number e.g. 1 for Paris and 2 for Rome)
This gives a random string of letters or numbers (I think so).
The get property of object then asks for a value (which is the title of the column e.g. destination, review and notes in the example above).
You would then get the row object in the second position and it will give you the value of the item in that spot in the spreadsheet.
My code basically goes through all the values in the spreadsheet, and adds all of the ones that are for a specific manager (in your case a destination) to a list, including a separate list with all the row numbers.
Don’t worry about how it say new for the last value in the purple blocks. This is because of the filter views. It will still work with just the default view.
Feel free to ask anymore question to clarify what I just said if you didn’t understand it.
If you need I can create a mockup version of your project if that would help.
Also, sorry for the long answer. I wanted to just try to explain it as simply as possible and I end up making my answers big.
I also found this video series helpful in learning how to use google sheets.
It is about updating employee profiles, but this can be easily changed into a reviewing app.
There are also some other videos in the series all ending in Data Source, found on the thunkable youtube page.
Hi @terraceaccapp3hc7yk, I thank you so much for your time taken. The information can help me to learn and develop my app development journey in Thunkable! I kind of get what you mean now. You don’t have to make a mockup project for me, but if you did that would help me a lot. (I’m more of a learner through seeing, instead of reading.)
So there are 2 things I want:
Both of these I would have an idea of how to do it, but dont know how to implement that idea into it. I would mainly focus firstly on the first need since I would probably get how to display the data after knowing how to upload data. I thought of adding multiple rows for multiple reviews but then I would have to create many rows of the same destination which then would affect my other data viewers.
Sorry for the long requirement, it’s just I have a lot I need help with!
Once again, thank you so much! Have a good day!
It’s okay!
I am probably more of a person who learns through looking through remixed projects.
Tomorrow I’ll starting making a quick mock-up and I’ll post it here once I’m done.
Sounds like an interesting project.
Bye!
Thank you SOOO MUCH. I really appreciate how much you are putting into this!
It’s okay.
I was kind of just bored on thunkable and wanted to see if there was a question here that seemed like something I had already dealt with.
Here is the link to the project and the google sheets.
Make sure you connect the project to the google sheets.
This was quickly made as a mockup by remixing one of my projects I’m working on, so it may have a few bugs.
If there are any problems, with the project or you can’t access the links below, tell me and I can try and sort them out.
https://x.thunkable.com/copy/49f202727ba15382a590e1fb306083b9
Hope this help!
EDIT: I have deleted the project above but if you scroll down a bit, ant_1 should have another link to his version of the project (remixed from mine).
EDIT: Hope this works: Thunkable
hi @terraceaccapp3hc7yk, thanks for taking your time to do this. When I look at the table, it just has thunkable everywhere
which table?
If it is the Destination App Google Spreadsheet, then you may need to make a copy of it.
ok thanks
hi, i tried it and it worked perfectly. would it save for all users on the app even on different devices. cause thats exactly what i need. therefore would you mind searching up ‘Hong Kong’ on the search bar please?
thanks.
Hi.
Yes it should work on other devices as I tested on my phone.
I would not be able to test hong kong unless you share the link to your remixed version of that thunkable project.
When you do that, I will be able to search Hong Kong and give you the results.
Also, you don’t need to send me the google sheets, only the project so I can access it.
nevermind tested it with 2 different devices and it worked beautifully! thank you so much!
