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!

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? Thanks!

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? [Image 23]

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”.

Which Functions Overwrites Sheet Data

Ask for Help

Jeff_Hager August 8, 2020, 8:06pm 22

For reference:

Topic		Replies	Views
Spreadsheet Editor Ask for Help	7	470	January 30, 2021
Filter multiple sheets by choice component Ask for Help	6	262	February 12, 2024
Connect Choice Components to In-Line Lists Ask for Help	20	1338	August 10, 2020
Device specific values Feature Requests	1	387	January 10, 2020
Overwrite cell data using form button Ask for Help	5	632	October 14, 2020

Which Functions Overwrites Sheet Data

Related topics