Allowing your users to add, edit, and — if you're feeling really brave, occasionally delete data — opens up a whole new dimension for your apps and the ways they can be used.
We’re going to look at four things:
Some components are editable by default. In other words, anyone who can access your app can edit them, even if you haven’t enabled editing. For example, components like;
Number Field and
Phone Field are all editable components.
If you want to allow your users to edit entire list items, then you can enable
Allow editing. To do this, navigate to the details screen of a list item and click
Allow editing. Now you can allow your users to edit all or some of the data which appears in your app.
When you click the edit button in Glide, two things happen
Firstly, the app changes to show you the edit page
Secondly the components panel on the right changes to show a new set of components that are your edit screen components.
Glide will add these edit screen components automatically, based on the columns in your sheet, but you can customize these to change what data can be edited.
Now your users can edit each of your list items and these changes will flow up to your sheet. When they finish editing, their changes will be reflected in the original set of components.
If you want users to only be able to edit certain columns, you can delete these from your edit screen component list. For example, if you delete the
Text Field which is bound to the
Name column - users will no longer be able to change the name of your list items, but can still change all the other data.
You can enable editing individually for each tab, so you can allow users to edit certain tabs and not others.
You can also use conditions to change what can be edited and who can edit it. Read more here 👇
When you enable
Add item, users can add data to your sheet. Like
Add item is tab specific, so you can enable add item for some tabs and not others.
Adding an item brings up the same editable component list that we had on the edit item page. What you change in this component list will be reflected in the edit item list as well. For example, if you delete the
Text Field which is bound to the
Title column, this will also be reflected in your edit item screen.
Similarly to editing, you give users access to only certain columns when they add items. For example, if you want to allow users to add places to visit in a city guide app, but don’t want them to be able to choose a category for their submissions, you can make sure the
Category column is not bound to an edit screen component.
If you don't see newly added items in your sheet, scroll all the way to the bottom to check if they are being added after empty rows. By default, new Google Sheets contain 1,000 empty rows, but for a variety of reasons, these rows can appear non-empty to Glide.
If you want your users to be able to delete entire list items, open the edit screen in the app, head to the edit components panel on the right and enable allow deleting. When a user deletes an item, this cannot be undone in Glide or in your sheet - so make sure whoever is using your app knows this.
If you want to restrict your app to only be used by certain people, then you can of course change the sign in settings.