Hi guys, I created a star ratings & review workflow (EDIT: and used the same concept to create a detailed application form) that does not increase the number of rows in the app and records all submitted data to a single cell. At the moment it works like a charm for adding new reviews. It’s an alter…

So you’re storing the log of all ratings in two basic columns: All Stars and All Reviews, is that correct? You are delimiting them by “+” characters, and not using JSON?

[image] ThinhDinh: So you’re storing the log of all ratings in two basic columns: All Stars and All Reviews, is that correct? yes [image] ThinhDinh: You are delimiting them by “+” characters, and not using JSON? Kind of but it isn’t used as a delimiter for the star values… I’m using “…

Ya, I was thinking it would be clean if you store a JSON of all reviews, then use JSONata for querying out the average.

Oh ok! how is that done? The current columns look like this. The Combining column already sees that 3 is being written. When I click submit, the user specific rating of 3 will be added to “All Stars” and the Av Star Rating will update. [image] For the full reviews, no math is done, only concaten…

[image] Sekayi_Liburd: Oh ok! how is that done? Something like this I guess. [image] dizzyaccordion JSON Trebuchet Community Resources wave Hey fellow Gliders! Part two of my Trebuchet series is live! Last week, I posted a tutorial on a new way to crea…

I looked at the Trebuchet videos. Very sophisticated! @Robert_Petitto is a real gem for sharing that with us. Correct me if I’m wrong though… I don’t think it fits my use case since I’m not working with signed-in users so that pretty much throws user editing out the window. Another hiccup is that …

If you’re on the latest plan and use Glide Tables, it doesn’t incur updates.

ok great. I’ll see if I can make the workflow more sleek with JSON. Is there a list of free integrations that I can refer to? I pretty much never click on integrations because I’m afraid of using updates. **oh, another question. My app has slowed down in the past month. Would using JSON slow it do…

If you’re on a new free plan, then you shouldn’t have access to anything that will consume updates.

Star Rating Reviews & Detailed Form - Single Cell - No sign-in option

Community Resources

ThinhDinh June 4, 2024, 11:51pm 6

Something like this I guess.

Topic		Replies	Views
Rating Ask for Help	24	994	June 16, 2020
Best practices pls for image sharing & storage from anywhere in app Ask for Help	35	772	October 19, 2021
CRAZY USECASE: Overloading app in a level that created hours delay in writing to Sheet Ask for Help	53	1823	January 17, 2024
No Sign-in, Community App w- Chat Room, Star Reviews & User Application Features from Single Row/Cell in Glide Editor Project Showcase	22	404	June 15, 2024
User Specific Columns + User Profiles Demo Community Resources tutorial	89	5240	May 31, 2020

Star Rating Reviews & Detailed Form - Single Cell - No sign-in option

Related topics