# Allow app users to create sheets and columns

**URL:** <https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602>\
**Category:** Ask for Help\
**Created:** [September 10, 2021, 8:51am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602 "2021-09-10T08:51:50Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![michaels3d](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michaels3d/32/31565_2.png) [@michaels3d](https://community.glideapps.com/u/michaels3d)\
**Post date:** [September 10, 2021, 8:51am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/1 "2021-09-10T08:51:50Z")

</div>

Hello,  
I am just getting started with Glide and haven’t seen any information on allowing users of the app to create their own content from nothing (i.e. sheets and columns). Adding rows to a sheet with predefined columns is very simple, but I would like my users to define their own columns.

For example, as a user of the app (not in the Glide builder), I want to create a new blank form, and add fields to this form that have not been predetermined.

Is this possible? Thanks!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 10, 2021, 9:03am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/2 "2021-09-10T09:03:51Z")

</div>

This is not possible because let’s say your users want to add a form for themselves then you as the app owner will still have to point that form to the newly created sheet manually.

Why do you want your users to be able to do so though?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [September 10, 2021, 9:23am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/3 "2021-09-10T09:23:11Z")

</div>

it is possible… if you don’t mind scripts… but i can bet there is much easier solution for your problem… is all about creating your own forms

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [September 10, 2021, 9:58am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/4 "2021-09-10T09:58:35Z")

</div>

I would approach this something like this:  
Create a table with: Row Type (Column Name\Data), User ID and many free text columns,  
have each user insert his own column names in user specific columns and then have the form be displayed based on the signed in user or viewed user.  
you would need a relation to each data row to lookup the name of the fields per user.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [September 10, 2021, 10:17am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/5 "2021-09-10T10:17:01Z")

</div>

how did you solve inserting column names into the first row? without scripts?

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [September 10, 2021, 10:22am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/6 "2021-09-10T10:22:37Z")

</div>

I would use the data labeled “column name” in a row type column.  
have each user construch his own form.  
the when displaying the form use these columns as the field title

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/4/3474c3eb2b58fc87c0b4d63f9bed6b2e46627877.png)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [September 10, 2021, 10:23am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/7 "2021-09-10T10:23:59Z")

</div>

in this sample, you are not creating a new column… this a new screen or element

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [September 10, 2021, 10:25am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/8 "2021-09-10T10:25:12Z")

</div>

its the same columns, just dynamic names.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [September 10, 2021, 10:26am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/9 "2021-09-10T10:26:25Z")

</div>

you are missing a point of this subject… create a new column with a new name

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [September 10, 2021, 10:28am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/10 "2021-09-10T10:28:36Z")

</div>

I am trying to give another solution that doesn’t involve scripts as not everyone here is skilled in programing.  
and add columns is not possible in Glide

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [September 10, 2021, 10:29am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/11 "2021-09-10T10:29:50Z")

</div>

it is possible, but you are giving very bad solutions… your solution is to name a Glide screen… question was… if is possible to name / create a column… or sheet

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [September 10, 2021, 10:42am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/12 "2021-09-10T10:42:32Z")

</div>

> **[Lin's App · Glide](https://www.loom.com/share/8c00f75466c54c40b7fe446515995fb4)**

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [September 10, 2021, 10:45am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/13 "2021-09-10T10:45:10Z")

</div>

by the way my screenshot is name a column not a screen.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a7c3d63c13e1a157ef5ec418ed6104f21d2bd14a.png)

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [September 10, 2021, 10:51am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/14 "2021-09-10T10:51:18Z")

</div>

excellent reply!.. I’m impressed! is not solving the subject… but, i love it!!!

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [September 10, 2021, 10:54am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/15 "2021-09-10T10:54:44Z")

</div>

I believe it is possible to solve this way and build a dynamic form the changes based on the signedin user.  
wasn’t that the question?

> [@michaels3d](#):
>
> allowing users of the app to create their own content

> [@michaels3d](#):
>
> I would like my users to define their own columns.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [September 10, 2021, 10:57am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/16 "2021-09-10T10:57:45Z")

</div>

@Lin_Altshuler it was a genius answer for a no-code user, I think you u have a bright future in the yes code community…

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [September 10, 2021, 10:58am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/17 "2021-09-10T10:58:50Z")

</div>

Thank you 🙂

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 10, 2021, 11:00am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/18 "2021-09-10T11:00:54Z")

</div>

There’s still a lot in the way to create a custom form.

Let’s say you allow each user to have a template form, then theoretically a user can choose that template and via relations & lookups you can return the right title for those.

However not every entry is a text. Let’s say they want date/time in component 2, file picker in component 3 and image picker in component 4. How do you solve that?

That’s not to mention the “required” part will be another headache. That’s too much to build in my honest opinion.

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [September 10, 2021, 11:02am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/19 "2021-09-10T11:02:37Z")

</div>

Yes I know its not ideal. but what do you suggest?

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [September 10, 2021, 11:04am UTC](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602/20 "2021-09-10T11:04:16Z")

</div>

and yes code community… speaks out! LOL  
@Lin_Altshuler apps are designed to work fluently no matter who used them… that’s why some of us will give answers that might not look good on the first approach

[Next page](https://community.glideapps.com/t/allow-app-users-to-create-sheets-and-columns/31602.md?page=2)
