How to view forms inside the app

Feature Requests
1

Hello guys,

I am wondering how can I view the forms inside the glide app instead of opening google sheets and scrolling through rows of data? Can I have a summary of most recent or ordered by date forms?

Thanks.

2

Hi Melisa,

What kind of information are you collecting through the form? Those things are definitely doable with the right setup of your sheet and relations inside Glide.

3

Well.

Info type is data, producer, item, size, quantity. These will be entered on a daily basis and it would be nice if we could check them through the app and on the go instead of opening laptops etc.

4

Hi Melisa I’m back with what would work for your case.

image
image338×510 18.2 KB

I have a form to submit the information as you stated.

image
image319×506 9.63 KB

I have a Rollup column to take the latest value from the submitted time column, then do a relation back to that same submitted column to get the latest form submit.

image

For the date choice view, I have a choice component that takes values from a “Date” only column, computed in the Sheets.

image
image711×197 17.8 KB

Then I do a relation that matches the user-specific “Date choice” to the “Date extracted” column in the sheets and return multiple matches. I showed it in an inline list, calendar view.

image

image

You can try it out yourself here in the “Latest form submit”.

1 Like
5

Add a video of it in action.

ezgif-3-6bbe3ce3c10a

6

Maybe I’m not seeing the whole picture, but why not just creating a new tab that points to the forms sheet, and filtering it by date?

7

Thanks for pointing that out, I think it’s just another solution for this and Melisa can choose whatever option she likes. I just wanted to make it quick this morning and did not want to make a new tab lol.

8

Hi Thinh,

Choice option looks good.

But, I am having problem computing the formula in sheets. I have copied exactly you formula but I am getting a #REF! error. (it says please insert more rows(1). Date submission is a date only format, as well as date extracted. Am i doing something wrong?

9

It is something with the range. On reflection I saw I make a mistake in the formula as well, the DATEVALUE(A2) should be DATEVALUE(A2:A), can you try it again and tell me if it works?

And did you put the formula in the first cell of the column?

10

NOpe. Still not working

11

Can you send me a copy of the data in personal message?

12
13

Hi Melisa, can you give ariesarsenal@gmail.com access to edit? Which of the sheets do you want to have that formula in?

Edit: This issue was resolved after some chats in the Sheets.

1 Like