Which Functions Overwrites Sheet Data

Data on my sheet has changed. Mostly the top row I’m playing around with when checking a new component or layout. Had a question as to which components or settings overwrite data in my sheet. I can’t seem to put my finger on it but want to see if I can remove it or not use it again in the future. I definitely do not want anything added to my sheet.

Thank you!

There’s lots of ways to write data to a sheet, but all of them involve entry components in one way or another. If you are in Add/Edit/Form mode, then obviously they are going to add or update rows in the sheet. If you are in Detail view with Entry components on the screen, then those will update the sheet immediately without the need for a submit button. If you are on a detail view with no filter, then it will default to the first data row in the sheet and any update through entry components will update that first row. If you have applied any filtering by user, relation, or other means, then the active row you are viewing will be updated if you make any changes.

1 Like

Oh ok! I haven’t used any entry components, so that’s not it. So entry components are the only ones that overwrite data? I saw something about choice components altering data, at least that’s how its explained the glide video.

Where can I find which mode I am in?


Well, really it’s anything that lets you change data in the app. If you add a form button and click on it, then you are in form mode. If you click on the + button, you are in add mode. If you click on the pencil, you are in edit mode. Any other screen is view mode, but if you add components that let you enter or change data, then it will immediately update the sheet when you make changes.

Hmm ok, does choice components change data?

Yep, you are changing the choice, which updates whichever column you have it set to update.

Oh dang. Ok, so I’m trying to create a search tab based on the following options. Is there a way to do it so data is not altered?

Create User Specific columns and have the selections update those columns. Then use those user specific columns to set your filters.

So I pretty much have to copy my entire sheet over to these user specific columns?

There’s nothing to copy as far as data. I don’t know how you have your app set up to work now or how you are currently filtering your list from the choice components, but whatever sheet you are using for your tab, you would just create new user specific columns to store the choice component values. Then adjust your filters to use those columns instead of whichever columns you are currently using.

Ok, this app will be public with no login. Will the user column still work?

hmm…I find it strange how there isn’t a function to just search a column for anyone who access the app via URL.It seems like an easy thing to have as an option.

Ex: Search this column for a yes, or search this column for this specific word, and populate the rows which fall into that into lists.

Yes, user specific columns work in public apps. In your case even better because values are not stored once the app is closed.

You can search, but the value has to be stored somewhere. It can’t just float out there in the ether. Any component has to be attached to a column anyway, so you might as well use the value stored in the column to set a filter. I’m not sure how that part is strange.

Filters on your list based on column values set by the choice components would be your “search”.

Ok…this is how I have it set up on the back end.

I have a filter and visability set to my inline list to show black-owned businesses is are marked as YES in that column.

I added a user-specific column under the header title of ‘search tab’ as a boolean to my data editor. When I select one choice component, they all move. Not sure why that is.

Most likely because you are pointing all of your choice components to the same column, so when you set one to Yes, then the others are changed to reflect the value that was placed into the column. They really should each have their own column.

Also, I don’t see that your filter is set to anything, so I’m not sure how you are actually filtering the data.

Ok thanks! I created one for each.

I thought only the inline list had to be filtered and visibility set, I should filter this one to the same column? Visibility as well?

Also the glide choice component video one seems old as its missing the “Display As” and “Data” boxes. Are those set correctly for me?

Yes, only the inline list should be filtered based on your chosen values. Why are you setting visibility? Are you wanting to make the entire list hide or show, or simply filter it? Don’t worry about ‘Display As’. That’s to save a one value to the sheet, but display a different value on the list of choices.

I want to hide a list if its not what the user chose.

So if they selected Yes for black owned business AND Yes for selling alcohol. Only businesses that fall into those two categories will show up.

Ok, so Choice Component does not get filtered?

No don’t filter the choice component.

Why wouldn’t you just filter the list to only show black owned businesses that sell alcohol, instead of completely hiding or showing the entire list?

I saw it in a video about choice components. If I don’t do that wouldn’t all 9 inline lists how at once? one top of each other.

I was not aware that you had multiple inline lists. They won’t overlay on each other, but they will be stacked. I guess personally I would attempt to use only one list and filter based on the selections. However, I would probably approach this completely differently since your current path may present a lot of gotchas. Maybe some of the newer features would make this easier, but I did something similar in the multi-match filter in https://concepts.glideapp.io/.