# Inserting multiple data into one column

**URL:** <https://community.glideapps.com/t/inserting-multiple-data-into-one-column/63567>\
**Category:** Ask for Help\
**Created:** [July 6, 2023, 11:05am UTC](https://community.glideapps.com/t/inserting-multiple-data-into-one-column/63567 "2023-07-06T11:05:01Z")\
**Posts on this page:** 1\
**Showing post:** 11

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 7, 2023, 9:15am UTC](https://community.glideapps.com/t/inserting-multiple-data-into-one-column/63567/11 "2023-07-07T09:15:24Z")

</div>

> [@AbdulGhafor\_abbas](#):
>
> i noticed a type of Bug tho :  
> if timestamps is a date type: it shows only one date although it has 3 timestamps now :  
> ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cbc6815eb26da6c2bd9372c94f7a90e0cdd5314e.png)

Yes, I think that’s expected. If you make it a datetime column, then Glide will do its best to convert whatever you enter into a single datetime value. Have a browse through the below thread to learn more about that:

> [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684):
>
> I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right now. Working on these posts re-triggered this memory. What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of te…

For your use case, it needs to be a text column.

> [@AbdulGhafor\_abbas](#):
>
> i will try to update this, but idk i use timestamps in my whole app. but i will search how to do that.

What I would do is convert it to an integer using a math column, and store that in the array. Then use the Text to Date plugin to convert it back to a timestamp when it needs to be used. For the first step - assuming that you want to include minutes & seconds - then you could use the following formula:

```auto
Year(Now) * 10000000000
+ Month(Now) * 100000000
+ Day(Now) * 1000000
+ Hour(Now) * 10000
+ Minute(Now) * 100
+ Second(Now)

```

Then to convert that back later, use the Text to Date column with the following pattern:

```auto
yyyyMMddhhmmss

```

Here is how that would look:

 ![CleanShot 2023-07-07 at 17.14.26@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0e638a34f4ed9c64ffed1eac118c933574b0e4af.png)

---

_[View the full topic](https://community.glideapps.com/t/inserting-multiple-data-into-one-column/63567)._