Only one row per day per user, Why does glide make 2?

Ask for Help
1

Hi,
My users has to fill a questioner once a day.
Each day they enter the questioner and creates their one and only individual row and start with the questioner.
*All the questioner pages are filtered to show the user:
1. last row within today

The problem:
For some reason, after 1-2-5 min into the questioner , the app “restart” (they see white screen - > then - > spinning circle - > and then back to the beginning.
They have to enter the questioner again and the button creates new row again.
It confuses the filter condition because now we have 2 rows within today so the user can not make any progress.

The solution that I did:

  1. I created a condition in the questioner button that says: if the last row it within today , then - > delete it and create a new one. if not - > then - > create a new one.
    it does not work, I guess because does not “See” the new row after the “restart”.
    So what is the solution for this?

I am using glide classic, I know its not supported anymore but I pay more then 400$ a month for usage and expect for help.

Thanks.

2

Wouldn’t you be able to:

  • Use a query column to query the “row within today” of the signed-in user. Add a single value column on top of it to retrieve the first whole row.
  • In the button, if the query column is empty, add a new row and show the screen.
  • If the query column is not empty, show the details screen of the single value > first whole row.
2 Likes
3

Do you know if you are using a native form or a custom form? To me it seems you might be using a custom form. Any reason why you are not using a native form for your questionnaire?

4

The questioner is about 50 questions, Around 20-40 pages. and the amount of the questions that the user sees is depends very much on the previews answers.
Which means it has to be costume “form” with a lot of “visual conditions”.

5

Have you tried to implement Thinh’s suggestion above?

It would launch a custom action with two branches and maybe prevent from creating a new row if the current one is not completed. You might have to add a DateComplete timestamp column and include a non-empty filter in Thinh’s query column.

1 Like