Hi,
I have fitness app, The user press: “START” and go to the exercise page.
The exercise page is dedicated for the user “TODAY ROW” and not any other older rows.
In the background the app creates ONE NEW ROW specific for the user within the start pressed.
The problem:
Sometimes I see that the system created more then 1 row for specific user, maybe because of lag, the user has to press 2-3-4 times in order to go to the next page.
So I set a condition that says the button is visible as long at no one pressed on it - that did not work.
If the user has more the 1 row today, he wont be able to procced with the exercise, the system is stuck.
What is the solution for this?
I thought maybe to set the exercise page to last row today, and then it does not matter how many rows it will create today , the page will “look” (filter) only on the last row today.
If this is the solution, How to achieve this?
The 2nd problem:
When the user wants to finish before the end of the exercise the system ‘deletes’ the row of today.
Sometimes the system does not delete, and the row re-appear for 10-15 minutes.
Even if I delete is manually from the builder, it still getting back after a few seconds.
any solution for this?
There are XXX users, Each day the user open the app, Begins with the personal exercise.
After he finish, he needs to insert a feedback and some numbers.
That’s why I need new row for every user’s personal activity.
When the user finish the exercise, The row still there, tomorrow he has to create new row with new input information.
The problem is that sometime Glide creates 2 new rows (that does not appear on google sheets).
And it “confuses” the system, then the user stuck.
If it try to delete the extra row manually (so the user can proceed) and row re-appear after few seconds, after 5-10 minutes the row deletes.
Sorry, why you use Google sheet for it? For xxx users every day you will over any update limits on new plans. Is better to use glide table it much more stable with this using case. I think.
Actually, GS not fit for intensively using as DB (i remember some Glide experts say). Especially to multiple users simultaneously write to it. Many years, i see many reclamations for GS connection and using. I use GS source just as read only, when there is have no another way to receive external data.
Any way you can have support from Glide if you on business(not shure for legacy, but must)
I suggest you find the article with the request and vote.
Also, it is very helpful to rebuild your app from scratch. Every new app which i doing from scratch have double faster response compared to previous version.
It has a LOT of votes. I don’t think it’s going to happen. It’s been requested since they stopped supporting GSheets for Templates, which was a LONG time ago. I think they count on attrition for a lot of things.
I think they awaiting 10000 votes.
Glide told as they have three copies of gs:
One in gs it self
Second in user device
Third in Glide server
So it is very simple just copy all gs rows and columns from glide copy’s like a basic columns to new glide table and redirect all computed columns to newly glide table. It is simply enough to most reasons. May be. I think.
Why it is complex? Actually gs copy in glide server is a native table with basic columns with just a values imported from google? No?
I would suggest creating a datetime column in your User Profiles table.
Only show the “Add” button for the new day when that datetime column is not within today.
When the user clicks the button, apart from adding a row, set the current datetime to the column above. It should immediately eliminate the possibility that the user can click again.
This is exactly what I did in the beginning of the development.
The button has visibility condition that says: show "if new row today is empty.
Then the moment the user hits “START”, a new row added.
But, from some reason 2 or more rows appear.
And if I try to delete the extra rows, and re-appear after a few seconds and stay there for about 5-10 minutes.
By the way , I did opened a ticket with glide support , Because I am on classic (and even though I am on business) - they said that they don’t support classic anymore and can’t help me with that - VERY FRAUSTRATING.