# Is there any limit for database columns?

**URL:** <https://forum.bubble.io/t/is-there-any-limit-for-database-columns/47449>\
**Category:** Database\
**Created:** [January 21, 2019, 9:32pm UTC](https://forum.bubble.io/t/is-there-any-limit-for-database-columns/47449 "2019-01-21T21:32:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ulrich\_00132](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ulrich_00132/32/107834_2.png) [@ulrich\_00132](https://forum.bubble.io/u/ulrich_00132)\
**Post date:** [January 21, 2019, 9:32pm UTC](https://forum.bubble.io/t/is-there-any-limit-for-database-columns/47449/1 "2019-01-21T21:32:20Z")

</div>

Hi everybody,

I created 18 inputs field and but only 7 appear in the database and only 1 data is collected in the database.

It’s strange. Can somebody help me please?

Thank you

---

<div class="post-metadata">

**Author:** ![mebeingken](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mebeingken/32/20139_2.png) [@mebeingken](https://forum.bubble.io/u/mebeingken)\
**Post date:** [January 21, 2019, 9:47pm UTC](https://forum.bubble.io/t/is-there-any-limit-for-database-columns/47449/2 "2019-01-21T21:47:14Z")

</div>

Hey @ulrich_00132,

Have a look here:

> [@Is it just me or "a thing" is only limited to 7 fields?](http://forum.bubble.io/t/is-it-just-me-or-a-thing-is-only-limited-to-7-fields/37669/4):
>
> From the database view, Bubble’s preview only provides the first handful of columns. If you want to display all of the fields (or a different subset, along with constraints), you need to set up a custom view. See video below for a quick walkthrough of how to set up a custom database view. [learnbubble-walkthrough%20\_%20Bubble%20Editor]

  

* * *

> **Looking to accelerate your app development?**
>
> Let me turn  
> 🤔 😫 😖
> 
> into  
> 😀 🕶 👩‍🎓
> 
> Development through Coaching at [https://uniqueideas.com](https://uniqueideas.com?utm_source=bubble&utm_medium=forum&utm_content=signature-unique-ideas&utm_campaign=builders) or schedule a [free intro session](https://uniqueideas.com/coaching?utm_source=bubble&utm_medium=forum&utm_content=signature-free-intro&utm_campaign=builders) 🎁
> 
> Ken Truesdale  
> [LinkedIn](https://www.linkedin.com/in/mebeingken/)

---

<div class="post-metadata">

**Author:** ![ulrich\_00132](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ulrich_00132/32/107834_2.png) [@ulrich\_00132](https://forum.bubble.io/u/ulrich_00132)\
**Post date:** [January 21, 2019, 9:57pm UTC](https://forum.bubble.io/t/is-there-any-limit-for-database-columns/47449/3 "2019-01-21T21:57:15Z")

</div>

MAGIC !!! Thank you @mebeingken. But I still have a problem. All my field with “number content or value” like age, phone number etc… show me an error message. But I don’t know why. I’ve set all field as a number in the data base and in the workflow.  
But it want me to choose: GSM = Input Tel GSM’s Value and more (why more)??.  
 ![Bubble%20input%20issue](https://us1.discourse-cdn.com/bubble/original/3X/5/c/5c97a840fee640886f372f9da181ab9efaef11ad.png)

---

<div class="post-metadata">

**Author:** ![mebeingken](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/mebeingken/32/20139_2.png) [@mebeingken](https://forum.bubble.io/u/mebeingken)\
**Post date:** [January 21, 2019, 10:00pm UTC](https://forum.bubble.io/t/is-there-any-limit-for-database-columns/47449/4 "2019-01-21T22:00:01Z")

</div>

Your field data type must match your input type. Change the element content format to something that evaluates to a number (integer, decimal, etc.)

---

<div class="post-metadata">

**Author:** ![ulrich\_00132](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/ulrich_00132/32/107834_2.png) [@ulrich\_00132](https://forum.bubble.io/u/ulrich_00132)\
**Post date:** [January 21, 2019, 10:16pm UTC](https://forum.bubble.io/t/is-there-any-limit-for-database-columns/47449/5 "2019-01-21T22:16:26Z")

</div>

Thanks it works.  
I set email as a text in data type, even it mach my input type, it doesn’t work.

Big thanks for your help. I appreciate.