Hi, I am making an application that can collect rating from user and I want to automate some columns that can total all marks and give out percentage of the rating in excel but the data inserted from user will instead go into a new row instead of inserting into the row that have formula. Does anyon…

Glide will not populate row even if they appear empty, but already have a formula in them. You should be moving your logic into Glide. [image] star_struck Rating Component: Display Average Star Rating Community Resources star_struck Star Ratings are back! The…

Thanks for the reply! This would definitely work if my max rating is 5 but my client would like the max to be 7 hence my confusion. I solved the problem just now by extracting all the value of the rating using importrange formula in excel and do the calculation in another sheet. It works but uses mo…

[image] NADHIRAH_HALIM: I hope Glide can add a formula feature in the future. Not quite sure what you mean by this. Glide does have a “formula feature” - it’s called Computed Columns .

I feel like a Rollup column and a Math column would do the same thing without all of the extra work.

I didnt know this. I could try in the future. Thankyou!

Yes, I think so too, I’ll try tomorrow

How to enable data inserted into a row which some columns have a formula

Ask for Help

Jeff_Hager December 5, 2023, 7:09am 2

Glide will not populate row even if they appear empty, but already have a formula in them. You should be moving your logic into Glide.

Topic		Replies	Views
Data entry using basic table layout Feature Requests	7	901	February 9, 2021
How do you add functions to rows you add with glide? Ask for Help	5	2409	October 5, 2020
Automatic Calculation Ask for Help	6	193	May 29, 2024
Add spreadsheet computed column Ask for Help	5	607	July 24, 2022
How to implement ⭐ ratings - Demo [Update: Glide released this as a native component.] Project Showcase	14	3595	July 10, 2020

How to enable data inserted into a row which some columns have a formula

Related topics